private void addDriverButton_Click(object sender, EventArgs e) { DriverForm driverForm = new DriverForm(); List <Driver> drivers = db.Drivers.ToList(); DialogResult result = driverForm.ShowDialog(this); if (result == DialogResult.Cancel) { return; } else { try { Driver driver = new Driver(); driver.Name = driverForm.textBox2.Text; driver.Surname = driverForm.textBox1.Text; driver.Patronymic = driverForm.textBox3.Text; driver.DayOfBirth = Convert.ToDateTime(driverForm.textBox4.Text); driver.Experience = (int)driverForm.numericUpDown1.Value; driver.Photo = ConvertFiletoByte(driverForm.pictureBox1.ImageLocation); db.Drivers.Add(driver); db.SaveChanges(); PlaySound(Application.StartupPath + "\\exclamationtone.wav", 0, 1); MessageBox.Show("Новый водитель добавлен"); } catch { PlaySound(Application.StartupPath + "\\errortone.wav", 0, 1); MessageBox.Show("Не получилось добавить новый объект"); } } }
private void chDriverButton_Click(object sender, EventArgs e) { if (dataGridView6.SelectedRows.Count > 0) { int index = dataGridView6.SelectedRows[0].Index; int id = 0; bool converted = Int32.TryParse(dataGridView6[0, index].Value.ToString(), out id); if (converted == false) { return; } Driver driver = db.Drivers.Find(id); DriverForm driverForm = new DriverForm(); driverForm.textBox1.Text = driver.Surname; driverForm.textBox2.Text = driver.Name; driverForm.textBox3.Text = driver.Patronymic; driverForm.textBox4.Text = driver.DayOfBirth.ToString(); driverForm.numericUpDown1.Value = driver.Experience; driverForm.pictureBox1.Image = ConvertBytetoImage(driver.Photo); List <Driver> drivers = db.Drivers.ToList(); DialogResult result = driverForm.ShowDialog(this); if (result == DialogResult.Cancel) { return; } else { PlaySound(Application.StartupPath + "\\strarttone.wav", 0, 1); DialogResult dialogResult = MessageBox.Show("Желаете поменять изображение для этого объекта? " + "Если вы не выбрали новое изображение для него и нажали Да, то старое изображение пропадет", "Сменить изображение?", MessageBoxButtons.YesNo); if (dialogResult == DialogResult.Yes) { driver.Surname = driverForm.textBox1.Text; driver.Name = driverForm.textBox2.Text; driver.Patronymic = driverForm.textBox3.Text; driver.DayOfBirth = Convert.ToDateTime(driverForm.textBox4.Text); driver.Experience = Convert.ToInt32(driverForm.numericUpDown1.Value); driver.Photo = ConvertFiletoByte(driverForm.pictureBox1.ImageLocation); db.Entry(driver).State = EntityState.Modified; db.SaveChanges(); MessageBox.Show("Объект обновлен"); } else if (dialogResult == DialogResult.No) { driver.Surname = driverForm.textBox1.Text; driver.Name = driverForm.textBox2.Text; driver.Patronymic = driverForm.textBox3.Text; driver.DayOfBirth = Convert.ToDateTime(driverForm.textBox4.Text); driver.Experience = Convert.ToInt32(driverForm.numericUpDown1.Value); db.Entry(driver).State = EntityState.Modified; db.SaveChanges(); MessageBox.Show("Объект обновлен"); } } } }