private void changePayment(int num)
{
string ticket = ReserveP.getTicketID();
int total = Price.getReserveAmount(ticket);
int fareID = Price.getReserveFareID(ticket);
string seatclass;
SQLConnection.Instance.OpenConnection();
MySqlCommand sclass = new MySqlCommand("Select Class from Passenger where PassengerID = '" + num + "';", SQLConnection.Instance.GetConnection());
seatclass = (string)sclass.ExecuteScalar();
seatclass = getClassName(seatclass);
int flight;
MySqlCommand findflight = new MySqlCommand("Select FlightID from Fare where FareID = '" + fareID + "';", SQLConnection.Instance.GetConnection());
flight = Convert.ToInt32(findflight.ExecuteScalar());
int subtotal;
MySqlCommand findClass = new MySqlCommand("Select " + seatclass + " from Flight where FlightID = '" + flight + "';", SQLConnection.Instance.GetConnection());
subtotal = Convert.ToInt32(findClass.ExecuteScalar());
total = total - subtotal;
MySqlCommand updateFare = new MySqlCommand("UPDATE Fare set Amount = '" + total + "' where FareID = '" + fareID + "';", SQLConnection.Instance.GetConnection());
updateFare.ExecuteNonQuery();
SQLConnection.Instance.CloseConnection();
}
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 next_payment_button_Click(object sender, EventArgs e)
{
int fareID = Price.getReserveFareID(ticket);
SQLConnection.Instance.OpenConnection();
MySqlCommand updateFare = new MySqlCommand("UPDATE Fare set Amount = '" + totalPayment + "' where FareID = '" + fareID + "';", SQLConnection.Instance.GetConnection());
updateFare.ExecuteNonQuery();
MySqlCommand updateReserve = new MySqlCommand("UPDATE Reserve set FlightID = '" + FlightP.getFlightNumber() + "' where ticketNo = '" + ticket + "';", SQLConnection.Instance.GetConnection());
updateReserve.ExecuteNonQuery();
SQLConnection.Instance.CloseConnection();
fillEmail();
MessageBox.Show("Email Confirmation of Flight Change will be shortly send");
Account back = new Account();
this.Close();
}
