public int AddCompaniesToList(List <CompanyInformation> list)
{
using (var db = new StockDataContext())
{
db.companyInformation.AddRange(list);
// Return the number of companies added to list
return(db.SaveChanges());
}
}
public int AddDailyStockData(List <DailyStockData> stockData, List <CircuitBreaker> circuitBreaker, DateTime date)
{
var symIndMapping = getSymbolToIndustryMapping();
using (var db = new StockDataContext())
{
db.stockData.AddRange(stockData);
stockData.ForEach(x => x.industry = symIndMapping.TryGetValue(x.symbol, out string industry) ? industry : ConstValues.defaultIndustry);
var sectorChange = stockData.GroupBy(x => x.industry)
.Select(x => new SectorInformation(date, x.Key, x.Average(y => y.change)))
.OrderBy(x => x.industry);
db.sectorInformation.AddRange(sectorChange);
if (circuitBreaker != null)
{
db.circuitBreaker.AddRange(circuitBreaker);
}
var count = db.SaveChanges();
Console.WriteLine("Added {0} rows while updating companies Stock Data for {1} ", count, date.ToString());
return(count);
}
}
