//Удалить рейс
        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;
            }
        }
Exemple #3
0
        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;
        }