private void WriteReportSummarySheet(GLRecapReport glRecapReport)
{
var subTitle = "Report Summary";
_src = glRecapReport;
_xl = new CellWriter1ByRow("GL_Recap", subTitle);
WriteSheetHeader(subTitle);
var labelCol = 2;
var colSpan = 8;
WriteRepSmryRowLabels(labelCol, colSpan);
WriteTotalsRowLabel(labelCol, colSpan);
var nextCol = labelCol + colSpan;
var rowCount = _src.Count;
WriteRepSmryAmounts(nextCol, "Debit", _ => _.TotalDebits);
SummarizeCurrentColumn(rowCount);
WriteRepSmryAmounts(nextCol + 1, "Credit", _ => _.TotalCredits);
SummarizeCurrentColumn(rowCount);
SetRowHeights(rowCount);
}
public ColxnSummaryExcelWriter(ColxnSummaryReport colxnSummaryReport)
{
_xl = new CellWriter1ByRow("Collections_Summary");
_src = colxnSummaryReport;
_src.RemoveZeroSections();
WriteTitles();
writeDatesColumn();
WriteBill("Rent", _ => _.Rent);
WriteBill("Rights", _ => _.Rights);
WriteBill("Electric", _ => _.Electric);
WriteBill("Water", _ => _.Water);
WriteBill("Ambulants", _ => _.Ambulant);
WriteColumnsForOthers();
WriteTotalColumn("Total Collections", _ => _.CollectionsSum, _ => _.TotalCollections);
WriteTotalColumn("Total Deposits", _ => _.DepositsSum, _ => _.TotalDeposits);
SetRowHeights();
}
