private void AddCarButton_Click(object sender, RoutedEventArgs e) { if (cbAddManuf.Text == "" || cbAddMark.Text == "" || addCarModel.Text == "" || addCarPower.Text == "" || addCarAcceleration.Text == "" || addCarConsumption.Text == "" || addCarSpeed.Text == "" || addCarPrice.Text == "") { MessageBox.Show("Заполните все поля!"); } else { Manufacturer manufacturer = new Manufacturer { Name = cbAddManuf.Text }; Mark mark = new Mark { Name = cbAddMark.Text, Manufacturer = manufacturer }; using (AutoStorageContext db = new AutoStorageContext()) { if (db.Manufacturers.Any(m => m.Name == cbAddManuf.Text)) { manufacturer = db.Manufacturers.First(m => m.Name == cbAddManuf.Text); } else { db.Manufacturers.Add(manufacturer); } db.SaveChanges(); if (db.Marks.Any(m => m.Name == cbAddMark.Text)) { mark = db.Marks.First(m => m.Name == cbAddMark.Text); } else { db.Marks.Add(mark); } db.SaveChanges(); Car car = new Car { Model = addCarModel.Text, Power = int.Parse(addCarPower.Text), Acceleration = double.Parse(addCarAcceleration.Text), Consumption = double.Parse(addCarConsumption.Text), MaxSpeed = int.Parse(addCarSpeed.Text), Price = int.Parse(addCarPrice.Text), Manufacturer = manufacturer, Mark = mark }; db.Cars.Add(car); db.SaveChanges(); } this.Close(); } }
private void deleteButton_Click(object sender, RoutedEventArgs e) { Car car = carsGrid.SelectedItem as Car; using (AutoStorageContext db = new AutoStorageContext()) { car = db.Cars.Find(car.Id); if (car != null) { db.Cars.Remove(car); } db.SaveChanges(); } ViewTable(); }
private void EditCarButton_Click(object sender, RoutedEventArgs e) { if (cbAddManuf.Text == "" || cbAddMark.Text == "" || addCarModel.Text == "" || addCarPower.Text == "" || addCarAcceleration.Text == "" || addCarConsumption.Text == "" || addCarSpeed.Text == "" || addCarPrice.Text == "") { MessageBox.Show("Заполните все поля!"); } else { using (AutoStorageContext db = new AutoStorageContext()) { Car car = db.Cars.Find(_car.Id); car.Model = addCarModel.Text; car.Power = int.Parse(addCarPower.Text); car.Acceleration = double.Parse(addCarAcceleration.Text); car.Consumption = double.Parse(addCarConsumption.Text); car.MaxSpeed = int.Parse(addCarSpeed.Text); car.Price = int.Parse(addCarPrice.Text); db.SaveChanges(); } this.Close(); } }