protected void Page_Load(object sender, EventArgs e) { String username = Session["username"].ToString(); userDetail ud = new userDetail(username); lblDepartTrip.Text = Session["departureTrip"].ToString(); lblTotal.Text = Session["totalTripCost"].ToString(); toDestination = Session["toDestination"].ToString(); fromDestination = Session["fromDestination"].ToString(); tripType = Session["tripType"].ToString(); totalPassenger = Convert.ToInt32(Session["totalPassenger"].ToString()); departureTime = Session["departureTime"].ToString(); departureDate = Session["departureDate"].ToString(); returnDate = Session["returnDate"].ToString(); customerName = ud.getFullname(); lblCustomerName.Text = customerName; if (tripType == "Round Trip") { lblReturnTrip.Text = Session["returnTrip"].ToString(); returnTime = Session["returnTime"].ToString(); } else { lblReturnTrip.Text = "N/A"; tripType = "One Way"; } }
protected void btnLogin_Click(object sender, EventArgs e) { userDetail ud = new userDetail(txtUsername.Text); if (ud.login(txtUsername.Text, txtPassword.Text) >= 1) { Session["fullname"] = ud.getFullname(); Session["contact"] = ud.getContact(); Session["email"] = ud.getEmail(); Session["username"] = txtUsername.Text.ToString(); Response.Redirect("Home.aspx"); } else { lblStatus.Text = "Login Failed. Please check username and password"; lblStatus.Visible = true; } /*String conString = ConfigurationManager.ConnectionStrings["DDACConnectionString"].ConnectionString; * System.Data.OleDb.OleDbConnection con = new System.Data.OleDb.OleDbConnection(conString); * System.Data.OleDb.OleDbCommand cmd = con.CreateCommand(); * * cmd.CommandText = "SELECT * FROM Student WHERE [Username] = ? AND [Password] = ?"; * cmd.Parameters.Add("User_Name", System.Data.OleDb.OleDbType.VarChar); * cmd.Parameters["User_Name"].Value = this.txtUsername.Text.ToString(); * cmd.Parameters.Add("Password", System.Data.OleDb.OleDbType.VarChar); * cmd.Parameters["Password"].Value = this.txtPassword.Text.ToString(); * int count = 0; * * con.Open(); * System.Data.OleDb.OleDbDataReader dr = cmd.ExecuteReader(); * * while (dr.Read()) * { * * count++; * } * * //lblStatus.Visible = true; * if (count >= 1) * { * Session["username"] = txtUsername.Text.ToString(); * Response.Redirect("Home.aspx"); * } * else * { * lblStatus.Text = "Login Failed. Please check username and password"; * }*/ }