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