private static void SeedBrands(AssetTrackerContext context)
{
if (context.Brands.Any())
{
return;
}
var brands = new Brand[]
{
new Brand {
Name = "Acer",
},
new Brand {
Name = "Apple",
},
new Brand {
Name = "HP",
},
new Brand {
Name = "Lenovo",
},
new Brand {
Name = "Samsung",
}
};
foreach (var brand in brands)
{
context.Brands.Add(brand);
}
context.SaveChanges();
}
private static void SeedFormFactors(AssetTrackerContext context)
{
if (context.FormFactors.Any())
{
return;
}
var formFactors = new FormFactor[]
{
new FormFactor {
Name = "Desktop",
},
new FormFactor {
Name = "Laptop",
},
new FormFactor {
Name = "Phone",
},
new FormFactor {
Name = "Tablet",
}
};
foreach (var formFactor in formFactors)
{
context.FormFactors.Add(formFactor);
}
context.SaveChanges();
}
private static void SeedAssets(AssetTrackerContext context)
{
if (context.Assets.Any())
{
return;
}
var assets = new Asset[]
{
new Asset {
PurchaseDate = new DateTime(2020, 6, 23),
Product = context.Products.Where(product => product.Name == "15-eq1801").FirstOrDefault(),
Office = context.Offices.Where(office => office.City == "Berlin").FirstOrDefault(),
},
new Asset {
PurchaseDate = new DateTime(2017, 10, 10),
Product = context.Products.Where(product => product.Name == "Aspire 3").FirstOrDefault(),
Office = context.Offices.Where(office => office.City == "Boston").FirstOrDefault(),
},
new Asset {
PurchaseDate = new DateTime(2017, 5, 11),
Product = context.Products.Where(product => product.Name == "iPhone 10").FirstOrDefault(),
Office = context.Offices.Where(office => office.City == "Berlin").FirstOrDefault(),
},
new Asset {
PurchaseDate = new DateTime(2019, 2, 18),
Product = context.Products.Where(product => product.Name == "iPhone SE").FirstOrDefault(),
Office = context.Offices.Where(office => office.City == "Stockholm").FirstOrDefault(),
},
new Asset {
PurchaseDate = new DateTime(2018, 3, 12),
Product = context.Products.Where(product => product.Name == "iPad").FirstOrDefault(),
Office = context.Offices.Where(office => office.City == "Madrid").FirstOrDefault(),
},
new Asset {
PurchaseDate = new DateTime(2019, 9, 26),
Product = context.Products.Where(product => product.Name == "IdeaPad 330").FirstOrDefault(),
Office = context.Offices.Where(office => office.City == "Madrid").FirstOrDefault(),
},
new Asset {
PurchaseDate = new DateTime(2017, 2, 17),
Product = context.Products.Where(product => product.Name == "ProDesk 600").FirstOrDefault(),
Office = context.Offices.Where(office => office.City == "Stockholm").FirstOrDefault(),
},
new Asset {
PurchaseDate = new DateTime(2018, 6, 2),
Product = context.Products.Where(product => product.Name == "Galaxy S10e").FirstOrDefault(),
Office = context.Offices.Where(office => office.City == "Boston").FirstOrDefault(),
}
};
foreach (var asset in assets)
{
context.Assets.Add(asset);
}
context.SaveChanges();
}
public static void Initialize(AssetTrackerContext context)
{
context.Database.EnsureCreated();
SeedCurrencies(context);
SeedOffices(context);
SeedFormFactors(context);
SeedBrands(context);
SeedProducts(context);
SeedAssets(context);
}
private static void SeedOffices(AssetTrackerContext context)
{
if (context.Offices.Any())
{
return;
}
var offices = new Office[]
{
new Office {
City = "Berlin",
Currency = context.Currencies.Where(currency => currency.Code == "EUR").FirstOrDefault(),
},
new Office {
City = "Madrid",
Currency = context.Currencies.Where(currency => currency.Code == "EUR").FirstOrDefault(),
},
new Office {
City = "Stockholm",
Currency = context.Currencies.Where(currency => currency.Code == "SEK").FirstOrDefault(),
},
new Office {
City = "Boston",
Currency = context.Currencies.Where(currency => currency.Code == "USD").FirstOrDefault(),
},
new Office {
City = "New York",
Currency = context.Currencies.Where(currency => currency.Code == "USD").FirstOrDefault(),
},
};
foreach (var office in offices)
{
context.Offices.Add(office);
}
context.SaveChanges();
}
public BrandController(AssetTrackerContext context)
{
_context = context;
}
public OfficeController(AssetTrackerContext context)
{
_context = context;
}
public AssetController(AssetTrackerContext context)
{
_context = context;
}
public FormFactorController(AssetTrackerContext context)
{
_context = context;
}
private static void SeedProducts(AssetTrackerContext context)
{
if (context.Products.Any())
{
return;
}
var products = new Product[]
{
new Product {
Name = "15-eq1801",
Price = 390.50,
Brand = context.Brands.Where(brand => brand.Name == "HP").FirstOrDefault(),
FormFactor = context.FormFactors.Where(formFactor => formFactor.Name == "Laptop").FirstOrDefault(),
},
new Product {
Name = "Aspire 3",
Price = 655.00,
Brand = context.Brands.Where(brand => brand.Name == "Acer").FirstOrDefault(),
FormFactor = context.FormFactors.Where(formFactor => formFactor.Name == "Laptop").FirstOrDefault(),
},
new Product {
Name = "iPhone 10",
Price = 630.00,
Brand = context.Brands.Where(brand => brand.Name == "Apple").FirstOrDefault(),
FormFactor = context.FormFactors.Where(formFactor => formFactor.Name == "Phone").FirstOrDefault(),
},
new Product {
Name = "iPhone SE",
Price = 420.00,
Brand = context.Brands.Where(brand => brand.Name == "Apple").FirstOrDefault(),
FormFactor = context.FormFactors.Where(formFactor => formFactor.Name == "Phone").FirstOrDefault(),
},
new Product {
Name = "iPad",
Price = 1100.50,
Brand = context.Brands.Where(brand => brand.Name == "Apple").FirstOrDefault(),
FormFactor = context.FormFactors.Where(formFactor => formFactor.Name == "Tablet").FirstOrDefault(),
},
new Product {
Name = "ProDesk 600",
Price = 310.00,
Brand = context.Brands.Where(brand => brand.Name == "HP").FirstOrDefault(),
FormFactor = context.FormFactors.Where(formFactor => formFactor.Name == "Desktop").FirstOrDefault(),
},
new Product {
Name = "IdeaPad 330",
Price = 550.99,
Brand = context.Brands.Where(brand => brand.Name == "Lenovo").FirstOrDefault(),
FormFactor = context.FormFactors.Where(formFactor => formFactor.Name == "Laptop").FirstOrDefault(),
},
new Product {
Name = "Galaxy S10e",
Price = 620.50,
Brand = context.Brands.Where(brand => brand.Name == "Samsung").FirstOrDefault(),
FormFactor = context.FormFactors.Where(formFactor => formFactor.Name == "Phone").FirstOrDefault(),
}
};
foreach (var product in products)
{
context.Products.Add(product);
}
context.SaveChanges();
}
private static void SeedCurrencies(AssetTrackerContext context)
{
if (context.Currencies.Any())
{
return;
}
var currencies = new Currency[]
{
new Currency {
Name = "American dollar",
Code = "USD",
ExchangeRateRelativeToDollar = 1.00
},
new Currency {
Name = "Brazilian real",
Code = "BRL",
ExchangeRateRelativeToDollar = 5.53
},
new Currency {
Name = "Canadian dollar",
Code = "CAD",
ExchangeRateRelativeToDollar = 1.26
},
new Currency {
Name = "Danish krone",
Code = "DKK",
ExchangeRateRelativeToDollar = 6.12
},
new Currency {
Name = "Euro",
Code = "EUR",
ExchangeRateRelativeToDollar = 0.82
},
new Currency {
Name = "Indian rupee",
Code = "INR",
ExchangeRateRelativeToDollar = 73.08
},
new Currency {
Name = "Japanese yen",
Code = "JPY",
ExchangeRateRelativeToDollar = 106.12
},
new Currency {
Name = "Mexican peso",
Code = "MXN",
ExchangeRateRelativeToDollar = 20.82
},
new Currency {
Name = "Polish zloty",
Code = "PLN",
ExchangeRateRelativeToDollar = 3.71
},
new Currency {
Name = "Pound sterling",
Code = "GBP",
ExchangeRateRelativeToDollar = 0.72
},
new Currency {
Name = "Russian ruble",
Code = "RUB",
ExchangeRateRelativeToDollar = 74.25
},
new Currency {
Name = "Swedish crown",
Code = "SEK",
ExchangeRateRelativeToDollar = 8.29
},
new Currency {
Name = "Swiss franc",
Code = "CHF",
ExchangeRateRelativeToDollar = 0.90
},
new Currency {
Name = "Thai baht",
Code = "THB",
ExchangeRateRelativeToDollar = 30.27
}
};
foreach (var currency in currencies)
{
context.Currencies.Add(currency);
}
context.SaveChanges();
}
public CurrencyController(AssetTrackerContext context)
{
_context = context;
}
