//Удалить рейс private void ButtonClick_DelFlight(object sender, RoutedEventArgs e) { try { MyDataContext dboperator = new MyDataContext(CurrentUser.connectionString); int index = DataGridFlights.SelectedIndex; dynamic std = DataGridFlights.SelectedItems; short ind = std[0].FlightID; string ind2 = std[0].SideNumber; dboperator.ExecuteCommand("DELETE FROM Flight where FlightID = {0}", ind); DataGridFlights.Items.RemoveAt(index); Aircraft Aircr = dboperator.aircrafts.Where(airc => airc.SideNumber == ind2).FirstOrDefault(); Aircr.IsFree = true; dboperator.SubmitChanges(); } catch { ErrorTextBlock.Text = "Выделите строку для удаления"; ErrorTextBlock.Visibility = Visibility.Visible; } }
private void ButtonClick_DeleteAircraft(object sender, RoutedEventArgs e) { try { ErrorTextBlock.Visibility = Visibility.Collapsed; MyDataContext dboperator = new MyDataContext(CurrentUser.connectionString); int index = DataGridAircraft.SelectedIndex; IList delaircraft = DataGridAircraft.SelectedItems; if (!(delaircraft[0] as Aircraft).IsFree) { ErrorTextBlock.Text = "Операция запрещена пока самолет находится в расписании"; ErrorTextBlock.Visibility = Visibility.Visible; } else { dboperator.ExecuteCommand("DELETE FROM Aircraft where AircraftID = {0}", (delaircraft[0] as Aircraft).AircraftID); DataGridAircraft.Items.RemoveAt(index); } } catch (Exception) { ErrorTextBlock.Text = "Выделите строку для удаления"; ErrorTextBlock.Visibility = Visibility.Visible; } }
private void ButtonClick_DeleteAirline(object sender, RoutedEventArgs e) { try { ErrorTextBlock.Visibility = Visibility.Collapsed; MyDataContext dboperator = new MyDataContext(CurrentUser.connectionString); int index = DataGridAirline.SelectedIndex; IList delairline = DataGridAirline.SelectedItems; dboperator.ExecuteCommand("DELETE FROM Airline where AirlineID = {0}", (delairline[0] as Airline).AirlineID); DataGridAirline.Items.RemoveAt(index); } catch (Exception) { ErrorTextBlock.Visibility = Visibility.Visible; } Message.IsOpen = false; }