private void UpdateCarsDB()
{
UpdateAdapters();
dB_OwnersCarsDataSet.Clear();
MarkComboBox.Items.Clear();
ModelComboBox.Items.Clear();
UpdateTables();
FillCarDB();
foreach (Mark mark in _marks)
{
MarkComboBox.Add(mark.MarkName);
}
foreach (Model model in _models)
{
ModelComboBox.Add(model.NameModel);
}
ModelComboBox.SelectedIndex = 0;
MarkComboBox.SelectedIndex = 0;
numberTextBox.Text = "";
}
private void AddBtn_Click(object sender, EventArgs e)
{
try {
string number = numberTextBox.Text.Trim();
string filterModel = $"NameModel='{ModelComboBox.With(x => x.SelectedItem)}'";
string filterMark = $"MarkName='{MarkComboBox.With(x => x.SelectedItem)}'";
if (string.IsNullOrEmpty(number))
{
MessageBox.Show("Номер машины не задан!");
return;
}
Model model = _models.With(x => x.Select(filterModel)).With(x => x.First()) as Model;
Mark mark = _marks.With(x => x.Select(filterMark)).With(x => x.First()) as Mark;
Car car = _cars.NewCarRow();
car.DateRegGAI = dateReg.Value;
car.Number = number;
car.ModelId = model.Id;
car.MarkId = mark.Id;
_cars.AddCarRow(car);
UpdateCarsDB();
} catch (NullReferenceException) {
MessageBox.Show("Один из параметров не задан либо не выбран");
} catch (Exception) { }
}
private void ChangeBtn_Click(object sender, EventArgs e)
{
if (dataGridView1.SelectedRows.Count != 0)
{
try {
Car car = _cars.Where(x => x.Id == _carId).First();
string filterModel = $"NameModel='{ModelComboBox.With(x => x.SelectedItem)}'";
string filterMark = $"MarkName='{MarkComboBox.With(x => x.SelectedItem)}'";
Mark mark = _marks.With(x => x.Select(filterMark)).With(x => x.First()) as Mark;
Model model = _models.With(x => x.Select(filterModel)).With(x => x.First()) as Model;
car.MarkId = mark.Id;
car.ModelId = model.Id;
car.Number = numberTextBox.Text;
car.DateRegGAI = dateReg.Value;
} catch (NullReferenceException) {
MessageBox.Show("Один из параметров не задан либо не выбран");
} catch (Exception) { }
UpdateCarsDB();
}
else
{
MessageBox.Show("Выберите строку для редактирования", "Ошибка");
}
}
