public IActionResult PopulateFinancial()
{
financial_API finance = JsonConvert.DeserializeObject <financial_API>(TempData["financials"].ToString());
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("Financial_View", finance));
}
/// <summary>
/// Delete all records from tables
/// </summary>
/// <param name="tableToDel">Table to clear</param>
public IActionResult financials(string symbol)
{
financial_API financial = new financial_API();
financial.company = dbContext.Companies.ToList();
if (symbol != null)
{
financial.finance = getFinancials(symbol);
}
else
{
financial.finance = getFinancials("aapl");
}
TempData["financials"] = JsonConvert.SerializeObject(financial);
return(View("Financial_View", financial));
}
