private void passenger_delete_Click(object sender, EventArgs e)
        {
            int passNum;

            string display = remove_comboBox1.Text;

            string[] strArr    = null;
            char[]   splitchar = { ' ' };
            strArr = display.Split(splitchar);

            passNum = Convert.ToInt32(strArr[0]);
            strAge  = strArr[3];


            if (strAge == "Adult" && (child == 1 || infant == 1))
            {
                MessageBox.Show("Child or Infant must fly with one adult");
            }
            else if (adult == 1 && ((child + infant) == 0))
            {
                MessageBox.Show("Click on Remove Reservation on reservation changes.");
                passenger_delete.Enabled = false;
            }
            else
            {
                changePayment(passNum);

                SQLConnection.Instance.OpenConnection();

                ResetSeat(passNum);
                deletePassenger(passNum);

                MessageBox.Show("Successfully Removed Passenger and refunded Payment.");
                SQLConnection.Instance.CloseConnection();
                //find the seat and set to 0
                //then delete
                //reduce payment
                MessageBox.Show("Confirmationn of Changes Emailed send shortly.");
                Passenger_Changes.fillEmail();

                RefreshForm();
            }
        }
        private void button1_Click(object sender, EventArgs e)
        {
            checkChanges();

            PassengerInfo.removePassengers();

            if (!PassengerInfo.emptyPassenger())
            {
                clearForm();
                fillPassenger();
                fillText();
                RefreshForm();
            }
            else
            {
                MessageBox.Show("Confirmationn of Changes Emailed send shortly.");
                Passenger_Changes.fillEmail();
                this.Close();
                Reserve_Update back2back = new Reserve_Update();
            }
        }