//Удалить рейс 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; } }
void QueryFlightNumber() { DataGridFlights.Items.Clear(); MyDataContext dboperator = new MyDataContext(CurrentUser.connectionString); var flights = from fl in dboperator.flights join airc in dboperator.airlines on fl.AirlineID equals airc.AirlineID join air in dboperator.aircrafts on fl.AircraftID equals air.AircraftID where fl.FlightNumber.Contains(SortBox.Text) || air.SideNumber.Contains(SortBox.Text) || air.AircraftModel.Contains(SortBox.Text) || airc.AirlineName.Contains(SortBox.Text) || fl.DepatureCity.Contains(SortBox.Text) || fl.ArrivalCity.Contains(SortBox.Text) select new { fl.ArrivalCity, fl.ArrivalTime, fl.DepartureTime, fl.DepatureCity, fl.FlightNumber, airc.AirlineName, fl.FlightID, air.AircraftModel, air.SideNumber }; foreach (var item in flights) { DataGridFlights.Items.Add(item); } }
public static ComboBox LoadComboBoxSideNumberandAirline(ref ComboBox Airl, ref ComboBox AirlINV, ref ComboBox Aircr, ref ComboBox AircrINV) { Airl.Items.Clear(); AirlINV.Items.Clear(); Aircr.Items.Clear(); AircrINV.Items.Clear(); MyDataContext db = new MyDataContext(connectionString); var aircrafts = from airc in db.aircrafts select new { airc.AircraftID, airc.AircraftModel, airc.IsFree }; var airlines = from airln in db.airlines select new { airln.AirlineID, airln.AirlineName }; foreach (var item in airlines) { Airl.Items.Add(item.AirlineName); AirlINV.Items.Add(item.AirlineID); } foreach (var item in aircrafts) { if (item.IsFree) { Aircr.Items.Add(item.AircraftModel); AircrINV.Items.Add(item.AircraftID); } } return(null); }
public Page1() { InitializeComponent(); MyDataContext dboperator = new MyDataContext(CurrentUser.connectionString); var flights = from fl in dboperator.flights join airc in dboperator.airlines on fl.AirlineID equals airc.AirlineID join air in dboperator.aircrafts on fl.AircraftID equals air.AircraftID select new { fl.ArrivalCity, fl.ArrivalTime, fl.DepartureTime, fl.DepatureCity, fl.FlightNumber, airc.AirlineName, fl.FlightID, air.AircraftModel, air.SideNumber }; foreach (var item in flights) { DataGridFlights.Items.Add(item); } _ComboBoxHours = CurrentUser.LoadComboBoxHours(_ComboBoxHours); _ComboBoxMinutes = CurrentUser.LoadComboBoxMinutes(_ComboBoxMinutes); CurrentUser.LoadComboBoxSideNumberandAirline(ref _ComboBoxAirlineName, ref _ComboBoxAirlineNameINV, ref _ComboBoxSideNumber, ref _ComboBoxSideNumberINV); }
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; } }
public void Sort(bool par, byte addpar) { DataGridAircraft.Items.Clear(); MyDataContext dboperator = new MyDataContext(CurrentUser.connectionString); var aircrafts = from airc in dboperator.aircrafts select airc; if (addpar == 1) { foreach (var item in aircrafts) { DataGridAircraft.Items.Add(item); } return; } else { foreach (var item in aircrafts) { if (item.IsFree == par) { DataGridAircraft.Items.Add(item); } } return; } }
void CurrentOperators() { DataGridAll.Items.Clear(); MyDataContext dboperator = new MyDataContext(CurrentUser.connectionString); var report = from fl in dboperator.flights join airc in dboperator.airlines on fl.AirlineID equals airc.AirlineID join aircrf in dboperator.aircrafts on fl.AircraftID equals aircrf.AircraftID join op in dboperator.operators on fl.OperatorID equals op.OperatorID where op.OperatorID == CurrentUser.CurrentID select new { fl.ArrivalCity, fl.ArrivalTime, fl.DepartureTime, fl.DepatureCity, fl.FlightNumber, airc.AirlineName, aircrf.AircraftModel, aircrf.SideNumber, op.FirstName, op.SecondName }; foreach (var item in report) { DataGridAll.Items.Add(item); } }
//Авторизация в программе private void Button_Click_Login(object sender, RoutedEventArgs e) { MyDataContext dboperator = new MyDataContext(CurrentUser.connectionString); try { var entry = dboperator.ExecuteQuery <Operator>("SELECT * FROM Operator WHERE OperatorLogin COLLATE Latin1_General_CS_AS = {0} AND OperatorPassword COLLATE Latin1_General_CS_AS = {1}", LoginTextBox.Text, PasswordBox.Password).ToList(); if (entry.Count() == 0) { TextBlockMessage.Text = "Неверный логин или пароль, повторите попытку"; WrongPassOrLogin.IsOpen = true; } else { CurrentUser.CurrentID = entry.Single().OperatorID; CurrentUser.FirstName = entry.Single().FirstName; CurrentUser.SecondName = entry.Single().SecondName; Window1 window1 = new Window1(); window1.Show(); this.Close(); } } catch (Exception ex) { TextBlockMessage.Text = "Не удалось подключится к базе данных"; WrongPassOrLogin.IsOpen = true; return; } }
private void ButtonClick_AddAircraft(object sender, RoutedEventArgs e) { if (_TextBlockBusinessClass.Text.Length < 1 || _TextBlockEconomyClass.Text.Length < 1 || _TextBlockFirstClass.Text.Length < 1 || _TextBlockModel.Text.Length < 1 || _TextBlockSideNumber.Text.Length < 1 || _TextBlockVipClass.Text.Length < 1) { TextBlockMessgeAddAircraft.Visibility = Visibility.Visible; TextBlockMessgeAddAircraft.Text = "Заполнены не все поля"; } else { try { MyDataContext dboperator = new MyDataContext(CurrentUser.connectionString); Aircraft aircraftnew = new Aircraft { AircraftModel = _TextBlockModel.Text, SideNumber = _TextBlockSideNumber.Text, EconomyClass = short.Parse(_TextBlockEconomyClass.Text), BusinessClass = short.Parse(_TextBlockBusinessClass.Text), FirstClass = short.Parse(_TextBlockFirstClass.Text), VIPClass = short.Parse(_TextBlockVipClass.Text), IsFree = true }; dboperator.aircrafts.InsertOnSubmit(aircraftnew); dboperator.SubmitChanges(); TextBlockMessgeAddAircraft.Text = "Самолет добавлен"; TextBlockMessgeAddAircraft.Visibility = Visibility.Visible; ClearTextBoxes(); DataGridAircraft.Items.Add(aircraftnew); if (All.IsChecked == true) { Sort(true, 1); return; } if (Free.IsChecked == true) { Sort(true, 0); return; } if (Off.IsChecked == true) { Sort(false, 0); return; } } catch (Exception) { TextBlockMessgeAddAircraft.Visibility = Visibility.Visible; TextBlockMessgeAddAircraft.Text = $"Номер {_TextBlockSideNumber.Text} занят"; } } }
public Page3() { InitializeComponent(); MyDataContext dboperator = new MyDataContext(CurrentUser.connectionString); var airlines = dboperator.airlines; foreach (var item in airlines) { DataGridAirline.Items.Add(item); } }
public static ComboBox GetOperators(ref ComboBox _Operators) { MyDataContext db = new MyDataContext(connectionString); var Qoperators = from op in db.operators select new { op.Login }; foreach (var item in Qoperators) { _Operators.Items.Add($"{item.Login}"); } _Operators.SelectedIndex = 0; return(null); }
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; }
private void ButtonClick_AddAirline(object sender, RoutedEventArgs e) { if (_TextBlockAirlineName.Text.Length > 0 && _TextBlockCounty.Text.Length > 0) { try { MyDataContext dboperator = new MyDataContext(CurrentUser.connectionString); Airline airlinenew = new Airline { AirlineName = _TextBlockAirlineName.Text.Length == 0 ? null : _TextBlockAirlineName.Text, Country = _TextBlockCounty.Text.Length == 0 ? null : _TextBlockCounty.Text, }; dboperator.airlines.InsertOnSubmit(airlinenew); dboperator.SubmitChanges(); //TextBlockMessgeAddAirline = CurrentUser.ResetColor(TextBlockMessgeAddAirline); ClearTextValues(); TextBlockMessgeAddAirline.Text = "Авиакомпания добавлена"; TextBlockMessgeAddAirline.Visibility = Visibility.Visible; DataGridAirline.Items.Add(airlinenew); } catch (System.Data.SqlClient.SqlException) { // TextBlockMessgeAddAirline.Foreground = Brushes.Red; TextBlockMessgeAddAirline.Visibility = Visibility.Visible; TextBlockMessgeAddAirline.Text = $"Имя {_TextBlockAirlineName.Text} занято"; } } else { //TextBlockMessgeAddAirline.Foreground = Brushes.Red; TextBlockMessgeAddAirline.Visibility = Visibility.Visible; TextBlockMessgeAddAirline.Text = "Заполнены не все поля"; } }
private void ContinueReg_Click(object sender, RoutedEventArgs e) { try { MyDataContext dboperator = new MyDataContext(CurrentUser.connectionString); if (_RepitPasswordBox.Password == _TextBoxPasswordReg.Password) { Operator operatornew = new Operator { FirstName = _TextBoxFirstName.Text, SecondName = _TextBoxSecondName.Text, Login = _TextBoxLoginReg.Text, Password = _TextBoxPasswordReg.Password, MiddleName = _TextBoxMiddleName.Text.Length == 0 ? null : _TextBoxMiddleName.Text }; dboperator.GetTable <Operator>().InsertOnSubmit(operatornew); dboperator.SubmitChanges(); RepitPassword.IsOpen = false; TextBlockMessage.Text = "Регистрация прошла успешно"; WrongPassOrLogin.IsOpen = true; _TextBoxFirstName.Clear(); _TextBoxSecondName.Clear(); _TextBoxMiddleName.Clear(); _TextBoxLoginReg.Clear(); _TextBoxPasswordReg.Clear(); FlipperAcc.IsFlipped = false; } else { TextBlockChangedPass.Text = "Неверный пароль"; } } catch (Exception) { RepitPassword.IsOpen = false; TextBlockMessage.Text = "Пользователь с таким логином уже зарегестрирован"; WrongPassOrLogin.IsOpen = true; } }
private void ButtonClick_OK(object sender, RoutedEventArgs e) { try { if (_TextBoxArrivalCity.Text.Length > 0 && _TextBoxDepatureCity.Text.Length > 0 && _TextBoxFlightNumber.Text.Length > 0) { MyDataContext dbFlight = new MyDataContext(CurrentUser.connectionString); DateTime date1; date1 = Convert.ToDateTime(DatePiker.Text); date1 = date1.AddHours(TimePiker.SelectedTime.Value.Hour); date1 = date1.AddMinutes(TimePiker.SelectedTime.Value.Minute); if (date1 < DateTime.Now) { TextBlockMessgeAddFlight.Visibility = Visibility.Visible; TextBlockMessgeAddFlight.Text = "Неверная дата"; return; } DateTime date2 = date1; date2 = date2.AddHours(double.Parse(_ComboBoxHours.Text)); date2 = date2.AddMinutes(double.Parse(_ComboBoxMinutes.Text)); Flight newflight = new Flight { ArrivalCity = _TextBoxArrivalCity.Text, DepatureCity = _TextBoxDepatureCity.Text, FlightNumber = _TextBoxFlightNumber.Text, OperatorID = CurrentUser.CurrentID, AircraftID = short.Parse(_ComboBoxSideNumberINV.Items[_ComboBoxSideNumber.SelectedIndex].ToString()), AirlineID = short.Parse(_ComboBoxAirlineNameINV.Items[_ComboBoxAirlineName.SelectedIndex].ToString()), DepartureTime = date1, ArrivalTime = date2, }; dbFlight.flights.InsertOnSubmit(newflight); dbFlight.SubmitChanges(); TextBlockMessgeAddFlight.Text = "Рейс добавлен"; TextBlockMessgeAddFlight.Visibility = Visibility.Visible; var flights = from fl in dbFlight.flights join airc in dbFlight.airlines on fl.AirlineID equals airc.AirlineID join air in dbFlight.aircrafts on fl.AircraftID equals air.AircraftID where fl.FlightNumber == _TextBoxFlightNumber.Text select new { fl.ArrivalCity, fl.ArrivalTime, fl.DepartureTime, fl.DepatureCity, fl.FlightNumber, airc.AirlineName, fl.FlightID, air.AircraftModel, air.SideNumber }; foreach (var item in flights) { DataGridFlights.Items.Add(item); } Aircraft Aircr = dbFlight.aircrafts.Where(airc => airc.AircraftID == short.Parse(_ComboBoxSideNumberINV.Items[_ComboBoxSideNumber.SelectedIndex].ToString())).FirstOrDefault(); Aircr.IsFree = false; dbFlight.SubmitChanges(); ClearValue(); } else { TextBlockMessgeAddFlight.Visibility = Visibility.Visible; TextBlockMessgeAddFlight.Text = "Заполнены не все поля"; } } catch (System.Data.SqlClient.SqlException) { TextBlockMessgeAddFlight.Visibility = Visibility.Visible; TextBlockMessgeAddFlight.Text = $"Рейс с номером {_TextBoxFlightNumber.Text} уже существует"; } catch (Exception) { TextBlockMessgeAddFlight.Visibility = Visibility.Visible; TextBlockMessgeAddFlight.Text = "Заполнены не все поля"; } }
private void Button_Click_CreateReport(object sender, RoutedEventArgs e) { DateTime res; if (DateTime.TryParse(_DataPiker_First.Text, out res) && DateTime.TryParse(_DataPiker_Second.Text, out res)) { _CreateReportErrorMessage.Visibility = Visibility.Hidden; DataGridAll.Items.Clear(); MyDataContext dboperator = new MyDataContext(CurrentUser.connectionString); if (_CheckBoxAllOperators.IsChecked == true) { var report = from fl in dboperator.flights join airc in dboperator.airlines on fl.AirlineID equals airc.AirlineID join aircrf in dboperator.aircrafts on fl.AircraftID equals aircrf.AircraftID join op in dboperator.operators on fl.OperatorID equals op.OperatorID where fl.DepartureTime >= _DataPiker_First.SelectedDate && fl.DepartureTime <= _DataPiker_Second.SelectedDate select new { fl.ArrivalCity, fl.ArrivalTime, fl.DepartureTime, fl.DepatureCity, fl.FlightNumber, airc.AirlineName, aircrf.AircraftModel, aircrf.SideNumber, op.FirstName, op.SecondName, op.Login }; foreach (var item in report) { DataGridAll.Items.Add(item); } } else if (_CheckBoxAllOperators.IsChecked == false) { var report = from fl in dboperator.flights join airc in dboperator.airlines on fl.AirlineID equals airc.AirlineID join aircrf in dboperator.aircrafts on fl.AircraftID equals aircrf.AircraftID join op in dboperator.operators on fl.OperatorID equals op.OperatorID where fl.DepartureTime >= _DataPiker_First.SelectedDate && fl.DepartureTime <= _DataPiker_Second.SelectedDate && op.Login == _ComboBoxNames.SelectedItem.ToString() select new { fl.ArrivalCity, fl.ArrivalTime, fl.DepartureTime, fl.DepatureCity, fl.FlightNumber, airc.AirlineName, aircrf.AircraftModel, aircrf.SideNumber, op.FirstName, op.SecondName, op.Login }; foreach (var item in report) { DataGridAll.Items.Add(item); } } } else { _CreateReportErrorMessage.Text = "Заполните все поля"; _CreateReportErrorMessage.Visibility = Visibility.Visible; } }