private void LoadTables()
{
Sales.Load();
Deposits.Load();
Referents.Load();
Categories.Load();
Articles.Load();
Manufacturers.Load();
}
// fill db with initial values
private void FillDb()
{
Referents.Add(new Referent
{
Name = "jr"
});
Referents.Add(new Referent
{
Name = "jc"
});
Referents.Add(new Referent
{
Name = "cf"
});
Categories.Add(new Category
{
Name = "Bremse"
});
Categories.Add(new Category
{
Name = "Schlauch"
});
Categories.Add(new Category
{
Name = "Kette"
});
Manufacturers.Add(new Manufacturer
{
Name = "Schwalbe"
});
Manufacturers.Add(new Manufacturer
{
Name = "Shimano"
});
Manufacturers.Add(new Manufacturer
{
Name = "Magura"
});
SaveChanges();
Articles.Add(new Article
{
Date = DateTime.Now,
Cat = Categories.Single(m => m.Name.Equals("Schlauch")),
Manufacturer = Manufacturers.Single(m => m.Name.Equals("Schwalbe")),
Model = "AV13",
Price = 5
});
Articles.Add(new Article
{
Date = DateTime.Now,
Cat = Categories.Single(m => m.Name.Equals("Kette")),
Manufacturer = Manufacturers.Single(m => m.Name.Equals("Shimano")),
Model = "9fach",
Price = 9
});
Articles.Add(new Article
{
Date = DateTime.Now,
Cat = Categories.Single(m => m.Name.Equals("Bremse")),
Manufacturer = Manufacturers.Single(m => m.Name.Equals("Magura")),
Model = "HS33",
Price = 80
});
SaveChanges();
log.Info($"Added initial values to Db at {Application.Current.Properties["DataSource"]}");
}
