public static ExcelResult AgreementsExcelDownloadImpl(List <Agreement> agreements, string workbookTitle)
{
var workSheets = new List <IExcelWorkbookSheetDescriptor>();
// Agreements
var agreementExcelSpec = new AgreementExcelSpec();
var agreementWorkSheet = ExcelWorkbookSheetDescriptorFactory.MakeWorksheet($"{FieldDefinition.Agreement.GetFieldDefinitionLabelPluralized()}", agreementExcelSpec, agreements);
workSheets.Add(agreementWorkSheet);
// Overall excel file
var wbm = new ExcelWorkbookMaker(workSheets);
var excelWorkbook = wbm.ToXLWorkbook();
return(new ExcelResult(excelWorkbook, workbookTitle));
}
private ExcelResult GrantsExcelDownloadImpl(List<Grant> grants, List<GrantAllocation> grantAllocations, string workbookTitle)
{
var workSheets = new List<IExcelWorkbookSheetDescriptor>();
// Grants
var grantSpec = new GrantExcelSpec();
var wsGrants = ExcelWorkbookSheetDescriptorFactory.MakeWorksheet($"{FieldDefinition.Grant.GetFieldDefinitionLabelPluralized()}", grantSpec, grants);
workSheets.Add(wsGrants);
// Grant Allocations
var grantAllocationsSpec = new GrantAllocationExcelSpec();
var wsGrantAllocations = ExcelWorkbookSheetDescriptorFactory.MakeWorksheet($"{FieldDefinition.GrantAllocation.GetFieldDefinitionLabelPluralized()}", grantAllocationsSpec, grantAllocations);
workSheets.Add(wsGrantAllocations);
// Overall excel file
var wbm = new ExcelWorkbookMaker(workSheets);
var excelWorkbook = wbm.ToXLWorkbook();
return new ExcelResult(excelWorkbook, workbookTitle);
}
public ExcelResult IndexExcelDownload()
{
var projects = HttpRequestStorage.DatabaseEntities.Projects.ToList().GetActiveProjectsAndProposals(CurrentFirmaSession.CanViewProposals(), CurrentFirmaSession);
var projectsSpec = new ProjectAssessmentExcelSpec();
var wsProjects = ExcelWorkbookSheetDescriptorFactory.MakeWorksheet("Projects", projectsSpec, projects);
var questionsSpec = new QuestionsExcelSpec();
var wsQuestions = ExcelWorkbookSheetDescriptorFactory.MakeWorksheet("Questions", questionsSpec, HttpRequestStorage.DatabaseEntities.AssessmentQuestions.ToList());
var workSheets = new List <IExcelWorkbookSheetDescriptor>
{
wsProjects,
wsQuestions
};
var wbm = new ExcelWorkbookMaker(workSheets);
var excelWorkbook = wbm.ToXLWorkbook();
return(new ExcelResult(excelWorkbook, $" Assessment as of {DateTime.Now.ToStringDateTime()}"));
}
