public List<Customer> GetAllCustomers()
{
using (var db = new OskarEntities())
{
return db.Customers.ToList();
}
}
public List<Invoice> GetAllInvoices()
{
using (var db = new OskarEntities())
{
return db.Invoices.ToList();
}
}
public List<Owner> GetAllOwners()
{
using (var db = new OskarEntities())
{
return db.Owners.ToList();
}
}
public List<Product> GetAllProducts()
{
using (var db = new OskarEntities())
{
return db.Products.ToList();
}
}
public void CreateCustomer(Customer customer)
{
using (var db = new OskarEntities())
{
db.Customers.Add(customer);
db.SaveChanges();
}
}
public void CreateOwner(Owner owner)
{
using (var db = new OskarEntities())
{
db.Owners.Add(owner);
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 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 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 Product GetProduct(int productId)
{
using (var db = new OskarEntities())
{
var query = from product in db.Products
where product.ProductId == productId
select product;
return query.Single();
}
}
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 List<Invoice> GetInvoicesByPaidDate(bool paid)
{
using (var db = new OskarEntities())
{
var query = from invoice in db.Invoices
where invoice.PaidDate != null // ska fixas
select invoice;
return query.ToList();
}
}
public List<Invoice> GetInvoicesByExpirationDate(DateTime dateTime)
{
using (var db = new OskarEntities())
{
var query = from invoice in db.Invoices
where invoice.ExpirationDate > DateTime.Now
select invoice;
return query.ToList();
}
}
public List<Invoice> GetInvoicesByCustomerId(int customerId)
{
using (var db = new OskarEntities())
{
var query = from invoice in db.Invoices
where invoice.CustomerId == customerId
select invoice;
return query.ToList();
}
}
public Invoice GetInvoice(int invoiceId)
{
using (var db = new OskarEntities())
{
var query = from invoice in db.Invoices
where invoice.InvoiceId == invoiceId
select invoice;
return query.Single();
}
}
public Owner GetOwner(int ownerId)
{
using (var db = new OskarEntities())
{
var query = from owner in db.Owners
where owner.OwnerId == ownerId
select owner;
return query.Single();
}
}
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();
}
}
public Customer GetCustomer(int customerId)
{
using (var db = new OskarEntities())
{
var query = from customer in db.Customers
where customer.CustomerId == customerId
select customer;
return query.Single();
}
}
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();
}
}
