// 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)); }