public static List <DTO.OrderDTO> GetCompletedOrders() { var db = new PizzaSiteDbEntities(); var orders = db.Orders.Where(p => p.Completed == true).ToList(); return(convertToDTO(orders)); }
public static void CreateOrder(OrderDTO orderDTO) { var db = new PizzaSiteDbEntities(); db.Orders.Add(ConverToDb(orderDTO)); db.SaveChanges(); }
public static PriceDTO GetPrice() { var db = new PizzaSiteDbEntities(); var prices = db.Prices.First(); var priceDTO = ConvertToDTO(prices); return(priceDTO); }
public static void CompleteOrder(Guid orderId) { var db = new PizzaSiteDbEntities(); var orders = db.Orders.Where(p => p.Id == orderId); foreach (var order in orders) { order.Completed = true; } db.SaveChanges(); }