Item IItemService.GetItemById(int id)
{
using (InvoicingZLEntities context = new InvoicingZLEntities())
{
return(context.Items.Where(i => id.Equals(i.Id)).FirstOrDefault());
}
}
void IItemService.UpdateItem(Item item)
{
using (InvoicingZLEntities context = new InvoicingZLEntities())
{
context.Items.AddOrUpdate(item);
context.SaveChanges();
}
}
void ICustomerService.SaveInvoice(Invoice invoice)
{
using (InvoicingZLEntities context = new InvoicingZLEntities())
{
context.Invoices.AddOrUpdate(invoice);
context.SaveChanges();
}
}
void ICustomerService.UpdateCustomer(Customer customer)
{
using (InvoicingZLEntities context = new InvoicingZLEntities())
{
context.Customers.AddOrUpdate(customer);
context.SaveChanges();
}
}
List <Invoice> ICustomerService.GetInvoicesByCustomer(Customer selectedCustomer)
{
List <Invoice> invoiceList = new List <Invoice>();
using (InvoicingZLEntities context = new InvoicingZLEntities())
{
invoiceList = context.Invoices.Where(i => (selectedCustomer.Id).Equals(i.Customer.Id)).ToList();
}
return(invoiceList);
}
IEnumerable IItemService.GetItemInvoice()
{
List <Item> itemList = new List <Item>();
using (InvoicingZLEntities context = new InvoicingZLEntities())
{
var itList = from c in context.Items
select c;
itemList = itList.ToList();
}
return(itemList);
}
void IItemService.DeleteItemById(int Id)
{
using (InvoicingZLEntities context = new InvoicingZLEntities())
{
var items = from c in context.Items
where (c.Id == Id)
select c;
Item item = items.FirstOrDefault();
context.Items.Remove(item);
context.SaveChanges();
}
}
List <Customer> ICustomerService.GetCustomers()
{
List <Customer> customerList = new List <Customer>();
using (InvoicingZLEntities context = new InvoicingZLEntities())
{
var cusList = from c in context.Customers
select c;
customerList = cusList.ToList();
}
return(customerList);
}
void ICustomerService.DeleteCustomerById(int Id)
{
using (InvoicingZLEntities context = new InvoicingZLEntities())
{
var customers = from c in context.Customers
where (c.Id == Id)
select c;
Customer customer = customers.FirstOrDefault();
context.Customers.Remove(customer);
context.SaveChanges();
}
}
