public IActionResult Gainers()
{
IEXHandler webHandler = new IEXHandler();
List <StockStats> _list = webHandler.Gainers();
return(View(_list));
}
/****
* Saves the gainers in database.
****/
public void PopulateGainers()
{
IEXHandler webHandler = new IEXHandler();
List <StockStats> gainersListRes = webHandler.Gainers();
String gainersData = JsonConvert.SerializeObject(gainersListRes);
List <StockStats> gainersList = null;
if (gainersData != "")
{
var settings = new JsonSerializerSettings
{
NullValueHandling = NullValueHandling.Ignore,
MissingMemberHandling = MissingMemberHandling.Ignore
};
gainersList = JsonConvert.DeserializeObject <List <StockStats> >(gainersData, settings);
}
foreach (StockStats gainer in gainersList)
{
//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.Gainers.Where(c => c.symbol.Equals(gainer.symbol)).Count() == 0)
{
Gainers gainerData = new Gainers(gainer.symbol, gainer.companyName, gainer.primaryExchange, gainer.sector);
dbContext.Gainers.Add(gainerData);
}
}
dbContext.SaveChanges();
}
public IActionResult Gainers()
{
IEXHandler webHandler = new IEXHandler();
List <StockStats> gainersList = webHandler.Gainers();
PopulateGainers();
return(View(gainersList));
}