public void Add(Customer customer) { using (var ctx = new MovieShopContext()) { ctx.Customers.Add(customer); ctx.SaveChanges(); } }
public void Delete(Customer customer) { using (var ctx = new MovieShopContextDB()) { var customerDB = ctx.Customers.FirstOrDefault(item => item.Id == customer.Id); ctx.Customers.Remove(customerDB); ctx.SaveChanges(); } }
public void Add(Customer customer) { using (var ctx = new MovieShopContextDB()) { //Create the queries ctx.Customers.Add(customer); //Execute the queries ctx.SaveChanges(); } }
public ActionResult CustomerConfirmation(string Email) { var customer = facade.GetCustomerRepository().ReadByEmail(Email); if (customer == null) { customer = new Customer() { Email = Email }; } return View(customer); }
public void Update(Customer customer) { using (var ctx = new MovieShopContextDB()) { var customerDB = ctx.Customers.FirstOrDefault(item => item.Id == customer.Id); customerDB.FirstName = customer.FirstName; customerDB.LastName = customer.LastName; customerDB.Email = customer.Email; customerDB.Adress = ctx.Adresses.FirstOrDefault(item => item.Id == customer.Adress.Id); ctx.SaveChanges(); } }
public ActionResult CustomerPlaceOrder(Customer customer) { if (facade.GetCustomerRepository().ReadById(customer.Id) == null) { facade.GetCustomerRepository().Add(customer); } facade.GetOrderRepository().Add(new Order() { Customer = customer, Movies = ((List<Movie>)Session["Cart"]), Date = DateTime.Now }); Session.Clear(); return RedirectToAction("Index", "Home"); }
public void Remove(Customer customer) { try { using (var ctx = new MovieShopContext()) { var customerToDelete = ctx.Customers.Where(cust => cust.Id == customer.Id).FirstOrDefault(); ctx.Customers.Remove(customerToDelete); ctx.SaveChanges(); } } catch (DbUpdateException ex) { throw new Exception("Customer cannot be deleted"); } }
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 void Update(Customer customer) { using (var ctx = new MovieShopContext()) { var customerToUpdate = ctx.Customers.Where(cust => cust.Id == customer.Id).FirstOrDefault(); if (customerToUpdate != null) { customerToUpdate.Country = customer.Country; customerToUpdate.Email = customer.Email; customerToUpdate.Firstname = customer.Firstname; customerToUpdate.Lastname = customer.Lastname; customerToUpdate.StreetName = customer.StreetName; customerToUpdate.StreetNumber = customer.StreetNumber; customerToUpdate.Zipcode = customer.Zipcode; ctx.SaveChanges(); } } }
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(Customer customer) { facade.GetCustomerRepository().Update(customer); facade.GetAddressRepository().Update(customer.Adress); return RedirectToAction("Index"); }
public ActionResult DeleteConfirmed(Customer customer) { facade.GetCustomerRepository().Delete(customer); return RedirectToAction("Index"); }
public ActionResult Create(Customer customer) { facade.GetCustomerRepository().Add(customer); return RedirectToAction("Index"); }