public Npv Add(Npv npv)
{
db.Add(npv);
AddCashflow(npv.CashFlows);
db.SaveChanges();
return(npv);
}
public static void Initialize(FinanceDbContext context)
{
context.Database.EnsureCreated();
if (context.Npvs.Any())
{
return; // DB has been seeded
}
var npvs = new List <Npv>()
{
new Npv {
Name = "Cashflow 1", IncrementRate = .25m, LowerRate = 1, UpperRate = 2, InitialValue = 10000, TotalNpvAmount = -6145.16
},
new Npv {
Name = "Cashflow 2", IncrementRate = .5m, LowerRate = 1, UpperRate = 2, InitialValue = 2000, TotalNpvAmount = -39.239241451869475
}
};
foreach (Npv s in npvs)
{
context.Npvs.Add(s);
}
context.SaveChanges();
var cashFlows = new List <CashFlow>()
{
new CashFlow {
NpvId = 1, Amount = 1000, NpvAmount = -9009.90
},
new CashFlow {
NpvId = 1, Amount = 2000, NpvAmount = -8034.43
},
new CashFlow {
NpvId = 1, Amount = 3000, NpvAmount = -7078.1
},
new CashFlow {
NpvId = 1, Amount = 7000, NpvAmount = -6145.16
},
new CashFlow {
NpvId = 2, Amount = 1000, NpvAmount = -1009.90099009901
},
new CashFlow {
NpvId = 2, Amount = 1000, NpvAmount = -39.239241451869475
}
};
foreach (CashFlow c in cashFlows)
{
context.CashFlows.Add(c);
}
context.SaveChanges();
}