private Workbook GetWorkbookReport(
Workbook workbook,
Worksheet sheet,
FundingSummaryHeaderModel fundingSummaryHeaderModel,
IEnumerable <FundingSummaryModel> fundingSummaryModels,
FundingSummaryFooterModel fundingSummaryFooterModel)
{
WriteExcelRecords(sheet, new FundingSummaryHeaderMapper(), new List <FundingSummaryHeaderModel> {
fundingSummaryHeaderModel
}, _cellStyles[5], _cellStyles[5], true);
foreach (var fundingSummaryModel in fundingSummaryModels)
{
if (string.IsNullOrEmpty(fundingSummaryModel.Title))
{
WriteBlankRow(sheet);
continue;
}
CellStyle excelHeaderStyle = _excelStyleProvider.GetCellStyle(_cellStyles, fundingSummaryModel.ExcelHeaderStyle);
if (fundingSummaryModel.HeaderType == HeaderType.TitleOnly)
{
WriteTitleRecord(sheet, fundingSummaryModel.Title, excelHeaderStyle, _reportWidth);
continue;
}
if (fundingSummaryModel.HeaderType == HeaderType.All)
{
_fundingSummaryMapper.MemberMaps.Single(x => x.Data.Index == 0).Name(fundingSummaryModel.Title);
_cachedHeaders[0] = fundingSummaryModel.Title;
WriteRecordsFromArray(sheet, _fundingSummaryMapper, _cachedHeaders, excelHeaderStyle);
continue;
}
CellStyle excelRecordStyle = _excelStyleProvider.GetCellStyle(_cellStyles, fundingSummaryModel.ExcelRecordStyle);
WriteExcelRecordsFromModelProperty(sheet, _fundingSummaryMapper, _cachedModelProperties, fundingSummaryModel, excelRecordStyle);
}
WriteExcelRecords(sheet, new FundingSummaryFooterMapper(), new List <FundingSummaryFooterModel> {
fundingSummaryFooterModel
}, _cellStyles[5], _cellStyles[5], true);
return(workbook);
}
private Workbook GetWorkbookReport(
Workbook workbook,
Worksheet sheet,
FundingSummaryHeaderModel fundingSummaryHeaderModel,
IEnumerable <FundingSummaryModel> fundingSummaryModels,
FundingSummaryFooterModel fundingSummaryFooterModel)
{
{
WriteExcelRecords(sheet, new FundingSummaryHeaderMapper(), new List <FundingSummaryHeaderModel> {
fundingSummaryHeaderModel
}, _cellStyles[7], _cellStyles[7], true);
var firstFutureColumn = GetFirstFutureColumn();
int lastOperatedRow;
// number of columns minus number of static columns (3)
var endColumn = _cachedHeaders.Count() - 3;
foreach (var fundingSummaryModel in fundingSummaryModels)
{
if (string.IsNullOrEmpty(fundingSummaryModel.Title))
{
WriteBlankRow(sheet);
continue;
}
CellStyle excelHeaderStyle = _excelStyleProvider.GetCellStyle(_cellStyles, fundingSummaryModel.ExcelHeaderStyle);
if (fundingSummaryModel.HeaderType == HeaderType.TitleOnly)
{
WriteTitleRecord(sheet, fundingSummaryModel.Title, excelHeaderStyle, _reportWidth);
continue;
}
if (fundingSummaryModel.HeaderType == HeaderType.All)
{
// Align data to the Right
excelHeaderStyle.Style.HorizontalAlignment = TextAlignmentType.Right;
excelHeaderStyle.StyleFlag.HorizontalAlignment = true;
_fundingSummaryMapper.MemberMaps.Single(x => x.Data.Index == 0).Name(fundingSummaryModel.Title);
_cachedHeaders[0] = fundingSummaryModel.Title;
// this line is the month/year header
WriteRecordsFromArray(sheet, _fundingSummaryMapper, _cachedHeaders, excelHeaderStyle);
lastOperatedRow = GetCurrentRow(sheet) - 1;
// ItaliciseFutureData(sheet, firstFutureColumn, lastOperatedRow, endColumn);
continue;
}
CellStyle excelRecordStyle = _excelStyleProvider.GetCellStyle(_cellStyles, fundingSummaryModel.ExcelRecordStyle);
// Align data to the Right
excelRecordStyle.Style.HorizontalAlignment = TextAlignmentType.Right;
excelRecordStyle.StyleFlag.HorizontalAlignment = true;
// this line is subtotals below the month/ year header
WriteExcelRecordsFromModelProperty(sheet, _fundingSummaryMapper, _cachedModelProperties, fundingSummaryModel, excelRecordStyle);
lastOperatedRow = GetCurrentRow(sheet) - 1;
// ItaliciseFutureData(sheet, firstFutureColumn, lastOperatedRow, endColumn);
}
for (int i = 0; i < workbook.Worksheets.Count; i++)
{
AlignWorkSheetColumnData(workbook.Worksheets[i], 0, TextAlignmentType.Left);
}
WriteExcelRecords(sheet, new FundingSummaryFooterMapper(), new List <FundingSummaryFooterModel> {
fundingSummaryFooterModel
}, _cellStyles[7], _cellStyles[7], true);
return(workbook);
}
}
