private void flightInstanceBtn_Click(object sender, RoutedEventArgs e) { try { //check if (!db.checkFlightInstance(flightInstanceComboBox.SelectedItem.ToString(), flightInstanceCal.SelectedDate.Value)) { errorMsg.Content = "Flight Instance does not exist."; } else { DataTable dt = db.getPassengers(flightInstanceComboBox.SelectedItem.ToString(), flightInstanceCal.SelectedDate.Value); if (dt.Rows.Count == 0) { errorMsg.Content = "This flight instance has no passengers."; } else { passengersDataGrid.DataContext = dt.DefaultView; errorMsg.Content = ""; remainingSeatsLabel.Content = "Remaining Seats: " + db.getRemainingSeats(flightInstanceComboBox.SelectedValue.ToString(), flightInstanceCal.SelectedDate.Value); } } //populate //remaining seats } catch (Exception ex) { Console.WriteLine(ex); } }
private void OKBtn_Click(object sender, RoutedEventArgs e) { //check string arr = "arr"; string dep = "dep"; if (!leavingAirports.Content.Equals("") && !returningAirports.Content.Equals("")) { arr = leavingAirports.Content.ToString().Substring(leavingAirports.Content.ToString().Length - 3); dep = returningAirports.Content.ToString().Substring(0, 3); } if (multiWayRadio.IsChecked == true) { if (pidComboBox.SelectedValue == "" || leavingCal.SelectedDate == null || leaveFlightComboBox.SelectedValue == "" || returningFlightComboBox.SelectedValue == "" || returningCal.SelectedDate == null) { errorMsg.Content = "All fields must be selected."; } else if (!db.checkFlightInstance(leaveFlightComboBox.SelectedValue.ToString(), leavingCal.SelectedDate.Value)) { errorMsg.Content = "First flight does not exist."; } else if (!db.checkFlightInstance(returningFlightComboBox.SelectedValue.ToString(), returningCal.SelectedDate.Value)) { errorMsg.Content = "Second flight does not exist."; } else if (!db.checkEmptySpace(leaveFlightComboBox.SelectedValue.ToString(), leavingCal.SelectedDate.Value)) { errorMsg.Content = "No empty space on first flight."; } else if (!db.checkEmptySpace(returningFlightComboBox.SelectedValue.ToString(), returningCal.SelectedDate.Value)) { errorMsg.Content = "No empty space on second flight."; } else if (!arr.Equals(dep)) { errorMsg.Content = "Arrival airport of first flight must be the same as the departure flight of the second flight."; } else if (checkCalDays()) { db.insertBookings(leaveFlightComboBox.SelectedValue.ToString(), leavingCal.SelectedDate.Value, pidComboBox.SelectedValue.ToString()); db.insertBookings(returningFlightComboBox.SelectedValue.ToString(), returningCal.SelectedDate.Value, pidComboBox.SelectedValue.ToString()); this.Close(); } } else { if (pidComboBox.SelectedValue == "" || leavingCal.SelectedDate == null || leaveFlightComboBox.SelectedValue == "") { errorMsg.Content = "All fields must be selected."; } else if (!db.checkFlightInstance(leaveFlightComboBox.SelectedValue.ToString(), leavingCal.SelectedDate.Value)) { errorMsg.Content = "Flight does not exist."; } else if (!db.checkEmptySpace(leaveFlightComboBox.SelectedValue.ToString(), leavingCal.SelectedDate.Value)) { errorMsg.Content = "No empty space on flight."; } else { db.insertBookings(leaveFlightComboBox.SelectedValue.ToString(), leavingCal.SelectedDate.Value, pidComboBox.SelectedValue.ToString()); this.Close(); } } }