public List<Customer> ReadAll() { using (var ctx = new MovieShopContext()) { return ctx.Customers.ToList(); } }
public List<Movie> ReadAll() { using (var ctx = new MovieShopContext()) { return ctx.Movies.Include("Genre").ToList(); } }
public List<Order> ReadAll() { using (var ctx = new MovieShopContext()) { return ctx.Orders.Include(x => x.Customer).ToList(); } }
public Movie ReadById(int Id) { using (var ctx = new MovieShopContext()) { return ctx.Movies.Include("Genre").FirstOrDefault(x => x.Id == Id); } }
public Order ReadById(int Id) { using (var ctx = new MovieShopContext()) { return ctx.Orders.Where(order => order.Id == Id).FirstOrDefault(); } }
public Customer ReadById(int Id) { using (var ctx = new MovieShopContext()) { return ctx.Customers.FirstOrDefault(cust => cust.Id == Id); } }
public List<Genre> ReadAll() { using (var ctx = new MovieShopContext()) { return ctx.Genres.ToList(); } }
public Genre ReadById(int Id) { using (var ctx = new MovieShopContext()) { return ctx.Genres.Where(ge => ge.Id == Id).FirstOrDefault(); } }
public Customer ReadByEmail(string Email) { using (var ctx = new MovieShopContext()) { return ctx.Customers.FirstOrDefault(cust => cust.Email.Equals(Email)); } }
public void Add(Customer customer) { using (var ctx = new MovieShopContext()) { ctx.Customers.Add(customer); ctx.SaveChanges(); } }
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 Remove(Movie movie) { using (var ctx = new MovieShopContext()) { var movieToDelete = ctx.Movies.FirstOrDefault(x => x.Id == movie.Id); ctx.Movies.Remove(movieToDelete); ctx.SaveChanges(); } }
public void Add(Genre genre) { using (var ctx = new MovieShopContext()) { // create queries ctx.Genres.Add(genre); // execute changes ctx.SaveChanges(); } }
public void Update(Genre genre) { using (var ctx = new MovieShopContext()) { var genreToUpdate = ctx.Genres.Where(x => x.Id == genre.Id).FirstOrDefault(); if (genreToUpdate != null) { genreToUpdate.Name = genre.Name; 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 void Remove(Genre genre) { try { using (var ctx = new MovieShopContext()) { var genreToDelete = ctx.Genres.Where(x => x.Id == genre.Id).FirstOrDefault(); ctx.Genres.Remove(genreToDelete); ctx.SaveChanges(); } } catch (DbUpdateException ex) { throw new Exception("This Genre exists in a movie and can not be deleted"); } }
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 void Update(Movie movie) { using (var ctx = new MovieShopContext()) { var movieToUpdate = ctx.Movies.FirstOrDefault(x => x.Id == movie.Id); if (movieToUpdate != null) { movieToUpdate.Title = movie.Title; movieToUpdate.Price = movie.Price; movieToUpdate.Year = movie.Year; movieToUpdate.PicturePath = movie.PicturePath; movieToUpdate.TrailerURL = movie.TrailerURL; movieToUpdate.Genre = ctx.Genres.FirstOrDefault(x => x.Id == movie.Genre.Id); ctx.SaveChanges(); } } }
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 MovieRepository(MovieShopContext context) { ctx = context; }
public GenresRepository(MovieShopContext context) { ctx = context; }
public Facade(MovieShopContext context) { ctx = context; }
public Facade() { ctx = new MovieShopContextDev(); }