private static void AddProduct() { using (DbBusinessContext db = new DbBusinessContext()) { db.SupplierProducts.Add(new SupplierProduct { DateFirstSupplied = DateTime.Now, FK_Product = new Product { category = db.Categories.Find(1), DateFirstissued = DateTime.Now, Description = "Wooden Planks", QuantityInStock = 55, UnitPrice = 20.40f }, FK_Supplier = new Supplier { SupplierName = "Alison Hargreeves", SupplierAddressLine1 = "The Nook", SupplierAddressLine2 = "Crow's Lane" } }); db.SaveChanges(); Console.WriteLine("IT WORKED"); } }
public static void addSupplier() { using (DbBusinessContext db = new DbBusinessContext()) { List <Supplier> Query = db.Suppliers.ToList(); Console.WriteLine("Query add Supplier"); Console.WriteLine("Enter Supplier ID"); int id = Convert.ToInt32(Console.ReadLine()); Console.WriteLine(""); Console.WriteLine("Enter Supplier Name"); string name = Console.ReadLine(); Console.WriteLine(""); Console.WriteLine("Enter Supplier Address1"); string Address1 = Console.ReadLine(); Console.WriteLine(""); Console.WriteLine("Enter Supplier Address2"); string Address2 = Console.ReadLine(); Console.WriteLine(""); Supplier s = new Supplier { SupplierID = id, SupplierName = name, SupplierAddressLine1 = Address1, SupplierAddressLine2 = Address2 }; db.Suppliers.Add(s); db.SaveChanges(); Console.WriteLine(""); Console.ReadKey(); } }