public int SaveOrder(Order order)
 {
     using (var context = new OgContext())
     {
         context.Orders.Add(order);
         return(context.SaveChanges());
     }
 }
 public void UpdateCategory(Category category)
 {
     using (var context = new OgContext())
     {
         context.Entry(category).State = System.Data.Entity.EntityState.Modified;
         context.SaveChanges();
     }
 }
 public void SaveCategory(Category category)
 {
     using (var context = new OgContext())
     {
         context.Categories.Add(category);
         context.SaveChanges();
     }
 }
 public void UpdateProduct(Product product)
 {
     using (var context = new OgContext())
     {
         context.Entry(product).State = System.Data.Entity.EntityState.Modified;
         context.SaveChanges();
     }
 }
        public void DeleteProduct(int ID)
        {
            using (var context = new OgContext())
            {
                var product = context.Products.Find(ID);

                context.Products.Remove(product);
                context.SaveChanges();
            }
        }
        public void SaveProduct(Product product)
        {
            using (var context = new OgContext())
            {
                context.Entry(product.Category).State = System.Data.Entity.EntityState.Unchanged;

                context.Products.Add(product);
                context.SaveChanges();
            }
        }
        public void DeleteCategory(int ID)
        {
            using (var context = new OgContext())
            {
                var category = context.Categories.Where(x => x.ID == ID).Include(x => x.Products).FirstOrDefault();

                context.Products.RemoveRange(category.Products); //first delete products of this category
                context.Categories.Remove(category);
                context.SaveChanges();
            }
        }
        public bool UpdateOrderStatus(int ID, string status)
        {
            using (var context = new OgContext())
            {
                var order = context.Orders.Find(ID);

                order.Status = status;

                context.Entry(order).State = EntityState.Modified;

                return(context.SaveChanges() > 0);
            }
        }