private static void fillPassengers()
{
int passID = PassengerInfo.accessPassenger();
while (!PassengerInfo.emptyPassenger())
{
ResetSeat(passID);
deletePassengers(passID);
PassengerInfo.removePassengers();
}
}
private static void clearSeats()
{
PassengerInfo.loadPassengersReserve(ReserveP.getTicketID());
SQLConnection.Instance.OpenConnection();
fillPassengers();
SQLConnection.Instance.CloseConnection();
//MessageBox.Show("Reservation Succesfully Removed.");
}
private void fillPassenger()
{
PassengerID = PassengerInfo.accessPassenger();
PassengerInfo.LoadPassengerInfo(PassengerID);
firstName = PassengerInfo.passengerObject[0].getFirstName();
midName = PassengerInfo.passengerObject[0].getMidName();
lastName = PassengerInfo.passengerObject[0].getLastName();
Age = PassengerInfo.passengerObject[0].getAge();
gender = PassengerInfo.passengerObject[0].getGender();
birthdate = PassengerInfo.passengerObject[0].getDate();
}
private void RefreshForm()
{
adult = 0;
child = 0;
infant = 0;
remove_comboBox1.SelectedIndex = -1;
remove_comboBox1.Items.Clear();
PassengerInfo.loadPassengersReserve(ReserveP.getTicketID());
fillComboBox();
//remove_comboBox1.Refresh();
}
private static void deleteReservation()
{
PassengerInfo.loadPassengersReserve(ticketID);
fareID = Price.getReserveFareID(ticketID);
SQLConnection.Instance.OpenConnection();
fillPassengers();
removeReservation(ticketID);
removeFare(fareID);
SQLConnection.Instance.CloseConnection();
MessageBox.Show("Reservation Succesfully Removed.");
}
private void seat_select_button_Click_1(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();
//updates flight to new flight
MySqlCommand passengerFlight = new MySqlCommand("UPDATE Passenger Set FlightID = '" + flightNumber + "' where PassengerID = '" + PassengerID + "' ;", SQLConnection.Instance.GetConnection());
passengerFlight.ExecuteNonQuery();
SQLConnection.Instance.CloseConnection();
//testing this
//PassengerContainer.removePassengers();
PassengerInfo.removePassengers();
if (!PassengerInfo.emptyPassenger())
{
this.Close();
Seating_Update another = new Seating_Update();
}
else
{
Payment_Update payup = new Payment_Update();
this.Close();
//MessageBox.Show("Payment next");
}
}
}
private void fillText()
{
int numofpassengers = 0;
countPassengers = PassengerInfo.getNumPassengers();
int maxofpassengers = countPassengers;
reserve_richTextBox1.ReadOnly = true;
reserve_richTextBox1.Text = "Showing " + maxofpassengers + " Passenger(s) information: \n";
while (numofpassengers < maxofpassengers)
{
reserve_richTextBox1.Text += "\nPassenger: " + PassengerInfo.getPassenger();
reserve_richTextBox1.Text += "\nSeat Information: " + PassengerInfo.getSeatInfo() + "\n";
numofpassengers++;
}
reserve_richTextBox1.Text += "\n";
}
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());
seatCommand.ExecuteNonQuery();
//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();
//updates flight to new flight
MySqlCommand passengerFlight = new MySqlCommand("UPDATE Passenger Set FlightID = '" + flightNumber + "' where PassengerID = '" + PassengerID + "' ;", SQLConnection.Instance.GetConnection());
passengerFlight.ExecuteNonQuery();
SQLConnection.Instance.CloseConnection();
Price.Discount();
PassengerInfo.removePassengers();
if (!PassengerInfo.emptyPassenger())
{
this.Close();
Seating_Update another = new Seating_Update();
}
else
{
Payment_Update payup = new Payment_Update();
this.Close();
//MessageBox.Show("Payment next");
}
}
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();
}
}
public static void LoadPassengerInfo(int passNumber)
{
DataSet dsPasssenger = new DataSet();
SQLConnection.Instance.OpenConnection();
MySqlCommand findPassengers = new MySqlCommand("select * from Passenger where PassengerID = '" + passNumber + "';", SQLConnection.Instance.GetConnection());
MySqlDataAdapter daPassenger = new MySqlDataAdapter(findPassengers);
daPassenger.Fill(dsPasssenger);
SQLConnection.Instance.CloseConnection();
passengerObject[0] = new PassengerInfo();
DataRow dataRow = dsPasssenger.Tables[0].Rows[0];
passengerObject[0].setFirstName((string)dataRow[1]);
passengerObject[0].setMidName((string)dataRow[2]);
passengerObject[0].setLastName((string)dataRow[3]);
passengerObject[0].setAge((string)dataRow[4]);
passengerObject[0].setGender((string)dataRow[5]);
passengerObject[0].setDate((DateTime)dataRow[6]);
}
private void SFlight_Click(object sender, EventArgs e)
{
if (FlightP.getFlightNumber() == 0)
{
getFirst();
}
int newflight = FlightP.getFlightNumber();
ReserveP.setFlightNumber(ReserveP.getTicketID());
int oldflight = ReserveP.getFlightNumber();
//MessageBox.Show("Selected: 3:" + newflight.ToString() + " Reservation: 1:" + oldflight.ToString());
//keep user from entering same flight again
if (newflight == oldflight)
{
MessageBox.Show("Please select a different flight.");
Arrival_combobox.SelectedIndex = -1;
Depart_Date.Value = System.DateTime.Now;
int zero = 0;
FlightP.setFlightNumber(zero);
}
else
{
// clear reservation seats from previous flight
// load passengers to pick new seat on this flight
clearSeats();
PassengerInfo.loadPassengersReserve(ReserveP.getTicketID());
Price.loadPrices(FlightP.getFlightNumber());
Price.resetDiscount();
Seating_Update newseats = new Seating_Update();
this.Close();
}
}
private void fillPassenger()
{
PassengerID = PassengerInfo.accessPassenger();
PassengerInfo.LoadPassengerInfo(PassengerID);
firstName = PassengerInfo.passengerObject[0].getFirstName();
lastName = PassengerInfo.passengerObject[0].getLastName();
Age = PassengerInfo.passengerObject[0].getAge();
if (Age == "Adult")
{
adult++;
}
else if (Age == "Children")
{
child++;
}
else
{
infant++;
}
name = PassengerID + " " + firstName + " " + lastName + " " + Age;
remove_comboBox1.Items.Add(name);
}
private void getPassengerInfo()
{
PassengerInfo.loadPassengersReserve(ticketID);
}
/// <summary>
/// Gets passsenger first and last name to display in the label of the form.
/// </summary>
private void getPassenger()
{
PassengerInfo.setPassengerID(PassengerInfo.accessPassenger());
PassengerInfo.LoadPassengerInfo(PassengerInfo.getPassengerID());
pass_info_label.Text = "Passenger: " + PassengerInfo.passengerObject[0].getFirstName() + " " + PassengerInfo.passengerObject[0].getLastName();
}
