public void Delete(Adress address) { using (var ctx = new MovieShopContextDB()) { var addressDB = ctx.Adresses.FirstOrDefault(item => item.Id == address.Id); ctx.Adresses.Remove(addressDB); } }
public void Add(Adress address) { using (var ctx = new MovieShopContextDB()) { //Create the queries ctx.Adresses.Add(address); //Execute the queries ctx.SaveChanges(); } }
public void Update(Adress address) { using (var ctx = new MovieShopContextDB()) { var addressDB = ctx.Adresses.FirstOrDefault(item => item.Id == address.Id); addressDB.StreetName = address.StreetName; addressDB.StreetNumber = address.StreetNumber; addressDB.Zipcode = address.Zipcode; addressDB.Country = address.Country; ctx.SaveChanges(); } }
public ActionResult CustomerEdit(int movieId, Customer customer, Adress address) { Movie movie = facade.GetMovieRepository().Read(movieId); customer.Adress = address; facade.GetCustomerRepository().Update(customer); facade.GetAddressRepository().Update(customer.Adress); Order order = new Order() { Date = DateTime.Now, CustomerId = customer.Id, MovieId = movieId }; facade.GetOrderRepository().Add(order); return RedirectToAction("OrderCompletion", new { movieId = movieId}); }
public ActionResult NewCustomerCreate(int movieId, Customer customer, Adress address) { CustomerViewModel viewModel = new CustomerViewModel() { Movie = facade.GetMovieRepository().Read(movieId) }; customer.Adress = address; facade.GetCustomerRepository().Add(customer); Order order = new Order() { Date = DateTime.Now, CustomerId = customer.Id, MovieId = movieId }; facade.GetOrderRepository().Add(order); return View(viewModel); }