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); } }