コード例 #1
0
        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");
            }
        }
コード例 #2
0
ファイル: Sql.cs プロジェクト: jm-goldacker/MyGarage
        public static void AddCarsRow(MyGarageDataSet.carsRow row, MyGarageDataSet dataSet)
        {
            dataSet.cars.Rows.Add(row);

            carsTableAdapter.Update(dataSet.cars);

            Sql.RefreshCars();
        }