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