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");
}
}
