private void SaveBaseRatesToDb(IEnumerable <BaseRate> baseRates)
{
using (var db = new RatesDatabaseContext())
{
db.Database.ExecuteSqlCommand("TRUNCATE TABLE [BaseRates]");
db.BaseRates.AddRange(baseRates);
db.SaveChanges();
}
}
// seed database with initial data
private void SeedDatabase()
{
using (var db = new RatesDatabaseContext())
{
if (db.Customers.Count() > 0)
{
return;
}
Customer customer1 = new Customer(67812203006, "Goras", "Trusevičius");
Customer customer2 = new Customer(78706151287, "Dange", "Kulkavičiutė");
db.Customers.Add(customer1);
db.Customers.Add(customer2);
db.Agreements.Add(new Agreement(12000, BaseRate.RateType.VILIBOR3m, 1.6f, 60, customer1));
db.Agreements.Add(new Agreement(8000, BaseRate.RateType.VILIBOR1y, 0.42f, 36, customer2));
db.Agreements.Add(new Agreement(1000, BaseRate.RateType.VILIBOR6m, 1.85f, 24, customer2));
db.SaveChanges();
}
}
