public void Remove(Order order) { using (var ctx = new MovieShopContext()) { var orderToDelete = ctx.Orders.Where(Order => Order.Id == order.Id).FirstOrDefault(); ctx.Orders.Remove(orderToDelete); ctx.SaveChanges(); } }
public void Delete(Order order) { using (var ctx = new MovieShopContextDB()) { var orderDB = ctx.Orders.ToList().FirstOrDefault(item => item.Id == order.Id); ctx.Orders.Remove(orderDB); ctx.SaveChanges(); } }
public void Add(Order order) { using (var ctx = new MovieShopContextDB()) { //Create the queries ctx.Orders.Add(order); //Execute the queries ctx.SaveChanges(); } }
public void Update(Order order) { using (var ctx = new MovieShopContextDB()) { var orderDB = ctx.Orders.ToList().FirstOrDefault(item => item.Id == order.Id); orderDB.Customer = order.Customer; orderDB.Date = order.Date; ctx.SaveChanges(); } }
public void Update(Order order) { using (var ctx = new MovieShopContext()) { var orderToUpdate = ctx.Orders.Where(Order => Order.Id == order.Id).FirstOrDefault(); if (orderToUpdate != null) { orderToUpdate.Movies = order.Movies; ctx.SaveChanges(); } } }
public void Add(Order order) { using (var ctx = new MovieShopContext()) { List<Movie> movies = new List<Movie>(); foreach (var movie in order.Movies) { movies.Add(ctx.Movies.FirstOrDefault(movieToSearch => movieToSearch.Id == movie.Id)); } order.Movies = movies; order.Customer = ctx.Customers.FirstOrDefault(cust => cust.Id == order.Customer.Id); ctx.Orders.Add(order); 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 Update(Order order) { return View(); }
public ActionResult DeleteConfirmed(Order order) { return RedirectToAction("Index"); }
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); }
public ActionResult Edit(Order order) { facade.GetOrderRepository().Update(order); return RedirectToAction("Index"); }
public ActionResult Create(Order order) { facade.GetOrderRepository().Add(order); return RedirectToAction("Index"); }