protected void btnSubmit_Click(object sender, EventArgs e)
        {
            //Declare new guest object
            App_Code.Guest gst = new App_Code.Guest();

            gst.guest_email = txtEmail.Text;
            gst.guest_first = txtFirstName.Text;
            gst.guest_last  = txtLastName.Text;
            gst.guest_phone = txtPhone.Text;



            //save new reservation in a data table
            App_Code.Reservation res = new App_Code.Reservation();

            TimeSpan reservationTime = new TimeSpan();

            res.guest_email   = txtEmail.Text;
            res.res_date      = Calendar1.SelectedDate;
            res.res_time      = reservationTime; //do some shit with timespan to merge hours and mins
            res.res_guest_cnt = Convert.ToInt32(ddlNumGuest.SelectedValue);
            res.saveReservation();
        }
 /// <summary>
 /// Updates the textboxes that contain the guest information
 /// </summary>
 private void updateGuestBoxes()
 {
     ArrayList myArrList = new ArrayList();
     myArrList = App_Code.GuestDB.getCustomerFolio(Convert.ToInt32(gvGuestFolio.SelectedRow.Cells[0].Text));
     //if there are no items in the arrayList then there is no discount
     if (myArrList.Count == 0)
     {
     }
     else
     {
         App_Code.Guest currentGuest = new App_Code.Guest();
         txtSalutation.Text = myArrList[0].ToString();
         txtShowFirstName.Text = myArrList[1].ToString();
         txtShowSurname.Text = myArrList[2].ToString();
         txtAddress.Text = myArrList[3].ToString();
         txtCity.Text = myArrList[4].ToString();
         txtState.Text = myArrList[5].ToString();
         txtPostalCode.Text = myArrList[6].ToString();
         txtCountry.Text = myArrList[7].ToString();
         txtPhone.Text = myArrList[8].ToString();
         txtEmail.Text = myArrList[9].ToString();
         txtGuestID.Text = myArrList[10].ToString();
         txtIssueCountry.Text = myArrList[11].ToString();
         txtComments.Text = myArrList[12].ToString();
     }
 }