private void SaveHighResEnergyValuesToDb(Dictionary <DateTime, TimeSeriesStreamCollection <Dsuid, int> > timeseriesCollections) { foreach (var collection in timeseriesCollections) { var dbEnergySeries = _dbContext.DsEnergyHighresDataSet.Where(x => x.Key == collection.Key).FirstOrDefault(); if (dbEnergySeries == null) { _dbContext.DsEnergyHighresDataSet.Add(dbEnergySeries = new DigitalstromEnergyHighresData() { Key = collection.Key }); } dbEnergySeries.EnergySeriesEveryMeter = collection.Value; } }
private Dictionary <DateTime, TimeSeriesStreamCollection <Dsuid, int> > ReadHighResEnergyValuesFromDb(IEnumerable <DateTime> days) { var timeseriesCollections = new Dictionary <DateTime, TimeSeriesStreamCollection <Dsuid, int> >(); foreach (var day in days) { var dbEnergySeries = _dbContext.DsEnergyHighresDataSet.Where(x => x.Key == day).FirstOrDefault(); if (dbEnergySeries == null) { timeseriesCollections.Add(day, DigitalstromEnergyHighresData.InitialEnergySeriesEveryMeter(day, Dsuids)); } else { timeseriesCollections.Add(day, dbEnergySeries.EnergySeriesEveryMeter); } } return(timeseriesCollections); }