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