public void ProduceReport()
{
//NewAssets Detail
//NewAssets Summary
//Ongoing Detail
//Ongoing Summary
//PseudoFlows
//PseudoFlowsSummary
_workbookFile = $@"{_metaData.outboundFolder}\{Core.FileNameHelpers.FormatOutboundFileName(_metaData.outboundFile)}";
_xl = new AristotleExcel(_workbookFile);
_xl.AddWorksheet(_newAssetsDetail, "SMA_NewAssets_Summary", SetNewAssetsSummaryColumnFormatProperties());
_xl.AddWorksheet(_newAssetsDetail, "SMA_NewAssets_Detail", SetNewAssetsDetailColumnFormatProperties());
_xl.SaveWorkbook();
}
public void ProduceNonMerrillMorganReport()
{
_workbookFile = $@"{_metaData.outboundFolder}\{Core.FileNameHelpers.FormatOutboundFileName(_metaData.outboundFile)}";
_xl = new AristotleExcel(_workbookFile);
naDetail = BuildUmaNewAssetsDetail();
naSummary = BuildUmaNewAssetsSummary();
ogDetail = BuildUmaOngoingDetail();
ogSummary = BuildOngoingSummary();
finalSummary = BuildFinalSummary(naSummary, ogSummary);
_xl.AddWorksheet(finalSummary, "Top_Level_Summary", ExcelColumnProperties("FinalSummary"));
_xl.AddWorksheet(naSummary, "NewAssets_Summary", ExcelColumnProperties("BroadridgeUma.NewAssetsSummary"));
_xl.AddWorksheet(ogSummary, "Ongoing_Summary", ExcelColumnProperties("BroadridgeUma.OngoingSummary"));
_xl.AddWorksheet(naDetail, "NewAssets_Detail", ExcelColumnProperties("BroadridgeUma.NewAssetsDetail"));
_xl.AddWorksheet(ogDetail, "Ongoing_Detail", ExcelColumnProperties("BroadridgeUma.OngoingDetail"));
_xl.SaveWorkbook();
}
public void ProduceReport()
{
//NewAssets Detail
IEnumerable <GenevaSmaNewAssetsDataModel> naDetail = BuildNewAssetsData();
//NewAssets Summary
IEnumerable <GenevaNewAssetsSummaryDataModel> naSummary = BuildNewAssetsSummaryData(naDetail);
//Ongoing Detail
IEnumerable <GenevaSmaOngoingDetailDataModel> ogDetail = BuildOngoingDetail();
//Ongoing Summary
IEnumerable <GenevaSmaOngoingSummaryDataModel> ogSummary = BuildOngoingSummary();
_workbookFile = $@"{_metaData.outboundFolder}\{Core.FileNameHelpers.FormatOutboundFileName(_metaData.outboundFile)}";
_xl = new AristotleExcel(_workbookFile);
_xl.AddWorksheet(naSummary, "SMA_NewAssets_Summary", SetNewAssetsSummaryColumnFormatProperties());
_xl.AddWorksheet(ogDetail, "SMA_Ongoing_Summary", SetNewAssetsSummaryColumnFormatProperties());
_xl.AddWorksheet(naDetail, "SMA_NewAssets_Detail", SetNewAssetsDetailColumnFormatProperties());
_xl.AddWorksheet(ogDetail, "SMA_Ongoing_Detail", SetOngoingDetailColumnFormatProperties());
_xl.SaveWorkbook();
}
public void ProduceReport()
{
_workbookFile = $@"{_metaData.outboundFolder}\{Core.FileNameHelpers.FormatOutboundFileName(_metaData.outboundFile)}";
_xl = new AristotleExcel(_workbookFile);
naDetail = BuildNewAssetsDetail();
naSummary = BuildNewAssetsSummary();
pfDetail = BuildPseudoFlowDetail();
ogDetail = BuildUmaOngoingDetail();
ogSummary = BuildOngoingSummary();
pfSummary = BuildPseudoFlowSummary();
tlSummary = BuildTopLevelSummary(naDetail, ogDetail);
_xl.AddWorksheet(tlSummary, "Top_Level_Summary", ExcelColumnProperties("GevevaSma.TopLevelSummary"));
_xl.AddWorksheet(naSummary, "NewAssets_Summary", ExcelColumnProperties("BroadridgeUmaMerrillMorgan.NewAssetsSummary"));
_xl.AddWorksheet(ogSummary, "Ongoing_Summary", ExcelColumnProperties("BroadridgeUmaMerrillMorgan.OngoingSummary"));
_xl.AddWorksheet(pfSummary, "Pseudoflow_Summary", ExcelColumnProperties("BroadridgeUmaMerrillMorgan.PseudoflowSummary"));
_xl.AddWorksheet(naDetail, "NewAssets.Detail", ExcelColumnProperties("BroadridgeUmaMerrillMorgan.NewAssetsDetail"));
_xl.AddWorksheet(ogDetail, "Ongoing_Detail", ExcelColumnProperties("BroadridgeMerrillMorgan.OngoingDetail"));
_xl.AddWorksheet(pfDetail, "Pseudoflow_Detail", ExcelColumnProperties("BroadridgeUmaMerrillMorgan.PseudoflowDetail"));
_xl.SaveWorkbook();
}
