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"]}"); }