public void DeleteProduct(int id)
{
using (var context = new OMContext())
{
var product = context.Products.Find(id);
context.Products.Remove(product ?? throw new InvalidOperationException());
context.SaveChanges();
}
}
public void UpdateProduct(Product product)
{
using (var context = new OMContext())
{
//context.Categories.AddOrUpdate(category);
context.Entry(product).State = EntityState.Modified;
context.SaveChanges();
}
}
public void ProductSave(Product product)
{
using (var context = new OMContext())
{
context.Entry(product.Category).State = EntityState.Unchanged;
context.Products.Add(product);
context.SaveChanges();
}
}
public bool UpdateOrderStatus(int ID, string status)
{
using (var context = new OMContext())
{
var order = context.Orders.Find(ID);
order.Status = status;
context.Entry(order).State = EntityState.Modified;
return(context.SaveChanges() > 0);
}
}
public int SaveOrder(Order order)
{
_context.Orders.Add(order);
return(_context.SaveChanges());
}
public void CategorySave(Category category)
{
_context.Categories.Add(category);
_context.SaveChanges();
}