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 void SendEmail(string emailTo)
{
string smtpAddress = "smtp.gmail.com";
int portNumber = 587;
bool enableSSL = true;
string emailFrom = "*****@*****.**";
string password = "******";
string subject = "Reservation Flight Change";
string body = "Hi,\nThis email to confirm that reservation" + ReserveP.getTicketID() + "has had the flight change to Airline "
+ FlightContainer.flightObject[0].getAirline() +
" from " + FlightContainer.flightObject[0].getDepart() +
" to " + FlightContainer.flightObject[0].getArrive() +
"\nPrice: $" + Price.getReserveAmount(ReserveP.getTicketID());
try
{
using (MailMessage mail = new MailMessage())
{
mail.From = new MailAddress(emailFrom);
mail.To.Add(emailTo);
mail.Subject = subject;
mail.Body = body;
mail.IsBodyHtml = true;
// Can set to false, if you are sending pure text.
//mail.Attachments.Add(new Attachment("C:\\SomeFile.txt"));
//mail.Attachments.Add(new Attachment("C:\\SomeZip.zip"));
using (SmtpClient smtp = new SmtpClient(smtpAddress, portNumber))
{
smtp.Credentials = new NetworkCredential(emailFrom, password);
smtp.EnableSsl = enableSSL;
smtp.Send(mail);
}
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
private void fillLabels()
{
setTicketID(ReserveP.getTicketID());
//MessageBox.Show(ticketID);
SQLConnection.Instance.OpenConnection();
int flight;
MySqlCommand findFlight = new MySqlCommand("Select FlightID from Reserve where ticketNo = '" + ticketID + "';", SQLConnection.Instance.GetConnection());
flight = Convert.ToInt32(findFlight.ExecuteScalar());
SQLConnection.Instance.CloseConnection();
FlightContainer.loadFlight(flight);
flight_label1.Text += " #" + FlightContainer.flightObject[0].getFlightNo() + " " + FlightContainer.flightObject[0].getDepart() +
" to " + FlightContainer.flightObject[0].getArrive() + " Price: $" + Price.getReserveAmount(ticketID);
}
private void fillText()
{
int numofpassengers = 0;
int maxofpassengers = PassengerInfo.getNumPassengers();
reservations_richTextBox1.Text += "Ticket: " + tnumber + " Date Reserved: " + ReserveP.getReserveDate(tnumber) + "\nFlignt number is: " + fnumber + " Airline is " + FlightContainer.flightObject[0].getAirline() +
" from " + FlightContainer.flightObject[0].getDepart() +
" to " + FlightContainer.flightObject[0].getArrive() + "\nPrice: $" + Price.getReserveAmount(tnumber);
reservations_richTextBox1.Text += " Showing " + maxofpassengers + " Passenger(s) information: \n";
while (numofpassengers < maxofpassengers)
{
reservations_richTextBox1.Text += "\nPassenger: " + PassengerInfo.getPassenger();
reservations_richTextBox1.Text += "\nSeat Information: " + PassengerInfo.getSeatInfo() + "\n";
numofpassengers++;
}
removeFlight();
if (!emptyFlight())
{
fillGrid();
}
}
private void getOldTotal()
{
oldtotal_textBox1.Text = "$ " + Price.getReserveAmount(ticket).ToString();
}
