private void Flight_Add_Click(object sender, RoutedEventArgs e)
{
DateTime?dateOfDeparture = flightDateOfDeparture.SelectedDate;
DateTime?dateOfArrival = flightDataOfArrival.SelectedDate;
if (flightIDPlane.Items.IndexOf(flightIDPlane.Text) >= 0 && flightAirline.Items.IndexOf(flightAirline.Text) >= 0 &&
flightAirportOfArrival.Text != "" && !Valid.IsNum(flightAirportOfArrival.Text) && dateOfDeparture != null && dateOfArrival != null)
{
flight.IDPlane = int.Parse(flightIDPlane.Text);
flight.Airline = flightAirline.Text;
flight.AirportOfArrival = flightAirportOfArrival.Text;
flight.DateOfDeparture = flightDateOfDeparture.SelectedDate.Value.ToString("d");
flight.DateOfArrival = flightDataOfArrival.SelectedDate.Value.ToString("d");
string query = "INSERT INTO Flight([ID самолета], [Авиакомпания], [Аэропорт прибытия], [Дата отправления], [Дата прибытия])" +
"VALUES (@IDPlane, @Airline, @AirportOfArrival, @DateOfDeparture, @DateOfArival)";
string[] sqlVariables = { "IDPlane", "Airline", "AirportOfArrival", "DateOfDeparture", "DateOfArival" };
object[] obj = { flight.IDPlane, flight.Airline, flight.AirportOfArrival, flight.DateOfDeparture, flight.DateOfArrival };
Database.Query(query, sqlVariables, obj);
Database.Query("SELECT * FROM Flight", flightGrid);
}
else
{
MessageBox.Show("Проверьте, заполнены ли все поля, и убедитесь в их корректности", "Предупреждение", MessageBoxButton.OK, MessageBoxImage.Warning);
}
UpdateAllCombobox();
}
private void Plane_Add_Click(object sender, RoutedEventArgs e)
{
DateTime?date = planeMaintenanceDate.SelectedDate;
if ((planeType.Items.IndexOf(planeType.Text) >= 0 && planeModel.Items.IndexOf(planeModel.Text) >= 0 &&
planeNumberOfSeats.Text != "" && planeCapacity.Text != "" && date != null) &&
(Valid.IsNum(planeNumberOfSeats.Text) && Valid.IsNum(planeCapacity.Text)))
{
plane.Type = planeType.SelectedItem.ToString();
plane.Model = planeModel.SelectedItem.ToString();
plane.NumberOfSeats = int.Parse(planeNumberOfSeats.Text);
plane.Capacity = int.Parse(planeCapacity.Text);
plane.MaintenanceDate = planeMaintenanceDate.SelectedDate.Value.ToString("d");
if (plane.NumberOfSeats != 0 && plane.Capacity != 0)
{
string query = "INSERT INTO Plane([Тип], [Модель], [Количество мест], [Грузоподъемность], [Дата последнего ТО])" +
"VALUES (@Type, @Model, @NumberOfSeats, @Capacity, @MaintenanceDate)";
string[] sqlVariables = { "Type", "Model", "NumberOfSeats", "Capacity", "MaintenanceDate" };
object[] obj = { plane.Type, plane.Model, plane.NumberOfSeats, plane.Capacity, plane.MaintenanceDate };
Database.Query(query, sqlVariables, obj);
}
Database.Query("SELECT * FROM Plane", planeGrid);
}
else
{
MessageBox.Show("Проверьте, заполнены ли все поля, и убедитесь в их корректности", "Предупреждение", MessageBoxButton.OK, MessageBoxImage.Warning);
}
UpdateAllCombobox();
}
public MainWindow()
{
InitializeComponent();
InitAllDatePicker();
InitPlaneTypeComboBox();
InitPlaneModelComboBox();
UpdateAllCombobox();
InitFlightAirline();
Authorization = false;
AuthorizationWnd = true;
user = new User();
plane = new Plane();
flight = new Flight();
passenger = new Passenger();
ticket = new Ticket();
DataContext = new Valid();
}
