private void ChangeBtn_Click(object sender, EventArgs e)
{
if (dataGridView1.SelectedRows.Count != 0)
{
try {
string filterCar = $"Number='{this.carComboBox.With(x => x.SelectedItem)}'";
string filterOwner = $"NumberLicense='{this.ownerComboBox.With(x => x.SelectedItem)}'";
Owner owner = owners.With(x => x.Select(filterOwner)).With(x => x.First()) as Owner;
Car car = cars.With(x => x.Select(filterCar)).With(x => x.First()) as Car;
CarOwner carOwner = carOwners.FirstOrDefault(x => carOwnerId == x.Id);
carOwner.CarId = car.Id;
carOwner.OwnerId = owner.Id;
} catch (NullReferenceException) {
MessageBox.Show("Один из параметров не задан либо не выбран");
} catch (Exception) { }
UpdateDB();
}
else
{
MessageBox.Show("Выберите строку для редактирования", "Ошибка");
}
}
private void DataGridView1_CellClick(object sender, DataGridViewCellEventArgs e)
{
try {
DataGridViewRow row = dataGridView1.Rows[e.RowIndex];
carOwnerId = Convert.ToInt32(row.Cells[0].Value);
CarOwner carOwner = carOwners.FirstOrDefault(x => x.Id == carOwnerId);
Car car = carOwner.GetParentRows(relations["CarCarOwner"]).With(x => x.First()) as Car;
Owner owner = carOwner.GetParentRows(relations["OwnerCarOwner"]).With(x => x.First()) as Owner;
this.carComboBox.SelectedItem = car.Number;
this.ownerComboBox.SelectedItem = owner.NumberLicense;
} catch (Exception) {
}
}
private void AddBtn_Click(object sender, EventArgs e)
{
try {
string filterCar = $"Number='{this.carComboBox.With(x => x.SelectedItem)}'";
string filterOwner = $"NumberLicense='{this.ownerComboBox.With(x => x.SelectedItem)}'";
Owner owner = owners.With(x => x.Select(filterOwner)).With(x => x.First()) as Owner;
Car car = cars.With(x => x.Select(filterCar)).With(x => x.First()) as Car;
CarOwner carOwner = this.carOwners.NewCarOwnerRow();
carOwner.CarId = car.Id;
carOwner.OwnerId = owner.Id;
this.carOwners.AddCarOwnerRow(carOwner);
UpdateDB();
} catch (NullReferenceException) {
MessageBox.Show("Один из параметров не задан либо не выбран");
} catch (Exception) { }
}
private void DeleteBtn_Click(object sender, EventArgs e)
{
if (dataGridView1.SelectedRows.Count != 0)
{
string message = "Вы действительно хотите удалить запись ? ";
DialogResult response = MessageBox.Show(message, "Подтверждение", MessageBoxButtons.YesNo);
if (response == DialogResult.Yes)
{
try {
CarOwner carOwner = carOwners.FirstOrDefault(x => x.Id == carOwnerId);
carOwner.Delete();
} catch (Exception) {
}
UpdateDB();
}
}
else
{
MessageBox.Show("Выберите строку для удаления", "Ошибка");
}
}