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(); }