private void Add_btn_Click(object sender, RoutedEventArgs e)
{
if (isFormValid())
{
MyGarageDataSet ds = new MyGarageDataSet();
MyGarageDataSet.carsRow row = ds.cars.NewcarsRow();
row.license_plate = license_plate_textBox.Text;
row.manufacturer = manufacturer_textBox.Text;
row.model = model_textBox.Text;
row.car_type = type_textBox.Text;
row.identification_number = vid_textBox.Text;
row.manufacturer_id = manufacturer_id_textBox.Text != "" ? int.Parse(manufacturer_id_textBox.Text) : 0;
row.typ_id = type_id_textBox.Text;
row.first_registered = DateTime.Parse(first_registered_textBox.Text);
row.horse_power = horse_power_textBox.Text != "" ? int.Parse(horse_power_textBox.Text) : 0;
row.kilo_watt = kilo_watt_textBox.Text != "" ? int.Parse(kilo_watt_textBox.Text) : 0;
row.next_main_inspection = main_inspection_datePicker.DisplayDate;
if (safety_inspection_datePicker.SelectedDate != null)
{
row.next_safety_inspection = safety_inspection_datePicker.DisplayDate;
}
Sql.AddCarsRow(row, ds);
this.Close();
}
else
{
MessageBox.Show("Einige Paramater sind nicht korrekt. Bitte überprüfen Sie Ihre Eingabe");
}
}
public static void AddRepairsRow(MyGarageDataSet.repairsRow row, MyGarageDataSet dataSet, String license_plate)
{
dataSet.repairs.Rows.Add(row);
repairsTableAdapter.Update(dataSet.repairs);
Sql.RefreshRepairs(license_plate);
}
public static void AddCarsRow(MyGarageDataSet.carsRow row, MyGarageDataSet dataSet)
{
dataSet.cars.Rows.Add(row);
carsTableAdapter.Update(dataSet.cars);
Sql.RefreshCars();
}
static Sql()
{
ds = new MyGarageDataSet();
carsTableAdapter = new MyGarageDataSetTableAdapters.carsTableAdapter();
carsTableAdapter.Fill(ds.cars);
repairsTableAdapter = new MyGarageDataSetTableAdapters.repairsTableAdapter();
}
private void Ok_btn_Click(object sender, RoutedEventArgs e)
{
MyGarageDataSet ds = new MyGarageDataSet();
MyGarageDataSet.repairsRow row = ds.repairs.NewrepairsRow();
row.license_plate = license_plate;
row.repair_date = datePicker.SelectedDate.HasValue ? datePicker.SelectedDate.Value : datePicker.DisplayDate;
row.kilometer = kilometer_textBox.Text != "" ? int.Parse(kilometer_textBox.Text) : 0;
row.operating_hours = operation_hours_textBox.Text != "" ? int.Parse(operation_hours_textBox.Text) : 0;
row.descriptions = description_textBox.Text;
row._operator = operator_textBox.Text;
row.is_main_inspection = main_inspection_checkBox.IsChecked.HasValue ? main_inspection_checkBox.IsChecked.Value : false;
row.is_safety_inspection = safety_inspection_checkBox.IsChecked.HasValue ? safety_inspection_checkBox.IsChecked.Value : false;
Sql.AddRepairsRow(row, ds, license_plate);
Close();
}
private void Delete_btn_Click(object sender, RoutedEventArgs e)
{
//TODO
MyGarageDataSet ds = new MyGarageDataSet();
MyGarageDataSet.repairsRow row = ds.repairs.NewrepairsRow();
DataRowView view = (DataRowView)dataGrid.SelectedItem;
String license_plate = view.Row["license_plate"].ToString();
DateTime date = (DateTime)view.Row["repair_date"];
String message = "Möchten Sie die Reparatur wirklich löschen?";
MessageBoxResult result = MessageBox.Show(message, "Löschen", MessageBoxButton.YesNo);
if (result.Equals(MessageBoxResult.Yes))
{
repairsTableAdapter.DeleteRepair(license_plate, date);
MyGarageDataSet.repairsDataTable repairsTable = repairsTableAdapter.GetRepairByLicensePlate(license_plate);
dataGrid.ItemsSource = repairsTable;
}
}
