public void UpdateHousebreaks(List <Housebreak> housebreakList) { using (var bhavDBContext = new BhavCopiesDbEntities()) { bhavDBContext.Housebreaks.AddRange(housebreakList); bhavDBContext.SaveChanges(); } }
public void PopulateHousebreaks(Ticker ticker, List <HouseBreakReport> housebreakReport) { using (var bhavDBContext = new BhavCopiesDbEntities()) { foreach (HouseBreakReport hbr in housebreakReport) { Housebreak hb = CreateHousebreakObjectFromHBR(hbr, ticker); bhavDBContext.Housebreaks.Add(hb); } bhavDBContext.SaveChanges(); } }
public void AddBhavCopyUpdateLog(DateTime date, int stocksUpdated, string Status) { using (var bhavDBContext = new BhavCopiesDbEntities()) { BhavCopyUploadLog logObject = new BhavCopyUploadLog(); logObject.Date = date; logObject.NumberOfStocksUpdated = stocksUpdated; logObject.Status = Status; bhavDBContext.BhavCopyUploadLogs.Add(logObject); bhavDBContext.SaveChanges(); } }
public void UploadBhavCopys(List <BhavCopy> bhavCopyObjectList) { using (var bhavDBContext = new BhavCopiesDbEntities()) { foreach (BhavCopy bc in bhavCopyObjectList) { //var bhavCopyfromDB = (from s in bhavDBContext.BhavCopies // where s.Date == bc.Date && s.Ticker == bc.Ticker // select s).ToList(); //if (bhavCopyfromDB.Count == 0) { // Bhav copy of date is not uploaded yet bhavDBContext.BhavCopies.Add(bc); //bhavDBContext.SaveChanges(); } } bhavDBContext.SaveChanges(); } }
public void UploadBhavCopy(BhavCopy bhavCopyObject) { using (var bhavDBContext = new BhavCopiesDbEntities()) { var bhavCopyfromDB = (from s in bhavDBContext.BhavCopies where s.Date == bhavCopyObject.Date && s.Ticker == bhavCopyObject.Ticker select s).ToList(); if (bhavCopyfromDB.Count == 0) { // Bhav copy of date is not uploaded yet bhavDBContext.BhavCopies.Add(bhavCopyObject); bhavDBContext.SaveChanges(); } else { throw new Exception($"BhavCopy of {bhavCopyObject.Date.ToShortDateString()} , {bhavCopyObject.Ticker} already exists"); } } }
public void UpdateIndicator(string Indicator, List <Indicator> IndicatorValues) { using (var bhavDBContext = new BhavCopiesDbEntities()) { if (Indicator == "MAVolume") { foreach (Indicator i in IndicatorValues) { long ticker_Id = i.FK_Ticker_Id; DateTime t = i.Date; var indValueRow = (from indRow in bhavDBContext.Indicators where indRow.FK_Ticker_Id == ticker_Id && indRow.Date == t select indRow)?.First(); indValueRow.Indicator_1 = i.Indicator_1; } bhavDBContext.SaveChanges(); } } }