/// <summary>
/// SQL for adding a new passenger
/// </summary>
/// <param name="FirstName"></param>
/// <param name="LastName"></param>
/// <param name="iFlightID"></param>
public void AddPassenger(string FirstName, string LastName, int iFlightID)
{
try
{
//new instance of clsPassengers class
passenger = new clsPassengers();
//set passengers first name
passenger.sFirstName = FirstName;
//set passengers last name
passenger.sLastName = LastName;
//SQL that adds passenger to database
string sSQL = "INSERT INTO PASSENGER(First_Name, Last_Name) VALUES('" + FirstName + "','" + LastName + "')";
//new instance of clsDataAccess creates an object called db
db = new clsDataAccess();
//excute
db.ExecuteNonQuery(sSQL);
}
catch (Exception ex)
{
throw new Exception(MethodInfo.GetCurrentMethod().DeclaringType.Name + "." + MethodInfo.GetCurrentMethod().Name + " -> " + ex.Message);
}
}
/// <summary>
/// UI Button Event click that saves the new passengers information
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void cmdSave_Click(object sender, RoutedEventArgs e)
{
try
{
FlightManager = new clsFlightManager();
Passenger = new clsPassengers();
wndMainWindow = new MainWindow();
//Enable add passenger save mode
saveMode = true;
//if flight name 767
if (wndMainWindow.cbChooseFlight.ToString() == "412 - Boeing 767")
{
//show 767
wndMainWindow.CanvasA380.Visibility = Visibility.Hidden;
wndMainWindow.Canvas767.Visibility = Visibility.Visible;
//then flight id is 2
wndMainWindow.iFlight_ID = 2;
}
else
{
//show A380
wndMainWindow.Canvas767.Visibility = Visibility.Hidden;
wndMainWindow.CanvasA380.Visibility = Visibility.Visible;
//else flight id is 1
wndMainWindow.iFlight_ID = 1;
}
//Add passenger to database - first name, last name, and which flight they are on
FlightManager.AddPassenger(txtFirstName.Text, txtLastName.Text, wndMainWindow.iFlight_ID);
//Gets the newly added passengers ID
Passenger.sID = FlightManager.GetPassengerID(txtFirstName.Text, txtLastName.Text);
//temp variable to hold passengers id
sTempID = Passenger.sID;
//refresh
wndMainWindow.cbChoosePassenger.Items.Clear();
this.Close();
}
catch (Exception ex)
{
throw new Exception(MethodInfo.GetCurrentMethod().DeclaringType.Name + "." + MethodInfo.GetCurrentMethod().Name + " -> " + ex.Message);
}
}
