/// <summary> /// Gets a list of flight objects of all current flights in the database. /// </summary> /// <returns></returns> public List <clsFlight> GetAllFlights() { List <clsFlight> flights = new List <clsFlight>(); try { DataSet ds = new DataSet(); int iRet = 0; ds = clsData.ExecuteSQLStatement(sql.GetAllFlights(), ref iRet); for (int i = 0; i < iRet; ++i) { clsFlight flight = new clsFlight(); flight.FlightID = Convert.ToInt32(ds.Tables[0].Rows[i][0].ToString()); flight.FlightNum = Convert.ToInt32(ds.Tables[0].Rows[i][1].ToString()); flight.FlightType = ds.Tables[0].Rows[i][2].ToString(); flights.Add(flight); } } catch (Exception ex) { throw new Exception(MethodInfo.GetCurrentMethod().DeclaringType.Name + "." + MethodInfo.GetCurrentMethod().Name + " -> " + ex.Message); } return(flights); }
private void cbChooseFlight_SelectionChanged(object sender, SelectionChangedEventArgs e) { try { selFlight = (clsFlight)cbChooseFlight.SelectedItem; cbChoosePassenger.IsEnabled = true; gPassengerCommands.IsEnabled = true; if (selFlight.FlightID == 1) { CanvasA380.Visibility = Visibility.Hidden; Canvas767.Visibility = Visibility.Visible; } else { Canvas767.Visibility = Visibility.Hidden; CanvasA380.Visibility = Visibility.Visible; } cbChoosePassenger.ItemsSource = null; cbChoosePassenger.ItemsSource = Flightman.GetFlightPassengers(selFlight.FlightID); //colorSeats(selFlight.FlightID); } catch (Exception ex) { HandleError(MethodInfo.GetCurrentMethod().DeclaringType.Name, MethodInfo.GetCurrentMethod().Name, ex.Message); } }
/// <summary> /// Gets the flight information from the database and returns a list of LFight objects /// </summary> /// <returns></returns> public List <clsFlight> GetFlights() { try { DataSet ds; clsFlight FlightOne; string sSQL; int iCount = 0; // Get the Flight information from the database. sSQL = "Select * FROM Flight"; ds = db.ExecuteSQLStatement(sSQL, ref iCount); for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { FlightOne = new clsFlight(); FlightOne.FlightID = ((int)ds.Tables[0].Rows[i][0]); FlightOne.Flight_Number = ds.Tables[0].Rows[i][1].ToString(); FlightOne.Aircraft_Type = ds.Tables[0].Rows[i][2].ToString(); Flights.Add(FlightOne); }// End For return(Flights); } catch (Exception ex) { throw new Exception(MethodInfo.GetCurrentMethod().DeclaringType.Name + "-" + MethodInfo.GetCurrentMethod().Name + "->" + ex.Message); } }
public MainWindow() { try { InitializeComponent(); Application.Current.ShutdownMode = ShutdownMode.OnMainWindowClose; wndAddPass = new wndAddPassenger(); Flightman = new clsFlightManager(); selFlight = new clsFlight(); cbChooseFlight.ItemsSource = Flightman.GetFlights(); } catch (Exception ex) { HandleError(MethodInfo.GetCurrentMethod().DeclaringType.Name, MethodInfo.GetCurrentMethod().Name, ex.Message); } }