public List<Genre> ReadAll()
{
using (var ctx = new MovieShopContext())
{
return ctx.Genres.ToList();
}
}
public Customer Find(int ID)
{
using (var ctx = new MovieShopContext())
{
return Find(ID, ctx);
}
}
public List<Customer> FindAll()
{
using (var ctx = new MovieShopContext())
{
return ctx.Customers.ToList();
}
}
public Customer FindByEmail(string email)
{
using (var ctx = new MovieShopContext())
{
return FindByEmail(email, ctx);
}
}
public void Add(Customer customer)
{
using (var ctx = new MovieShopContext())
{
ctx.Customers.Add(customer);
ctx.SaveChanges();
}
}
public void Delete(int ID)
{
using (var ctx = new MovieShopContext())
{
ctx.Customers.Remove(Find(ID, ctx));
ctx.SaveChanges();
}
}
public void Edit(Order order)
{
using (var ctx = new MovieShopContext())
{
var dbOrder = Find(order.ID, ctx);
dbOrder.Date = order.Date;
ctx.SaveChanges();
}
}
public void Add(Genre genre)
{
using (var ctx = new MovieShopContext())
{
//Create the queries
ctx.Genres.Add(genre);
//Execute the queries
ctx.SaveChanges();
}
}
//Addding Order, making sure to attach customer, such no new customer would be made and use existing customer instead
public void Add(Order order)
{
using (var ctx = new MovieShopContext())
{
ctx.Customers.Attach(order.Customer);
order.OrderLines.ForEach(x => ctx.Movies.Attach(x.Movie));
ctx.Orders.Add(order);
ctx.SaveChanges();
}
}
public void Delete(int customerId)
{
Customer customer = FindCustomer(customerId);
{
using (var ctx = new MovieShopContext())
{
ctx.Customers.Attach(customer);
ctx.Customers.Remove(customer);
ctx.SaveChanges();
}
}
}
public void Edit(Customer customer)
{
using (var ctx = new MovieShopContext())
{
var dbCustomer = Find(customer.ID, ctx);
dbCustomer.FirstName = customer.FirstName;
dbCustomer.LastName = customer.LastName;
dbCustomer.Email = customer.Email;
dbCustomer.Address = customer.Address;
ctx.SaveChanges();
}
}
public void Update(Genre genre)
{
using (var ctx = new MovieShopContext())
{
foreach (var movieDB in ctx.Genres.ToList())
{
if (genre.Id == movieDB.Id)
{
movieDB.Name = genre.Name;
ctx.SaveChanges();
}
}
}
}
public void Delete(int movieId)
{
Movie movie = FindMovie(movieId);
try {
using (var ctx = new MovieShopContext())
{
ctx.Movies.Attach(movie);
ctx.Movies.Remove(movie);
ctx.SaveChanges();
}
}
catch (DbUpdateConcurrencyException)
{
}
}
public void Delete(int genreId)
{
Genre genre = FindGenre(genreId);
try
{
using (var ctx = new MovieShopContext())
{
ctx.Genres.Attach(genre);
ctx.Genres.Remove(genre);
ctx.SaveChanges();
}
}
catch (DbUpdateConcurrencyException)
{
}
}
public void Update(Customer customer)
{
using (var ctx = new MovieShopContext())
{
foreach (var movieDB in ctx.Customers.ToList())
{
if (customer.Id == movieDB.Id)
{
movieDB.Name = customer.Name;
movieDB.Email = customer.Email;
movieDB.Password = customer.Password;
ctx.SaveChanges();
}
}
}
}
private Customer FindByEmail(string email, MovieShopContext context)
{
return context.Customers.FirstOrDefault(c => c.Email == email);
}
private Customer Find(int ID, MovieShopContext context)
{
return context.Customers.FirstOrDefault(c => c.ID == ID);
}
private Order Find(int ID, MovieShopContext ctx)
{
return ctx.Orders.FirstOrDefault(c => c.ID == ID);
}
public void Update(Movie movie)
{
using (var ctx = new MovieShopContext())
{
foreach (var movieDB in ctx.Movies.ToList())
{
if (movie.Id == movieDB.Id)
{
movieDB.Title = movie.Title;
movieDB.ReleaseDate = movie.ReleaseDate;
movieDB.Price = movie.Price;
movieDB.TrailerURL = movie.TrailerURL;
movieDB.PictureURL = movie.PictureURL;
movieDB.Rating = movie.Rating;
movieDB.PlotDescription = movie.PlotDescription;
//movieDB.Genres = movie.Genres;
ctx.SaveChanges();
}
}
}
}
public List<Movie> ReadAll()
{
try {
using (var ctx = new MovieShopContext())
{
return ctx.Movies.Include("Genres").ToList();
}
}
catch (Exception e) {
return null;
}
}