// Ratios (part of data from API
public IActionResult Ratios(string symbol) // action
{
//Set ViewBag variable first
ViewBag.dbSucessComp = 0;
List <Financial> financials = new List <Financial>();
if (symbol != null)
{
IEXHandler webHandler = new IEXHandler(); // gets data from api
financials = webHandler.GetFinancials(symbol);
}
CompaniesFinancials companiesFinancials = getCompaniesFinancialsModel(financials);
return(View(companiesFinancials));
}
public IActionResult SaveFinancials(string symbol)
{
IEXHandler webHandler = new IEXHandler();
List <Financial> financials = webHandler.GetFinancials(symbol);
foreach (Financial financial in financials)
{
if (dbContext.Financials.Where(c => c.reportDate.Equals(financial.reportDate)).Where(c => c.symbol.Equals(financial.symbol)).Count() == 0)
{
dbContext.Financials.Add(financial);
}
}
dbContext.SaveChanges();
ViewBag.dbSuccessChart = 1;
CompaniesFinancials companiesFinancials = getCompaniesFinancialsModel(financials);
return(View("Financials", companiesFinancials));
}
