private void RemoveCar(object sender, RoutedEventArgs e) { Button b = sender as Button; DriversCar drCar = b.CommandParameter as DriversCar; int idToRemove = drCar.id; using (TaxiDBEntities2 context = new TaxiDBEntities2()) { Driver dr = context.Drivers.First(c => c.Username == user); if (dr.ActiveCar == idToRemove) { MessageBox.Show("Cannot remove active car"); } else { var carToRemove = context.Cars.First(x => x.Id == idToRemove); context.Cars.Remove(carToRemove); context.SaveChanges(); } } listDriversCars(); }
private void SelectCar(object sender, RoutedEventArgs e) { Button b = sender as Button; DriversCar drCar = b.CommandParameter as DriversCar; int idToSelect = drCar.id; using (TaxiDBEntities2 context = new TaxiDBEntities2()) { Driver dr = context.Drivers.First(c => c.Username == user); if (dr.ActiveCar == idToSelect) { MessageBox.Show("The car is already selected"); } else { dr.ActiveCar = idToSelect; context.SaveChanges(); Car activeCar = context.Cars.First(c => c.Id == dr.ActiveCar); LabelActiveCar.Content = "Active car: " + activeCar.Model + " " + activeCar.Year; } } }
private void listDriversCars() { List <DriversCar> drCar = new List <DriversCar>(); using (TaxiDBEntities2 context = new TaxiDBEntities2()) { Driver dr = context.Drivers.First(c => c.Username == user); var cars = context.Cars.ToList(); foreach (Car car in cars) { if (car.DriverNr == dr.Id) { DriversCar dc = new DriversCar(); dc.id = car.Id; dc.car = car.Model + " " + car.Year + " Seats: " + car.Size; drCar.Add(dc); } } List <DriversCar> SortedList = drCar.OrderBy(o => o.id).ToList(); CarListView.ItemsSource = SortedList; Car activeCar = context.Cars.First(c => c.Id == dr.ActiveCar); LabelActiveCar.Content = "Active car: " + activeCar.Model + " " + activeCar.Year; } }