private void fillText()
{
int numofpassengers = 0;
int maxofpassengers = PassengerContainer.getNumPassenger();
richTextBox1.ReadOnly = true;
richTextBox1.Text = "Showing " + maxofpassengers + " Passenger(s) information: \n";
while (numofpassengers < maxofpassengers)
{
richTextBox1.Text += "\nPassenger: " + ReserveP.getPassenger();
richTextBox1.Text += "\nSeat Information: " + ReserveP.getSeatInfo() + "\n";
numofpassengers++;
}
SQLConnection.Instance.OpenConnection();
insertReserve();
insertTicket();
SQLConnection.Instance.CloseConnection();
fillEmail();
MessageBox.Show("Email Confirmation of Reservation send shortly.");
}
/// <summary>
/// Seat button Calls the class Passenger Container that will save all the passengers in a list to use for the seat form.
/// The seat form is created and Passenger's form is closed.
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void seat_button2_Click(object sender, EventArgs e)
{
//fill passenger list in class
//PassengerContainer.loadPassengers(FlightP.getFlightNumber(), AccountP.getAccountID());
PassengerContainer.loadPassengers(FlightP.getFlightNumber(), AccountP.getAccountID());
Price.loadPrices(FlightP.getFlightNumber());
Price.resetDiscount();
Seating nfseat = new Seating();
this.Close();
}
public static string getPassenger()
{
string pstr;
string firstname, midname, lastname, age, gender, birthdate;
DateTime birth;
tempID = PassengerContainer.accessPassenger();
DataSet dsPassenger = new DataSet();
SQLConnection.Instance.OpenConnection();
MySqlCommand passData = new MySqlCommand();
MySqlDataAdapter daPass = new MySqlDataAdapter("select * from Passenger where PassengerID = '" + tempID + "';", SQLConnection.Instance.GetConnection());
daPass.Fill(dsPassenger);
SQLConnection.Instance.CloseConnection();
DataRow dataRow = dsPassenger.Tables[0].Rows[0];
firstname = (string)dataRow[1];
midname = (string)dataRow[2];
lastname = (string)dataRow[3];
age = (string)dataRow[4];
gender = (string)dataRow[5];
birth = (DateTime)dataRow[6];
PassengerContainer.removePassengers();
string date = birth.ToString("d");
birthdate = DateTime.Parse(date).ToString("MM-dd-yyyy");
if (string.IsNullOrEmpty(midname))
{
midname = " ";
}
else
{
midname = " " + midname + " ";
}
age = getAge(age);
pstr = firstname + midname + lastname + "\nAge: " + age + " Gender: " + gender + " Birthdate: " + birthdate;
return(pstr);
}
/// <summary>
/// stores the passengers in list so the form can loop back to
/// add their information to our database
/// </summary>
private void fillPassenger()
{
acount = PassengerContainer.getAdultPassengers();
ccount = PassengerContainer.getChildPassengers();
icount = PassengerContainer.getInfantPassengers();
//adult group
if (acount != 0)
{
int count = 0;
if (acount > count)
{
while (count < acount)
{
adultList.Add(count);
count++;
}
}
}
//child group
if (ccount != 0)
{
int index = 0;
if (ccount > index)
{
while (index < ccount)
{
childrenList.Add(index);
index++;
}
}
}
if (icount != 0)
{
int track = 0;
if (acount > track)
{
while (track < icount)
{
infantsList.Add(track);
track++;
}
}
}
}
/// <summary>
/// Saves the seat chosen by user to the corresponding passenger in the database.
/// Removes passenger from passenger list and calls next passenger and
/// if passenger list is empty the form opens the payment form
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void seat_select_button_Click(object sender, EventArgs e)
{
if (select_count > 1)
{
MessageBox.Show(select_count.ToString() + " seats selected. Please select only one seat");
}
else
{
SQLConnection.Instance.OpenConnection();
MySqlCommand seatCommand = new MySqlCommand("UPDATE Seat Set Available = 1 where FlightID = '" + flightNumber + "' AND classSeat = '" + Seat.getClassSeat() + "' AND Row = '" + jlocation + "' AND selectSeat = '" + ilocation + "';", SQLConnection.Instance.GetConnection());
MySqlCommand findseatCommand = new MySqlCommand("select SeatID from Seat where FlightID = '" + flightNumber + "' AND classSeat = '" + Seat.getClassSeat() + "' AND Row = '" + jlocation + "' AND selectSeat = '" + ilocation + "';", SQLConnection.Instance.GetConnection());
seatCommand.ExecuteNonQuery();
Seat.setSeatPassenger(Convert.ToInt32(findseatCommand.ExecuteScalar()));
//passengerID carrier //check
MySqlCommand passengerEnter = new MySqlCommand("UPDATE Passenger Set SeatID = '" + Seat.getSeatPassenger() + "' where PassengerID = '" + PassengerID + "';", SQLConnection.Instance.GetConnection());
passengerEnter.ExecuteNonQuery();
//class into passenger table
MySqlCommand passengerClass = new MySqlCommand("UPDATE Passenger Set Class = '" + Seat.getClassSeat() + "' where PassengerID = '" + PassengerID + "';", SQLConnection.Instance.GetConnection());
passengerClass.ExecuteNonQuery();
SQLConnection.Instance.CloseConnection();
//MessageBox.Show("Seat Reserved on Row: " + jlocation.ToString() + " Column: " + ilocation.ToString() + " SeatID: " + Seat.getSeatPassenger() + " For Passenger: " + PassengerContainer.getPassengerID());
//testing this
PassengerContainer.removePassengers();
if (!PassengerContainer.emptyPassenger())
{
this.Close();
Seating nextperson = new Seating();
}
else
{
this.Close();
Payment payhere = new Payment();
}
}
}
/// <summary>
/// Gets passsenger first and last name to display in the label of the form.
/// </summary>
private void getPassenger()
{
PassengerContainer.setPassengerID(PassengerContainer.accessPassenger());
string FirstName, LastName;
SQLConnection.Instance.OpenConnection();
MySqlCommand findFirst = new MySqlCommand("select FirstName from Passenger where PassengerID = '" + PassengerContainer.getPassengerID() + "';", SQLConnection.Instance.GetConnection());
FirstName = (string)findFirst.ExecuteScalar();
MySqlCommand findLast = new MySqlCommand("select LastName from Passenger where PassengerID = '" + PassengerContainer.getPassengerID() + "';", SQLConnection.Instance.GetConnection());
LastName = (string)findLast.ExecuteScalar();
pass_info_label.Text = "Passenger: " + FirstName + " " + LastName;
SQLConnection.Instance.CloseConnection();
}
/// <summary>
/// This function saves the number of adult, child and/or infants that were selected in the comboboxes
/// to use in the passenger and seat form
/// </summary>
private void getPassengers()
{
if (adult_comboBox1.SelectedItem != null)
{
//Start.adultPassengers = int.Parse(adult_comboBox1.SelectedItem.ToString());
PassengerContainer.setAdultPassengers(int.Parse(adult_comboBox1.SelectedItem.ToString()));
}
if (child_comboBox2.SelectedItem != null)
{
//Start.childPassengers = int.Parse(child_comboBox2.SelectedItem.ToString());
PassengerContainer.setChildPassengers(int.Parse(child_comboBox2.SelectedItem.ToString()));
}
if (infant_comboBox3.SelectedItem != null)
{
//Start.infantPassengers = int.Parse(infant_comboBox3.SelectedItem.ToString());
PassengerContainer.setInfantPassengers(int.Parse(infant_comboBox3.SelectedItem.ToString()));
}
}
private void button1_Click(object sender, EventArgs e)
{
int seatID = Seat.randomSeat(Seat.getClassSeat(), airplaneTotaSeats, flightNumber);
SQLConnection.Instance.OpenConnection();
MySqlCommand seatCommand = new MySqlCommand("UPDATE Seat Set Available = 1 where SeatID = '" + seatID + "';", SQLConnection.Instance.GetConnection());
//MySqlCommand findseatCommand = new MySqlCommand("select SeatID from Seat where FlightID = '" + FlightP.getFlightNumber() + "' AND classSeat = '" + Seat.getClassSeat() + "' AND Row = '" + jlocation + "' AND selectSeat = '" + ilocation + "';", SQLConnection.Instance.GetConnection());
seatCommand.ExecuteNonQuery();
//Seat.setSeatPassenger(Convert.ToInt32(findseatCommand.ExecuteScalar()));
//Seat.setSeatPassenger(seatID);
//passengerID carrier //check
MySqlCommand passengerEnter = new MySqlCommand("UPDATE Passenger Set SeatID = '" + seatID + "' where PassengerID = '" + PassengerID + "';", SQLConnection.Instance.GetConnection());
passengerEnter.ExecuteNonQuery();
//class into passenger table
MySqlCommand passengerClass = new MySqlCommand("UPDATE Passenger Set Class = '" + Seat.getClassSeat() + "' where PassengerID = '" + PassengerID + "';", SQLConnection.Instance.GetConnection());
passengerClass.ExecuteNonQuery();
SQLConnection.Instance.CloseConnection();
Price.Discount();
PassengerContainer.removePassengers();
if (!PassengerContainer.emptyPassenger())
{
this.Close();
Seating nextperson = new Seating();
}
else
{
this.Close();
Payment payhere = new Payment();
}
}
private void fillGrid()
{
PassengerContainer.loadPassengers(FlightP.getFlightNumber(), AccountP.getAccountID());
}
