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