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(); } }