protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
//clear old values -> populate ddlGuestCnt
ddlGuestCnt.Items.Clear();
for (int i = 0; i <= 15; i++)
{
ddlGuestCnt.Items.Add(new ListItem(i.ToString()));
}
//check url for res_id
int res_Id = Convert.ToInt32(RouteData.Values["res_id"]);
if (res_Id > 0)
{
guestInsert.Visible = false;
//new reservation
ReservationsCS mt = new ReservationsCS(res_Id);
hfGuestId.Value = mt.Guest_Id.ToString();
hfTblId.Value = mt.Table_Id.ToString();
ddlEmployee.SelectedValue = mt.User_Id.ToString();
txtDate.Text = mt.Res_Date;
txtTime.Text = mt.Res_Time;
ddlGuestCnt.SelectedValue = mt.Res_Guest_Cnt.ToString();
txtSpReq.Text = mt.Res_Sp_Req;
lbtnUpdate.Text = "Update";
}
else //if no res id go to add
{
//update reservation
GuestCS gt = new GuestCS();
txtFName.Text = gt.Guest_First;
txtLName.Text = gt.Guest_Last;
txtEmail.Text = gt.Guest_Email;
txtPhone.Text = gt.Guest_Phone;
ReservationsCS rd = new ReservationsCS(res_Id);
ddlEmployee.SelectedValue = null;
txtDate.Text = String.Empty;
txtTime.Text = String.Empty;
ddlGuestCnt.SelectedValue = String.Empty;
txtSpReq.Text = String.Empty;
lbtnUpdate.Text = "Add";
}
}
}
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");
}
}
