public async Task CreateFrequencySummaryForDate(WRLDCWarehouseDbContext _context, DateTime dateTime)
{
// get the raw frequency data for the required date
List <RawFrequency> rawFreqs = await _context.RawFrequencies.Where(rf => rf.DataTime.Date == dateTime.Date).ToListAsync();
// transform the raw frequency data
RawFrequencyTrasformation rawFrequencyTrasformation = new RawFrequencyTrasformation();
MartDailyFrequencySummary martDailyFrequencySummary = rawFrequencyTrasformation.TransformDayFreq(rawFreqs);
// load it to the mart
LoadFrequencySummary loadFrequencySummary = new LoadFrequencySummary();
await loadFrequencySummary.LoadDailyFrequencySummary(_context, martDailyFrequencySummary);
}
public async Task ProcessFrequenciesForDates(WRLDCWarehouseDbContext _context, string oracleConnStr, DateTime startDateTime, DateTime endDateTime)
{
if (startDateTime.Date >= endDateTime.Date)
{
return;
}
// run the job for each day
foreach (DateTime day in DateUtils.EachDay(startDateTime, endDateTime))
{
RawFreqExtract rawFreqExtract = new RawFreqExtract();
List <RawFrequency> rawFreqs = rawFreqExtract.ExtractRawFreqs(oracleConnStr, day, day);
// transform the raw frequency data
RawFrequencyTrasformation rawFrequencyTrasformation = new RawFrequencyTrasformation();
MartDailyFrequencySummary martDailyFrequencySummary = rawFrequencyTrasformation.TransformDayFreq(rawFreqs);
// load it to the mart
LoadFrequencySummary loadFrequencySummary = new LoadFrequencySummary();
await loadFrequencySummary.LoadDailyFrequencySummary(_context, martDailyFrequencySummary);
}
}
