public void CreateProduct(Product product)
{
using (var context = new ContextGrabber())
{
context.Products.Add(product);
context.SaveChanges();
}
}
public void CreateOrder(Order order)
{
using (var context = new ContextGrabber())
{
context.Orders.Add(order);
context.SaveChanges();
}
}
public void CreateCustomer(Customer customer)
{
using (var context = new ContextGrabber())
{
context.Customers.Add(customer);
context.SaveChanges();
}
}
public void EditProduct(Product product)
{
using (var context = new ContextGrabber())
{
context.Products.Add(product);
context.Entry(product).State = System.Data.Entity.EntityState.Modified;
context.SaveChanges();
}
}
public void EditOrder(Order order)
{
using (var context = new ContextGrabber())
{
context.Orders.Add(order);
context.Entry(order).State = System.Data.Entity.EntityState.Modified;
context.SaveChanges();
}
}
public void EditCustomer(Customer customer)
{
using (var context = new ContextGrabber())
{
context.Customers.Add(customer);
context.Entry(customer).State = System.Data.Entity.EntityState.Modified;
context.SaveChanges();
}
}
public void DeleteProduct(Product product)
{
using (var context = new ContextGrabber())
{
context.Products.Attach(product);
context.Products.Remove(product);
context.SaveChanges();
}
}
public void DeleteCustomer(Customer customer)
{
using (var context = new ContextGrabber())
{
context.Customers.Attach(customer);
context.Customers.Remove(customer);
context.SaveChanges();
}
}
public void DeleteOrder(Order order)
{
using (var context = new ContextGrabber())
{
var orderContext = context.Orders.Find(order.OrderID);
foreach (var detail in order.Details.ToList())
{
var detailContext = context.OrderDetails.Find(detail.OrderDetailID);
context.OrderDetails.Attach(detailContext);
context.OrderDetails.Remove(detailContext);
context.SaveChanges();
}
context.Orders.Attach(orderContext);
context.Orders.Remove(orderContext);
context.SaveChanges();
}
}