public List<Customer> ReadAll() { using (var ctx = new MovieStoreContext()) { return ctx.Customers.ToList(); } }
public List<Movie> ReadAll() { using (var ctx = new MovieStoreContext()) { return ctx.Movies.Include(x => x.Genre).ToList(); } }
public OrderLine GetOrderLine(int id) { using (var ctx = new MovieStoreContext()) { return ctx.OrderLines.Include(x => x.Movie).Include(x => x.Order).Where(x => x.OrderId == id).FirstOrDefault(); } }
public Movie GetMovie(int id) { using (var ctx = new MovieStoreContext()) { return ctx.Movies.Include(x => x.Genre).Where(x => x.Id == id).FirstOrDefault(); } }
public List<OrderLine> ReadAll(int id) { using (var ctx = new MovieStoreContext()) { return ctx.OrderLines.Include(x => x.Order).Include(x => x.Movie).ToList(); } }
public Customer GetCustomer(int id) { using (var ctx = new MovieStoreContext()) { return ctx.Customers.Where(x => x.Id == id).FirstOrDefault(); } }
public Genre GetGenre(int id) { using (var ctx = new MovieStoreContext()) { return ctx.Genres.Where(x => x.Id == id).FirstOrDefault(); } }
public List<Genre> ReadAll() { using (var ctx = new MovieStoreContext()) { return ctx.Genres.ToList(); } }
public void Add(Movie movie) { using (var ctx = new MovieStoreContext()) { ctx.Movies.Add(movie); ctx.SaveChanges(); } }
public void Add(Customer customer) { using (var ctx = new MovieStoreContext()) { ctx.Customers.Add(customer); ctx.SaveChanges(); } }
public void Add(OrderLine orderLine) { using (var ctx = new MovieStoreContext()) { ctx.OrderLines.Add(orderLine); ctx.SaveChanges(); } }
public void Add(Genre genre) { using (var ctx = new MovieStoreContext()) { ctx.Genres.Add(genre); ctx.SaveChanges(); } }
public void UpdateGenre(Genre genre) { using (var ctx = new MovieStoreContext()) { Genre m = ctx.Genres.Where(x => x.Id == genre.Id).First(); m.Id = genre.Id; m.Name = genre.Name; ctx.SaveChanges(); } }
public void DeleteCustomer(int id) { using (var ctx = new MovieStoreContext()) { Customer m = ctx.Customers.Where(x => x.Id == id).First(); if (m != null) ctx.Customers.Remove(m); ctx.SaveChanges(); } }
public void DeleteGenre(int id) { using (var ctx = new MovieStoreContext()) { Genre m = ctx.Genres.Where(x => x.Id == id).First(); if (m != null) ctx.Genres.Remove(m); ctx.SaveChanges(); } }
public void UpdateOrderLine(OrderLine orderLine) { using (var ctx = new MovieStoreContext()) { OrderLine m = ctx.OrderLines.Where(x => x.OrderId == orderLine.OrderId).First(); m.Amount = orderLine.Amount; m.OrderId = orderLine.OrderId; m.MovieId = orderLine.MovieId; m.Movie = orderLine.Movie; m.Order = orderLine.Order; ctx.SaveChanges(); } }
public void UpdateCustomer(Customer customer) { using (var ctx = new MovieStoreContext()) { Customer m = ctx.Customers.Where(x => x.Id == customer.Id).First(); m.FirstName = customer.FirstName; m.LastName = customer.LastName; m.Address = customer.Address; m.Email = customer.Email; m.orders = customer.orders; ctx.SaveChanges(); } }
public void UpdateMovie(Movie movie) { using (var ctx = new MovieStoreContext()) { Movie m = ctx.Movies.Where(x => x.Id == movie.Id).First(); m.ImageUrl = movie.ImageUrl; m.Title = movie.Title; m.Price = movie.Price; m.Year = movie.Year; m.TralierUrl = movie.TralierUrl; m.Genre = movie.Genre; m.GenreId = movie.GenreId; ctx.SaveChanges(); } }