Riding Buses

Today Jonny spent a bit of time riding buses. He had a meeting in Death Valley. So he took a walk to the Blake Transit Center on Fourth Avenue, one block past Main Street in time to catch the 12:03 #2 bus. Hollywood is at 3rd street and William, so the trip wasn't 4 blocks. There is no 3rd, 2nd or 1st avenue's in Ann Arbor. There is a 2nd street, 1st Street and Ashley Street. After sprinting to the bus, he rode for 30 minutes until arriving at the Green Road Park and Ride. There he caught the Hotel California Intercampus East. The #2 is an AATA bus. It rides north and east along Plymouth Road. It cuts through town, down to the Hotel California and around it. Then across the river and up hill up Plymouth Road until it gets to the neighborhood. Once on the Intercampus the rider is to tell the driver that they want to go to Death Valley Lobby M, or else it only goes as far as the Bee Hive. Hotel California keeps all their IT staff hundreds of them, including, Michael Rapaport, Angelina's dinner guest tonight in three buildings. Jonny calls this the Bee Hive. Michael is here from Israel with his wife Janeane Garofalo and family for the Summer. They are in Ann Arbor for a month. Michael telecommutes for the IT department all year long from Israel. Once Jonny got to Death Valley he had a meeting about the software product they use. It needs a good name so it won't show up in searches. It was given its real name in earlier posts but now a new name is needed, for this clinical trials based software. Hmmm. How about VASE. It stands for Very Adverse Serious Events. So Penny is on the VASE governor's board. This means Hotel California has many departments using VASE. They want all the departments to agree on possible software requests to ask of VASE headquarters in California. Of course Hotel California has a special VASE department. So there is two VASES, VASE in Death Valley (Ann Arbor) and VASE in california. VASE Death Valley is in Death Valley
only because Hotel California is too stupid to have enough room for all of it's employees. That is why Jonny doesn't even have a desk in Hotel California more than 2 days a week. He is in Hollywood the other 3 days in more space owned by Hotel California. Maybe there needs to be an acronym for the fake name of the hospital. Instead of calling it UMHS, perhaps HCAA or ACHO Ann Arbor California HOtel. Angelina is of course whining about the dinner guests. If not now she will be later. She complains, that she gets no free time and now with 6 people coming over for dinner (2 adults, 4 children), plus the 5 people that live there (2 adults, her and Jonny) plus 3 children (Alberta, Lorraine and Jesse). She called today and said she spent 80 something dollars at Trader Joe's, including, thankfully a replenishment of the beer garden. At this point there was a dangerously low stock of only 1 hop fest straight from Trader Joe's. Now there is probably 6 or 7 of some new and exciting beer with a black dog on it. Jonny left his cell phone at home by mistake. He rode his bike to work. Now remember there is a 6 mile distance between Hollywood and Death Valley, so since it is hot like Death Valley today Jonny elected to ride the bus for about 2 hours round trip. He just got back and showed Lea his ASP.NET program. It has been modified slightly. So now it does what ACHO calls a level 2 login. This makes this dumpy little app more uniform. While riding around Jonny read some more of his prayer book. He is now on page 143 and deep into the Day of Atonement evening service. On the book front he finished Rich Dad, Poor Dad. Angelina took his car and returned Dune too. No way he was gonna finish it. It took 3+ weeks to hear Rich Dad, Poor Dad. It was 7 hours, 5 tapes. Dune was 18 tapes, 1 1/2 each for a total of 27 hours. That would take another 12 weeks. Angelina said in not so many words, your book on CD days are over. Ok time to learn how to make an MSI. This is a ASP.NET deployment package. Jonny's code is down below for reference.

/* Written by Jonny Lee Miller
Written on July 23, 2008
Allows user to change Oracle password via a web form
*/
using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.OracleClient;

using UMRO.LoginService;


public partial class _Default : System.Web.UI.Page
{
OracleConnection con;
OracleCommand command;
//UMRO login object
private UMROLoginService m_Service;

protected void Page_Load(object sender, EventArgs e)
{
TextBox1.Focus();
/* in other words if this really is the first time
* calling this web page, initialize everything */
if (Session["command"] == null)
{
command = new OracleCommand();
con = new OracleConnection();
Session["con"] = con;
Session["command"] = command;
}
else
{
command = (OracleCommand)Session["command"];
con = (OracleConnection)Session["con"];
}
if (!Page.IsPostBack)
{

//--------------------- You need to add these statments to activate login service
//----------Login server begin
//Call LoginService for authentication on UMROWebLogin, a Web service application
try
{
m_Service = new UMROLoginService();

string sLoginName = string.Empty;
string sLogoutURL = string.Empty;
string sServerVer = string.Empty;
m_Service.CallUMROWebLoginService(Request.QueryString.Get("Parm"),
(string)Session["SESSION_ID"],
this.Page, ref sServerVer, ref sLoginName, ref sLogoutURL);
}
catch (Exception ex)
{
Label4.Text = m_Service.GetExceptionErrorMsg(ex);
Label4.Visible = true;
}
//----------Login server end
}
}

protected void Button1_Click(object sender, EventArgs e)
{
con.ConnectionString = "User Id=" + TextBox1.Text +
";Password=" + TextBox2.Text + ";Data Source=crdwmsis;";
try
{
con.Open();
command.Connection = con;
TextBox3.Visible = true;
Label3.Visible = true;
Button2.Visible = true;
Button1.UseSubmitBehavior = false;
Button2.UseSubmitBehavior = true;
TextBox3.Focus();
}
catch
{
TextBox2.Focus();
}
}

protected void Button2_Click(object sender, EventArgs e)
{
command.CommandText = "ALTER USER " + TextBox1.Text +
" IDENTIFIED BY " + TextBox3.Text;
try
{
command.ExecuteNonQuery();
Label4.Visible = true;
}
catch
{
Label4.Text = "Failure to change password, sorry";
Label4.Visible = true;
}
}
}