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");
}
