public void CreateCustomer(Customer customer)
{
using (var db = new OskarEntities())
{
db.Customers.Add(customer);
db.SaveChanges();
}
}
public void CreateProduct(Product product)
{
using (var db = new OskarEntities())
{
db.Products.Add(product);
db.SaveChanges();
}
}
public void CreateInvoice(Invoice invoice)
{
using (var db = new OskarEntities())
{
db.Invoices.Add(invoice);
db.SaveChanges();
}
}
public void CreateOwner(Owner owner)
{
using (var db = new OskarEntities())
{
db.Owners.Add(owner);
db.SaveChanges();
}
}
public void UpdateProduct(Product product)
{
using (var db = new OskarEntities())
{
db.Products.Attach(product);
db.Entry(product).State = EntityState.Modified;
db.SaveChanges();
}
}
public void UpdateCustomer(Customer customer)
{
using (var db = new OskarEntities())
{
db.Customers.Attach(customer);
db.Entry(customer).State = EntityState.Modified;
db.SaveChanges();
}
}
public void UpdateOwner(Owner owner)
{
using (var db = new OskarEntities())
{
db.Owners.Attach(owner);
db.Entry(owner).State = EntityState.Modified;
db.SaveChanges();
}
}
public void DeleteProduct(int productId)
{
using (var db = new OskarEntities())
{
var product = new Product { ProductId = productId };
db.Products.Attach(product);
db.Products.Remove(product);
db.SaveChanges();
}
}
public void DeleteInvoice(int invoiceId)
{
using (var db = new OskarEntities())
{
var invoice = new Invoice { InvoiceId = invoiceId };
db.Invoices.Attach(invoice);
db.Invoices.Remove(invoice);
db.SaveChanges();
}
}
public void DeleteCustomer(int customerId)
{
using (var db = new OskarEntities())
{
var customer = new Customer { CustomerId = customerId };
db.Customers.Attach(customer);
db.Customers.Remove(customer);
db.SaveChanges();
}
}
public void DeleteOwner(int ownerId)
{
using (var db = new OskarEntities())
{
var owner = new Owner { OwnerId = ownerId };
db.Owners.Attach(owner);
db.Owners.Remove(owner);
db.SaveChanges();
}
}