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