protected void lbtnUpdate_Click(object sender, EventArgs e) { string var = lbtnUpdate.Text; if (var == "Update") { UsersCS sr = new UsersCS(); if (RouteData.Values["user_id"] != null) { sr.User_ID = Convert.ToInt32(RouteData.Values["user_id"]); sr.User_Email = txtEmail.Text.Trim(); sr.User_First = txtFirstName.Text.Trim(); sr.User_Last = txtLastName.Text.Trim(); sr.User_Add1 = txtAddress1.Text.Trim(); sr.User_Add2 = txtAddress2.Text.Trim(); sr.User_City = txtCity.Text.Trim(); sr.State_ID = ddlState.SelectedValue; sr.User_Zip = txtZip.Text.Trim(); sr.User_Salt = txtPassword.Text.Trim(); sr.User_Pwd = txtConfirmPassword.Text.Trim(); sr.User_Phone = txtPhone.Text.Trim(); sr.User_Active = cbIsActive.Checked; UsersCS.UpdateUser(sr); Response.Redirect("~/Admin/Users"); } } else { UsersCS sr = new UsersCS(); //sr.User_ID = Convert.ToInt32(RouteData.Values["sect_id"]); sr.User_Email = txtEmail.Text.Trim(); sr.User_First = txtFirstName.Text.Trim(); sr.User_Last = txtLastName.Text.Trim(); sr.User_Add1 = txtAddress1.Text.Trim(); sr.User_Add2 = txtAddress2.Text.Trim(); sr.User_City = txtCity.Text.Trim(); sr.State_ID = ddlState.SelectedValue; sr.User_Zip = txtZip.Text.Trim(); sr.User_Salt = txtPassword.Text.Trim(); sr.User_Pwd = txtPassword.Text.Trim(); sr.User_Phone = txtPhone.Text.Trim(); sr.User_Active = cbIsActive.Checked; UsersCS.InsertUser(sr); Response.Redirect("~/Admin/Users"); } }
protected void Page_Load(object sender, EventArgs e) { if (!Request.IsAuthenticated) { Response.Redirect("~/Home"); } int user_id = Convert.ToInt32(RouteData.Values["user_id"]); if (!IsPostBack) { if (user_id > 0) { lbtnUpdate.Text = "Update"; UsersCS mt = new UsersCS(user_id); txtEmail.Text = mt.User_Email; txtFirstName.Text = mt.User_First; txtLastName.Text = mt.User_Last; txtAddress1.Text = mt.User_Add1; txtAddress2.Text = mt.User_Add2; txtCity.Text = mt.User_City; ddlState.SelectedValue = mt.State_ID.ToString(); txtZip.Text = mt.User_Zip; txtPassword.Text = mt.User_Pwd; txtPhone.Text = mt.User_Phone; cbIsActive.Checked = mt.User_Active; } else { lbtnUpdate.Text = "Add"; //blank Values txtEmail.Text = String.Empty; txtFirstName.Text = String.Empty; txtLastName.Text = String.Empty; txtAddress1.Text = String.Empty; txtAddress2.Text = String.Empty; txtCity.Text = String.Empty; ddlState.SelectedValue = null; txtZip.Text = String.Empty; txtPassword.Text = String.Empty; txtPhone.Text = String.Empty; cbIsActive.Checked = false; } } }
protected void lbtnUpdate_Click(object sender, EventArgs e) { ReservationsCS sr = new ReservationsCS(); if (RouteData.Values["res_id"] != null) //Write res -> DB { bool result = false; sr.Res_Id = Convert.ToInt32(RouteData.Values["res_id"]); //sr.Guest_Id = Convert.ToInt32(RouteData.Values["guest_id"]); sr.Guest_Id = Convert.ToInt32(hfGuestId.Value); //error thrown sr.Table_Id = Convert.ToInt32(hfTblId.Value); //sr.Table_Id = Convert.ToInt32(RouteData.Values["tbl_id"]); sr.User_Id = Convert.ToInt32(ddlEmployee.SelectedValue); sr.Res_Date = txtDate.Text.ToString(); sr.Res_Time = txtTime.Text.ToString(); sr.Res_Guest_Cnt = Convert.ToInt32(ddlGuestCnt.SelectedValue); sr.Res_Sp_Req = txtSpReq.Text.Trim(); result = ReservationsCS.UpdateReservation(sr); if (result) { Response.Redirect("~/Admin/Reservation-Management"); } //Response.Redirect("~/ResMgmt"); } else { int new_id = 0; GuestCS ng = new GuestCS(); //for guests default pwd is 'password' ng.Guest_Pwd = UsersCS.CreatePasswordHash(ng.Guest_Salt, "password"); ng.Guest_First = txtFName.Text.Trim(); ng.Guest_Last = txtLName.Text.Trim(); ng.Guest_Email = txtEmail.Text.Trim(); ng.Guest_Phone = txtPhone.Text.Trim(); GuestCS og = new GuestCS(txtEmail.Text); if (og.Guest_ID > 0) { sr.Guest_Id = og.Guest_ID; } else { sr.Guest_Id = GuestCS.InsertGuest(ng); } sr.Table_Id = ReservationsCS.GetAvailableTable(txtDate.Text, txtTime.Text, Convert.ToInt32(ddlGuestCnt.SelectedValue)); sr.User_Id = Convert.ToInt32(ddlEmployee.SelectedValue.ToString()); sr.Res_Date = txtDate.Text.Trim(); sr.Res_Time = txtTime.Text.Trim(); sr.Res_Guest_Cnt = Convert.ToInt32(ddlGuestCnt.SelectedValue); sr.Res_Sp_Req = txtSpReq.Text.Trim(); new_id = ReservationsCS.InsertReservation(sr); lblResult.Text = String.Concat("Guest's Email: " + ng.Guest_Email + " Reservation ID: " + new_id); //Response.Redirect("~/Reservations"); } }