public Movie getProduct(int productID) { using (var context = new MovieStoreEDM()) { Movie movie = (from p in context.Movies1 where p.Id == productID select p).FirstOrDefault <Movie>(); return(movie); } }
public Movie getMovieById(int movieId) { using (var context = new MovieStoreEDM()) { Movie movie = (from c in context.Movies1 where c.Id == movieId select c).FirstOrDefault <Movie>(); return(movie); } }
public Customer getCustomerByUsername(string username) { using (var context = new MovieStoreEDM()) { Customer customer = (from c in context.Customers where c.Name == username select c).FirstOrDefault <Customer>(); return(customer); } }
public int addNewOrder(Order newOrder) { using (var context = new MovieStoreEDM()) { context.Orders.Add(newOrder); context.SaveChanges(); return(newOrder.Id); } }
public List <Movie> getMoviesByGenre(GenreTypes genre) { using (var context = new MovieStoreEDM()) { List <Movie> movies = (from p in context.Movies1 where p.Genre == genre.ToString() select p).ToList <Movie>(); return(movies); } }
public OrderItem getOrderItemById(int orderId) { using (var context = new MovieStoreEDM()) { OrderItem orderItem = (from c in context.OrderItems where c.Id == orderId select c).FirstOrDefault <OrderItem>(); return(orderItem); } }
public void addOrderItem(OrderItem orderItem) { using (var context = new MovieStoreEDM()) { context.OrderItems.Add(orderItem); try { context.SaveChanges(); } catch { } } }
public void updateOrder(Order order) { using (var context = new MovieStoreEDM()) { Order orderRecord = (from p in context.Orders where p.Id == order.Id select p).FirstOrDefault <Order>(); orderRecord.Customer = order.Customer; orderRecord.Total = order.Total; orderRecord.Status = 0; context.SaveChanges(); } }