public static List <Contrahent> GetCompanies()
{
using (InvoiceDbContext invoiceDbContext = new InvoiceDbContext())
{
return(invoiceDbContext.Companies.ToList());
}
}
public static void AddInvoice(Invoice i)
{
using (InvoiceDbContext invoiceDbContext = new InvoiceDbContext())
{
invoiceDbContext.Invoices.Add(i);
invoiceDbContext.SaveChanges();
}
}
public static void UpdateProduct(Product p)
{
using (InvoiceDbContext invoiceDbContext = new InvoiceDbContext())
{
invoiceDbContext.Products.AddOrUpdate(p);
invoiceDbContext.SaveChanges();
}
}
public static void UpdateCompanies(Contrahent c)
{
using (InvoiceDbContext invoiceDbContext = new InvoiceDbContext())
{
invoiceDbContext.Companies.AddOrUpdate(c);
invoiceDbContext.SaveChanges();
}
}
public static void AddComapnies(Contrahent c)
{
using (InvoiceDbContext invoiceDbContext = new InvoiceDbContext())
{
invoiceDbContext.Companies.Add(c);
invoiceDbContext.SaveChanges();
}
}
public static void DeleteProduct(Product p)
{
using (InvoiceDbContext invoiceDbContext = new InvoiceDbContext())
{
invoiceDbContext.Products.Attach(p);
invoiceDbContext.Products.Remove(p);
invoiceDbContext.SaveChanges();
}
}
public static void DeleteCompanies(Contrahent c)
{
using (InvoiceDbContext invoiceDbContext = new InvoiceDbContext())
{
invoiceDbContext.Companies.Attach(c);
invoiceDbContext.Companies.Remove(c);
invoiceDbContext.SaveChanges();
}
}
public static void AddInvoiceItems(InvoiceItem ii)
{
using (InvoiceDbContext invoiceDbContext = new InvoiceDbContext())
{
Product product = invoiceDbContext.Products.Where(x => x.ProductID == ii.Product.ProductID).First();
ii.Product = product;
invoiceDbContext.InvoiceItems.Add(ii);
invoiceDbContext.SaveChanges();
}
}
public static List <Product> GetProducts(InvoiceDbContext invoiceDbContext)
{
return(invoiceDbContext.Products.ToList());
}
