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