public GetComplianceReport(ComplianceReportDates dateType,
DateTime from,
DateTime to,
ComplianceTextFields?textFieldType,
TextFieldOperator?operatorType,
string textSearch)
{
DateType = dateType;
From = from;
To = to;
TextFieldType = textFieldType;
OperatorType = operatorType;
TextSearch = textSearch;
}
public async Task <ActionResult> Download(ComplianceReportDates dateType,
DateTime from,
DateTime to,
ComplianceTextFields?textFieldType,
TextFieldOperator?operatorType,
string textSearch)
{
var report =
await
mediator.SendAsync(new GetComplianceReport(dateType, from, to, textFieldType, operatorType, textSearch));
var fileName = string.Format("compliance-report-{0}-{1}.xlsx", from.ToShortDateString(), to.ToShortDateString());
var guidance = new ComplianceDataGuidance
{
NotificationNumber = Resources.NotificationNumber,
NoPrenotificationCount = Resources.NoPrenotificationCount,
PreNotificationColour = Resources.PreNotificationColour,
MissingShipments = Resources.MissingShipments,
MissingShipmentsColour = Resources.MissingShipmentsColour,
OverLimitShipments = Resources.OverLimitShipments,
OverActiveLoads = Resources.OverActiveLoads,
OverTonnage = Resources.OverTonnage,
OverTonnageColour = Resources.OverTonnageColour,
OverShipments = Resources.OverShipments,
OverShipmentsColour = Resources.OverShipmentsColour,
Notifier = Resources.Notifier,
Consignee = Resources.Consignee,
FileExpired = Resources.FileExpired
};
var colourGuidance = new ComplianceDataColourGuidance
{
HeaderText = Resources.ColourHeaderText,
GreenText = Resources.GreenText,
AmberText = Resources.AmberText,
RedText = Resources.RedText
};
return(new ComplianceXlsxActionResult(report, new List <ComplianceDataGuidance> {
guidance
}, colourGuidance,
fileName, true));
}
public async Task <IEnumerable <ComplianceData> > GetComplianceReport(ComplianceReportDates dateType,
DateTime from,
DateTime to,
ComplianceTextFields?textFieldType,
TextFieldOperator?operatorType,
string textSearch,
UKCompetentAuthority competentAuthority)
{
var reportlist = await context.Database.SqlQuery <ComplianceDataReport>(@"EXEC [Reports].[Compliance]
@DateType,
@CompetentAuthority,
@From,
@To",
new SqlParameter("@DateType", dateType.ToString()),
new SqlParameter("@CompetentAuthority", (int)competentAuthority),
new SqlParameter("@From", from),
new SqlParameter("@To", to)).ToArrayAsync();
if (!textFieldType.HasValue ||
!operatorType.HasValue ||
string.IsNullOrEmpty(textSearch))
{
return(reportlist);
}
else if (reportlist.Length > 0)
{
var predicate = CreatePredicate(textFieldType.Value.ToString(), textSearch, operatorType);
var query = reportlist.AsQueryable <ComplianceDataReport>();
return(query.Where(predicate));
}
else
{
return(reportlist);
}
}