public static void ShowInvoicesOfProduct(ProdContext prodContext) { Console.WriteLine("Write name of product"); String prodName = Console.ReadLine(); Product product = prodContext.Products.Where(p => p.Name == prodName).FirstOrDefault(); prodContext.Entry(product).Collection(prod => prod.ProductInvoices).Load(); Console.WriteLine("List of invoices for given product:"); foreach (ProductInvoice prodInv in product.ProductInvoices) { prodContext.Entry(prodInv).Reference(prodInv => prodInv.Invoice).Load(); Console.WriteLine(prodInv.InvoiceNumber); } }
public static void ShowProductsOfInvoice(ProdContext prodContext) { Console.WriteLine("Write number of invoice"); String invNumStr = Console.ReadLine(); int invnum = Int32.Parse(invNumStr); Invoice invoice = prodContext.Invoices.Where(i => i.InvoiceNumber == invnum).FirstOrDefault(); prodContext.Entry(invoice).Collection(inv => inv.ProductInvoices).Load(); Console.WriteLine("List of products for given invoice:"); foreach (ProductInvoice prodInv in invoice.ProductInvoices) { prodContext.Entry(prodInv).Reference(prodInv => prodInv.Invoice).Load(); Console.WriteLine(prodInv.Product.Name); } }
public static void ShowProductInvoices(ProdContext prodContext) { Console.WriteLine("ProductInvoices:"); foreach (ProductInvoice item in prodContext.ProductInvoices) { prodContext.Entry(item).Reference(item => item.Product).Load(); prodContext.Entry(item).Reference(item => item.Invoice).Load(); if (item.Product != null) { Console.Write("Product:"); Console.WriteLine(item.Product.Name); } if (item.Invoice != null) { Console.Write("Invoice:"); Console.WriteLine(item.Invoice.InvoiceNumber); } Console.WriteLine(); } }
public static void ShowCategoriesWithProducts(ProdContext prodContext) { Console.WriteLine("List of categories with products:"); foreach (Category cat in prodContext.Categories) { prodContext.Entry(cat).Collection(cat => cat.Products).Load(); Console.WriteLine(cat.Name); foreach (Product prod in cat.Products) { Console.WriteLine(prod.Name); } } }
public static void ShowProductsWithCategories(ProdContext prodContext) { Console.WriteLine("List of products with categories:"); foreach (Product item in prodContext.Products) { prodContext.Entry(item).Reference(prod => prod.Category).Load(); if (item.Category != null) { Console.WriteLine(item.Name + " " + item.Category.Name); } else { Console.WriteLine(item.Name); } } }
//public static void ShowProductsWithSuppliers(ProdContext prodContext) // { // Console.WriteLine("List of products with suppliers:"); // foreach (Product item in prodContext.Products) // { // prodContext.Entry(item).Reference(prod => prod.Supplier).Load(); // if (item.Supplier != null) // { // Console.WriteLine(item.Name + " " + item.Supplier.CompanyName); // } // else // { // Console.WriteLine(item.Name); // } // } // } public static void ShowProductsWithSuppliers(ProdContext prodContext) { Console.WriteLine("List of products with suppliers:"); foreach (Product item in prodContext.Products) { prodContext.Entry(item).Reference(prod => prod.Supplier).Load(); if (item.Supplier != null) { Console.WriteLine(item.Name + " " + item.Supplier.CompanyName); } else { Console.WriteLine(item.Name); } } }
public static void ShowSuppliersWithProducts(ProdContext prodContext) { Console.WriteLine("List of suppliers with products:"); foreach (Company comp in prodContext.Companies) { if (comp is Supplier) { Supplier supp = (Supplier)comp; prodContext.Entry(supp).Collection(supp => supp.Products).Load(); Console.WriteLine(supp.CompanyName); foreach (Product prod in supp.Products) { Console.WriteLine(prod.Name); } } } }