public static void AddInvoice(ProdContext prodContext) { Invoice inv = new Invoice { }; prodContext.Invoices.Add(inv); prodContext.SaveChanges(); }
public static void AddProduct(ProdContext prodContext) { Console.WriteLine("write name of product"); string prodName = Console.ReadLine(); Product prod1 = new Product { Name = prodName }; prodContext.Products.Add(prod1); prodContext.SaveChanges(); }
public static void AddCategory(ProdContext prodContext) { Console.WriteLine("write name of category"); string catName = Console.ReadLine(); Category cat1 = new Category { Name = catName }; prodContext.Categories.Add(cat1); prodContext.SaveChanges(); }
public static void AddCustomer(ProdContext prodContext) { Console.WriteLine("Write name of customer"); String suppName = Console.ReadLine(); Customer cust = new Customer { CompanyName = suppName, Discount = 0.2F }; prodContext.Companies.Add(cust); prodContext.SaveChanges(); }
//public static void AddSupplier(ProdContext prodContext) //{ // Console.WriteLine("Write name of supplier"); // String suppName = Console.ReadLine(); // Supplier supp1 = new Supplier { CompanyName = suppName }; // prodContext.Suppliers.Add(supp1); // prodContext.SaveChanges(); //} public static void AddSupplier(ProdContext prodContext) { Console.WriteLine("Write name of supplier"); String suppName = Console.ReadLine(); Supplier supp1 = new Supplier { CompanyName = suppName }; prodContext.Companies.Add(supp1); prodContext.SaveChanges(); }
public static void ConnectProductToCategory(ProdContext prodContext) { Console.WriteLine("Write name of product"); string prodName = Console.ReadLine(); Console.WriteLine("Write name of category"); String conName = Console.ReadLine(); Product product = prodContext.Products.Where(p => p.Name == prodName).FirstOrDefault(); Category category = prodContext.Categories.Where(c => c.Name == conName).FirstOrDefault(); product.Category = category; prodContext.SaveChanges(); }
//public static void ConnectProductToSupplier(ProdContext prodContext) //{ // Console.WriteLine("Write name of product"); // string prodName = Console.ReadLine(); // Console.WriteLine("Write name of supplier"); // String suppName = Console.ReadLine(); // Product product = prodContext.Products.Where(p => p.Name == prodName).FirstOrDefault(); // Supplier supplier = prodContext.Suppliers.Where(s => s.CompanyName == suppName).FirstOrDefault(); // product.Supplier = supplier; // prodContext.SaveChanges(); //} public static void ConnectProductToSupplier(ProdContext prodContext) { Console.WriteLine("Write name of product"); string prodName = Console.ReadLine(); Console.WriteLine("Write name of supplier"); String suppName = Console.ReadLine(); Product product = prodContext.Products.Where(p => p.Name == prodName).FirstOrDefault(); Company company = prodContext.Companies.Where(s => s.CompanyName == suppName).FirstOrDefault(); Supplier supplier = (Supplier)company; product.Supplier = supplier; prodContext.SaveChanges(); }
public static void ConnectProductToInvoice(ProdContext prodContext) { Console.WriteLine("Write name of product"); String prodName = Console.ReadLine(); Console.WriteLine("Write number of invoice"); String invNumStr = Console.ReadLine(); int invNum = Int32.Parse(invNumStr); Product product = prodContext.Products.Where(p => p.Name == prodName).FirstOrDefault(); Invoice invoice = prodContext.Invoices.Where(i => i.InvoiceNumber == invNum).FirstOrDefault(); prodContext.ProductInvoices.Add(new ProductInvoice { ProductID = product.ProductID, Product = product, InvoiceNumber = invoice.InvoiceNumber, Invoice = invoice }); prodContext.SaveChanges(); }