private Worksheet RenderColumnTotal(Worksheet worksheet, FundingSummaryReportEarnings model, string header, int column, int row)
{
column = NextMaxColumn(worksheet);
foreach (var category in model.DeliverableCategories)
{
row = NextRowWithBreak(row);
BuildCell(worksheet, header, row, column);
row = RenderDeliverableColumnTotals(worksheet, category, column, row);
}
row = NextRowWithBreak(row);
BuildCell(worksheet, model.YearTotal, row, column);
ApplyStyleToRow(worksheet, row, _reportMonthlyTotalsStyle);
row = NextRow(row);
BuildCell(worksheet, model.CumulativeYearTotal, row, column);
ApplyStyleToRow(worksheet, row, _reportMonthlyTotalsStyle);
return(worksheet);
}
private Worksheet RenderMonthlyTotals(bool firstFundingYear, int monthStart, Worksheet worksheet, FundingSummaryReportEarnings fundingSummaryModel, int row, int?column = null)
{
row = firstFundingYear ? NextMaxRow(worksheet) + 1 : NextRowWithBreak(row);
BuildRow(firstFundingYear, monthStart, worksheet, fundingSummaryModel.MonthlyTotals, row, column ?? 0);
ApplyStyleToRow(worksheet, row, _reportTitleStyle);
row = NextRow(row);
BuildRow(firstFundingYear, monthStart, worksheet, fundingSummaryModel.CumulativeMonthlyTotals, row, column ?? 0);
ApplyStyleToRow(worksheet, row, _reportTitleStyle);
return(worksheet);
}
