Esempio n. 1
0
        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();
        }
Esempio n. 3
0
        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;
            }
        }