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