public override async Task ExecuteAsync(ReportRequest request,
CancellationToken token,
IProgress <JobStatus> progress = null)
{
#region Reporting initialization
request = await StartRequestAsync(request);
var criterion
= await _serviceFacade.ReportCriterionRepository.GetByIdAsync(request.ReportCriteriaId)
?? throw new GraException($"Report criteria {request.ReportCriteriaId} for report request id {request.Id} could not be found.");
if (criterion.SiteId == null)
{
throw new ArgumentException(nameof(criterion.SiteId));
}
string title = "";
if (criterion.SystemId.HasValue)
{
title = (await _systemRepository.GetByIdAsync(criterion.SystemId.Value)).Name;
}
var report = new StoredReport
{
Title = title,
AsOf = _serviceFacade.DateTimeProvider.Now
};
var reportData = new List <object[]>();
var askIfFirstTime
= await GetSiteSettingBoolAsync(criterion, SiteSettingKey.Users.AskIfFirstTime);
var reportEmailAwardData
= await _vendorCodeTypeRepository.SiteHasEmailAwards(criterion.SiteId.Value);
#endregion Reporting initialization
#region Collect data
UpdateProgress(progress, 1, "Starting report...", request.Name);
// header row
var headerRow = new List <object>
{
"System Name",
"Branch Name"
};
// first time?
if (askIfFirstTime)
{
headerRow.Add("First Time # Earned");
headerRow.Add("First Time # Ordered");
if (reportEmailAwardData)
{
headerRow.Add("First Time # Email Awarded");
}
}
headerRow.Add("# Earned");
headerRow.Add("# Ordered");
if (reportEmailAwardData)
{
headerRow.Add("# Email Awarded");
}
report.HeaderRow = headerRow.ToArray();
int count = 0;
// running totals
int totalEarned = 0;
int totalOrdered = 0;
int totalEmailAwarded = 0;
int totalFirstEarned = 0;
int totalFirstOrdered = 0;
int totalFirstEmailAwarded = 0;
var branches = criterion.SystemId != null
? await _branchRepository.GetBySystemAsync((int)criterion.SystemId)
: await _branchRepository.GetAllAsync((int)criterion.SiteId);
var systemIds = branches
.OrderBy(_ => _.SystemName)
.GroupBy(_ => _.SystemId)
.Select(_ => _.First().SystemId);
foreach (var systemId in systemIds)
{
if (token.IsCancellationRequested)
{
break;
}
foreach (var branch in branches.Where(_ => _.SystemId == systemId))
{
UpdateProgress(progress,
++count * 100 / branches.Count(),
$"Processing: {branch.SystemName} - {branch.Name}",
request.Name);
criterion.SystemId = systemId;
criterion.BranchId = branch.Id;
var row = new List <object> {
branch.SystemName,
branch.Name,
};
if (askIfFirstTime)
{
criterion.IsFirstTimeParticipant = true;
var firstVendorCodes =
await _vendorCodeRepository.GetEarnedCodesAsync(criterion);
int firstEarnedCodes = firstVendorCodes.Count;
int firstUsedCodes = firstVendorCodes.Count(_ => _.IsUsed);
criterion.IsFirstTimeParticipant = false;
row.Add(firstEarnedCodes);
row.Add(firstUsedCodes);
totalFirstEarned += firstEarnedCodes;
totalFirstOrdered += firstUsedCodes;
if (reportEmailAwardData)
{
int firstEmailAwardCodes = firstVendorCodes
.Count(_ => _.EmailAwardSent.HasValue);
row.Add(firstEmailAwardCodes);
totalFirstEmailAwarded += firstEmailAwardCodes;
}
}
var vendorCodes = await _vendorCodeRepository.GetEarnedCodesAsync(criterion);
int earnedCodes = vendorCodes.Count;
int usedCodes = vendorCodes.Count(_ => _.IsUsed);
totalEarned += earnedCodes;
totalOrdered += usedCodes;
row.Add(earnedCodes);
row.Add(usedCodes);
if (reportEmailAwardData)
{
int emailAwardCodes = vendorCodes
.Count(_ => _.EmailAwardSent.HasValue);
totalEmailAwarded += emailAwardCodes;
row.Add(emailAwardCodes);
}
reportData.Add(row.ToArray());
if (token.IsCancellationRequested)
{
break;
}
}
}
report.Data = reportData.ToArray();
// total row
var footerRow = new List <object>
{
"Total",
string.Empty
};
if (askIfFirstTime)
{
footerRow.Add(totalFirstEarned);
footerRow.Add(totalFirstOrdered);
if (reportEmailAwardData)
{
footerRow.Add(totalFirstEmailAwarded);
}
}
footerRow.Add(totalEarned);
footerRow.Add(totalOrdered);
if (reportEmailAwardData)
{
footerRow.Add(totalEmailAwarded);
}
report.FooterRow = footerRow.ToArray();
#endregion Collect data
#region Finish up reporting
if (!token.IsCancellationRequested)
{
ReportSet.Reports.Add(report);
}
await FinishRequestAsync(request, !token.IsCancellationRequested);
#endregion Finish up reporting
}
