public IActionResult financials(string symbol)
{
ViewBag.dbSucessComp = 0;
financialData vfinancial = new financialData();
vfinancial.company = dbContext.Companies.ToList();
try
{
if (symbol != null)
{
vfinancial.finance = getFinancials(symbol);
}
else
{
vfinancial.finance = getFinancials("aapl");
}
TempData["Financial"] = JsonConvert.SerializeObject(vfinancial);
return(View("compFinance", vfinancial));
}
catch (Exception)
{
return(View("compFinance", vfinancial));
}
}
public IActionResult PopulateFinancial()
{
financialData finance = JsonConvert.DeserializeObject <financialData>(TempData["Financial"].ToString());
TempData.Keep("Financial");
foreach (Company item in finance.company)
{
//Database will give PK constraint violation error when trying to insert record with existing PK.
//So add company only if it doesnt exist, check existence using symbol (PK)
if (dbContext.FinancialList.Where(c => c.symbol.Equals(item.symbol)).Count() == 0)
{
dbContext.FinancialList.Add(finance.finance);
}
}
dbContext.SaveChanges();
ViewBag.dbSuccessComp = 1;
return(View("compFinance", finance));
}
