private List <CbcBody_Type> GetCbcBodies(ExcelPackage package)
{
var cbcBodies = new List <CbcBody_Type>();
var cbcBody = new CbcBody_Type();
cbcBody.ReportingEntity = GetReportingEntity(package);
cbcBody.AdditionalInfo = GetCorrectableAdditionalInfo(package).ToArray();
cbcBody.CbcReports = GetCbcReports(package).ToArray();
cbcBodies.Add(cbcBody);
return(cbcBodies);
}
private static StringBuilder CreateCbCReportRowsAndData(CbcBody_Type cbcBody)
{
var reportRows = new StringBuilder();
foreach (var report in cbcBody.CbcReports)
{
reportRows.AppendFormat("<tr {0}>", GetRowAttributes());
reportRows.AppendFormat("<td nowrap {1}>{0}</td>", report.ResCountryCode, GetColumnAttributes());
reportRows.AppendFormat("<td nowrap {1}>{0}</td>", report.Summary.Revenues.Unrelated.Value, GetCurrencyColumnAttributes());
reportRows.AppendFormat("<td nowrap {1}>{0}</td>", report.Summary.Revenues.Related.Value, GetCurrencyColumnAttributes());
reportRows.AppendFormat("<td nowrap {1}>{0}</td>", report.Summary.Revenues.Total.Value, GetCurrencyColumnAttributes());
reportRows.AppendFormat("<td nowrap {1}>{0}</td>", report.Summary.ProfitOrLoss.Value, GetCurrencyColumnAttributes());
reportRows.AppendFormat("<td nowrap {1}>{0}</td>", report.Summary.TaxPaid.Value, GetCurrencyColumnAttributes());
reportRows.AppendFormat("<td nowrap {1}>{0}</td>", report.Summary.TaxAccrued.Value, GetCurrencyColumnAttributes());
reportRows.AppendFormat("<td nowrap {1}>{0}</td>", report.Summary.Capital.Value, GetCurrencyColumnAttributes());
reportRows.AppendFormat("<td nowrap {1}>{0}</td>", report.Summary.Earnings.Value, GetCurrencyColumnAttributes());
reportRows.AppendFormat("<td nowrap {1}>{0}</td>", report.Summary.Assets.Value, GetCurrencyColumnAttributes());
reportRows.AppendFormat("<td nowrap {1}>{0}</td>", report.Summary.NbEmployees, GetColumnAttributes());
reportRows.AppendFormat("<td nowrap {1}>{0}</td>", report.DocSpec.DocRefId, GetColumnAttributes());
reportRows.AppendFormat("<td nowrap {1}>{0}</td>", report.DocSpec.DocTypeIndic, GetColumnAttributes());
reportRows.AppendFormat("<td nowrap {1}>{0}</td>", report.DocSpec.CorrDocRefId, GetColumnAttributes());
reportRows.Append("</tr>");
if (report.ConstEntities != null && report.ConstEntities.Any())
{
// var constEntityHeader = CreateConstEntityHeader();
reportRows.AppendFormat("<tr><td {0}></td></tr>", GetEmptyRowStyle());
reportRows.AppendFormat("<tr {0}>", GetRowAttributes());
reportRows.Append("<td></td>");
reportRows.Append("<td colspan=\"13\">");
reportRows.Append("<table width=\"100%\">");
reportRows.Append(CreateConstEntityHeader());
foreach (var constEntity in report.ConstEntities)
{
reportRows.AppendFormat("{0}", CreateConstEntityRowAndData(constEntity));
}
reportRows.Append("</table>");
reportRows.Append("</td>");
reportRows.Append("</tr>");
}
}
return(reportRows);
}
private static Dto.Report GetReport(CbcBody_Type e)
{
if (e is null)
{
return(new Dto.Report());
}
return(new Dto.Report
{
ReportingEntity = GetReportingEntity(e.ReportingEntity),
ConstituentEntities = e.CbcReports
.SelectManyOrEmpty(x => x.ConstEntities)
.SelectOrEmpty(GetConstituentEntity)
.ToArray(),
AdditionalInfo = e.AdditionalInfo.SelectOrEmpty(GetAdditionalInfo).ToArray(),
Reports = e.CbcReports.SelectOrEmpty(GetReportBody).ToArray(),
});
}
private List <CbcBody_Type> GetCbcBodies(ExcelPackage package)
{
var cbcBodies = new List <CbcBody_Type>();
// We need to loop through something
// for (int i = 0; i < 10; i++) // (S: SUMMARY; Cells:B Count)
//foreach (var receivingCountry in receivingCountries)
//{
var cbcBody = new CbcBody_Type();
cbcBody.ReportingEntity = GetReportingEntity(package);
cbcBody.AdditionalInfo = GetCorrectableAdditionalInfo(package).ToArray();
cbcBody.CbcReports = GetCbcReports(package).ToArray();
cbcBodies.Add(cbcBody);
//}
return(cbcBodies);
}
