public async Task Add(FundPurchased fund)
{
using (var context = new InvestmentTrackerDbContext())
{
MutualFundProxy proxy = new MutualFundProxy();
fund.NavPurchasePrice = await proxy.GetPrice(fund.SchemeCode, fund.PurchaseDate);
context.FundPurchased.Add(fund);
context.SaveChanges();
}
}
private void UpdateCache(string schemecode, NavHistory latestNav)
{
using (var context = new InvestmentTrackerDbContext())
{
var latest = context.LatestNavPrice.Where(x => x.SchemeCode == schemecode).SingleOrDefault();
if (latest == null)
{
context.LatestNavPrice.Add(new LatestNavPrice
{
SchemeCode = schemecode,
LastFetch = DateTime.Now.GetIndianDateTime().Date,
Date = latestNav.Date,
NavPrice = latestNav.nav
});
}
else
{
latest.LastFetch = DateTime.Now.GetIndianDateTime();
latest.Date = latestNav.Date;
latest.NavPrice = latestNav.nav;
}
context.SaveChanges();
}
}