protected void btnRegCard_Click(object sender, EventArgs e) { CheckIn checkIn = new CheckIn(); checkIn.Reservation_ID = SqlInt32.Parse(hidReservationId.Value); DataTable tbaleCard = checkIn.SelectOne_ByReservationID();//FOR registration card // Session["welcomeCard"] = tbaleCard; tbaleCard.TableName = "RegistrationCard"; SecondaryGuests sg = new SecondaryGuests(); sg.Reservation_ID = SqlInt32.Parse(hidReservationId.Value); DataTable tbaleCardSg = sg.SelectAll();//to get the Secondary guest tbaleCardSg.TableName = "Guest"; DataSet DS = new DataSet(); DS.Tables.Add(tbaleCard); DS.Tables.Add(tbaleCardSg); Session["welcomeCard"] = DS; string popupScript = "<script language='javascript'>" + "window.open('RegCard.aspx','ThisPopUp1', " + "'left = 300, top=150, " + "menubar=no, scrollbars=yes, resizable=yes')" + "</script>"; Page.ClientScript.RegisterStartupScript(GetType(), "PopupScript", popupScript); }
private void DeleteAccompanyingGuest(int secGuestId) { SecondaryGuests sg = new SecondaryGuests(); sg.SecondaryGuest_ID = secGuestId; sg.SelectOne(); sg.Delete(); BindSecondaryGuests(); }
private DataTable GetSecondaryGuests() { int reservationId = hidReservationId.Value == string.Empty ? 0 : Int32.Parse(hidReservationId.Value); SecondaryGuests sg = new SecondaryGuests(); sg.Reservation_ID = reservationId; secGuestsTbl = sg.SelectAll(); return(secGuestsTbl); }
protected void btnSaveGuest_Click(object sender, EventArgs e) { if (drpRelationShip.SelectedValue == "-1") { lblGstMsg.Text = "Please select a relationship"; lblGstMsg.ForeColor = Color.Red; return; } if (txtFirstName.Text.Trim() == string.Empty || txtLastName.Text.Trim() == string.Empty) { lblGstMsg.Text = "Please enter First & Last Names"; lblGstMsg.ForeColor = Color.Red; return; } if (txtCivilId.Text.Trim() == string.Empty) { lblGstMsg.Text = "Please enter Civil ID"; lblGstMsg.ForeColor = Color.Red; return; } if (Int32.Parse(hidCurrentOccupancy.Value) == (Int32.Parse(hidMaxOccupancy.Value) + 2)) { lblGstMsg.Text = "Maximum Occupancy with 2 additional guests already reached. "; lblGstMsg.ForeColor = Color.Red; return; } SecondaryGuests sg = new SecondaryGuests(); sg.Reservation_ID = SqlInt32.Parse(hidReservationId.Value); sg.Guest_ID = SqlInt32.Parse(hidGuestId.Value); sg.RelationShip_ID = SqlInt32.Parse(drpRelationShip.SelectedValue); sg.Salutation = SqlInt32.Parse(drpSalutation.SelectedValue); sg.Gender = SqlInt32.Parse(drpGender.SelectedValue); sg.FirstName = txtFirstName.Text.Trim(); sg.MiddleName = string.Empty; //txtMiddleName.Text.Trim() == string.Empty ? string.Empty : txtMiddleName.Text.Trim(); sg.LastName = txtLastName.Text.Trim(); sg.Email = string.Empty; // txtEmail.Text.Trim() == string.Empty ? string.Empty : txtEmail.Text; sg.MobileNumber = txtMobileNumber.Text.Trim(); sg.Civil_ID = txtCivilId.Text.Trim(); sg.Age = 0; sg.LastModifiedDate = Utility.GetSqlDateTimeFromDateTime(DateTime.Today); sg.LastModifiedUser = Utility.GetUserIdFromUserName(HttpContext.Current.User.Identity.Name); if (sg.Insert()) { ClearSessionObjects(); Response.Redirect("Reservation.aspx?Reservation_ID=" + hidReservationId.Value, true); } else { lblGstMsg.Text = "Guest not saved. Please try again"; lblGstMsg.ForeColor = Color.Red; return; } }