//Удалить рейс
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_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} занят";
}
}
}
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 = "Заполнены не все поля";
}
}
