private List <CorrectableCbcReport_Type> GetCbcReports(ExcelPackage package)
{
var cbcReports = new List <CorrectableCbcReport_Type>();
// Some Loop
foreach (var recCountryCls in receivingCountryClass)
{
var cbcRep = new CorrectableCbcReport_Type();
cbcRep.ResCountryCode = EnumLookup.GetCountryCodeEnumType(recCountryCls.CountryCode);
var docTypeIndic = GetExcelStringValue(package, "SUMMARY", "M" + recCountryCls.RowNumber);
var docRefId = GetExcelStringValue(package, "SUMMARY", "N" + recCountryCls.RowNumber);
var corrDocRefId = GetExcelStringValue(package, "SUMMARY", "O" + recCountryCls.RowNumber);
var corrMessageRefId = GetExcelStringValue(package, "CoverPage", "B3");
cbcRep.DocSpec = GetDocSpec(package, docTypeIndic, docRefId, corrDocRefId, corrMessageRefId);
// Summary
cbcRep.Summary = GetSummary(currCode_Type.ZAR,
GetExcelStringValue(package, "SUMMARY", "K" + recCountryCls.RowNumber),
GetExcelStringValue(package, "SUMMARY", "C" + recCountryCls.RowNumber),
GetExcelStringValue(package, "SUMMARY", "D" + recCountryCls.RowNumber),
GetExcelStringValue(package, "SUMMARY", "L" + recCountryCls.RowNumber),
GetExcelStringValue(package, "SUMMARY", "E" + recCountryCls.RowNumber),
GetExcelStringValue(package, "SUMMARY", "G" + recCountryCls.RowNumber),
GetExcelStringValue(package, "SUMMARY", "F" + recCountryCls.RowNumber),
GetExcelStringValue(package, "SUMMARY", "H" + recCountryCls.RowNumber),
GetExcelStringValue(package, "SUMMARY", "J" + recCountryCls.RowNumber),
GetExcelStringValue(package, "SUMMARY", "I" + recCountryCls.RowNumber));
// Const Entities
cbcRep.ConstEntities = GetConstituentEntities(package, recCountryCls).ToArray();
cbcReports.Add(cbcRep);
}
return(cbcReports);
}
private List <CorrectableCbcReport_Type> GetCbcReports(ExcelPackage package)
{
var cbcReports = new List <CorrectableCbcReport_Type>();
// Some Loop
// for (int i = 0; i < 10; i++) // (S: SUMMARY; Cells: B Count)
foreach (var receivingCountryClass in receivingCountryClass)
{
var cbcRep = new CorrectableCbcReport_Type();
cbcRep.ResCountryCode = GetCountryCodeEnumType(receivingCountryClass.CountryCode); // CountryCode_Type.AO; // (S: SUMMARY; Cells: A)
cbcRep.DocSpec = gloabalDocSpec;
// Summary
// (S: SUMMARY; Cells: ,K ,C ,D ,L ,E ,G ,F ,H ,J ,I)
// cbcRep.Summary = GetSummary(currCode_Type.ZAR, "766604888.40", "-69810833.20", "-1217694218.00", "363", "-217527466.40", "509150539.20", "-771290869.60", "-1280441408.80", "55195379.39", "53236237.67");
cbcRep.Summary = GetSummary(currCode_Type.ZAR,
GetExcelStringValue(package, "SUMMARY", "K" + receivingCountryClass.RowNumber),
GetExcelStringValue(package, "SUMMARY", "C" + receivingCountryClass.RowNumber), // "-69810833.20",
GetExcelStringValue(package, "SUMMARY", "D" + receivingCountryClass.RowNumber), // "-1217694218.00",
GetExcelStringValue(package, "SUMMARY", "L" + receivingCountryClass.RowNumber), // "363",
GetExcelStringValue(package, "SUMMARY", "E" + receivingCountryClass.RowNumber), // "-217527466.40",
GetExcelStringValue(package, "SUMMARY", "G" + receivingCountryClass.RowNumber), // "509150539.20",
GetExcelStringValue(package, "SUMMARY", "F" + receivingCountryClass.RowNumber), // "-771290869.60",
GetExcelStringValue(package, "SUMMARY", "H" + receivingCountryClass.RowNumber), // "-1280441408.80",
GetExcelStringValue(package, "SUMMARY", "J" + receivingCountryClass.RowNumber), // "55195379.39",
GetExcelStringValue(package, "SUMMARY", "I" + receivingCountryClass.RowNumber)); // "53236237.67");
// Const Entities
cbcRep.ConstEntities = GetConstituentEntities(package, receivingCountryClass).ToArray();
cbcReports.Add(cbcRep);
}
return(cbcReports);
}
