// Crud: Create demo
// Strores values in Office table
public static void FillOfficeTable()
{
List <Office> OfficesToDb = new List <Office>
{
// Fields: TaxId, CompanyName, CountryName, CountryCode
new Office(10000, "Lexicon Inc.", CompanyName = "United State of America", "USA"),
new Office(20000, "Lexicon AB", CompanyName = "Sweden", "SWE"),
new Office(30000, "Lexicon SA", CompanyName = "Switzerland", "CHE")
};
Console.Write("Crud: Creating the Office table... ");
using var context = new AssetgDbContext();
foreach (var obj in OfficesToDb)
{
context.Add(obj);
}
context.SaveChanges();
Console.WriteLine("OK, Office table populated.");
}
// Strores products values in Mobiles and Laptops tables
public static void FillProductTable()
{
List <Product> ProductsToDb = new List <Product>
{
// Fields: Brand, Name, Model, Price (in US $), PurchaseDate, Option (bool), BuyerTaxId
// Mobile products
new Mobile("Apple", "iPhone", "I4", 899.0, "2006-12-24", false, 10000),
new Mobile("Apple", "iPhone", "I11", 1899.0, "2021-01-04", false, 20000),
new Mobile("Apple", "iPhone", "I10", 1199.0, "2020-09-29", false, 30000),
new Mobile("Apple", "iPhone", "S6", 799.0, "2018-09-21", false, 20000),
new Mobile("Apple", "iPhone", "8", 949.0, "2018-10-21", false, 10000),
new Mobile("Samsung", "Galaxy", "S4", 199.0, "2015-01-12", false, 30000),
new Mobile("Samsung", "Galaxy", "S4 Plus", 399.0, "2015-01-12", true, 10000),
new Mobile("Samsung", "Galaxy", "S8 Pro", 899.0, "2018-08-01", true, 20000),
new Mobile("Nokia", "SONOK", "NK12", 81.0, "2012-04-19", true, 10000),
new Mobile("Nokia", "SONAK", "NK13", 169.0, "2018-07-19", true, 30000),
new Mobile("Nokia", "SONUK", "NK14", 169.0, "2020-07-21", true, 20000),
// Laptop products
new Laptop("Apple", "iMack", "XB22", 399.0, "2006-12-24", true, 10000),
new Laptop("Apple", "Macbook Pro", "X34", 6999.0, "2018-06-29", false, 20000),
new Laptop("Apple", "Macbook Air", "U34", 999.0, "2020-09-29", false, 30000),
new Laptop("Asus", "AS10", "ASX", 199.0, "2015-01-12", false, 30000),
new Laptop("Asus", "AS20", "ASX", 399.0, "2015-01-12", true, 10000),
new Laptop("Asus", "AS30", "ASX", 899.0, "2018-08-09", false, 20000),
new Laptop("Lenovo", "Thinkpad", "X200", 289.0, "2012-04-19", true, 10000),
new Laptop("Lenovo", "Thinkpad", "X300", 389.0, "2019-08-19", true, 30000),
new Laptop("Lenovo", "Thinkpad", "X800", 899.0, "2021-01-06", false, 20000)
};
Console.Write("Crud: Creating the Product tables... ");
using var context = new AssetgDbContext();
foreach (var obj in ProductsToDb)
{
context.Add(obj);
}
context.SaveChanges();
Console.WriteLine("OK, Product tables populated.");
}