private CorrectableReportingEntity_Type GetReportingEntity(ExcelPackage package)
{
var repEnt = new CorrectableReportingEntity_Type();
repEnt.Entity = GetOrganisationPartyType(EnumLookup.GetCountryCodeEnumType(GetExcelStringValue(package, "CoverPage", "B6")), // CountryCode_Type.ZA, // (S: CoverPage; Cells: B7)
EnumLookup.GetCountryCodeEnumType(GetExcelStringValue(package, "CoverPage", "B7")), // CountryCode_Type.ZA, // (S: CoverPage; Cells: B8)
GetExcelStringValue(package, "CoverPage", "B8"), //"9000051715", // (S: CoverPage; Cells: B9)
EnumLookup.GetCountryCodeEnumType(GetExcelStringValue(package, "CoverPage", "B9")), // CountryCode_Type.ZA, // (S: CoverPage; Cells: B10)
GetExcelStringValue(package, "CoverPage", "B10"), //"1918/000095/06", // (S: CoverPage; Cells: B11)
GetExcelStringValue(package, "CoverPage", "B11"), //"Barloworld Limited", // (S: CoverPage; Cells: B12)
EnumLookup.GetCountryCodeEnumType(GetExcelStringValue(package, "CoverPage", "B12")), // CountryCode_Type.ZA, // (S: CoverPage; Cells: B13)
GetExcelStringValue(package, "CoverPage", "B13").Split(';'), // new object[] { "61 Katherine Street", "Sandton", "2196" }, // (S: CoverPage; Cells: B14) "61 Katherine Street;Sandton;2196" (Split on ;)
EnumLookup.GetOECDLegalAddressTypeEnumType(GetExcelStringValue(package, "CoverPage", "B14"))); //OECDLegalAddressType_EnumType.OECD304);// (S: CoverPage; Cells: B15)
repEnt.ReportingRole = EnumLookup.GetCbcReportingRoleEnumType(GetExcelStringValue(package, "CoverPage", "B16")); // CbcReportingRole_EnumType.CBC701; // (S: CoverPage; Cells: B17)
var docTypeIndic = GetExcelStringValue(package, "CoverPage", "B17");
var docRefId = GetExcelStringValue(package, "CoverPage", "B18");
var corrDocRefId = GetExcelStringValue(package, "CoverPage", "B19");
var corrMessageRefId = GetExcelStringValue(package, "CoverPage", "B3");
repEnt.DocSpec = GetDocSpec(package, docTypeIndic, docRefId, corrDocRefId, corrMessageRefId);
return(repEnt);
}
private CorrectableReportingEntity_Type GetReportingEntity(ExcelPackage package)
{
var repEnt = new CorrectableReportingEntity_Type();
var resCountryCode = EnumLookup.GetCountryCodeEnumType(GetExcelStringValue(package, "CoverPage", "B6"));
var tinIssueBy = EnumLookup.GetCountryCodeEnumType(GetExcelStringValue(package, "CoverPage", "B7"));
var tinValue = GetExcelStringValue(package, "CoverPage", "B8");
var OrgInTypeIssueBy = EnumLookup.GetCountryCodeEnumType(GetExcelStringValue(package, "CoverPage", "B9"));
var orgInTypeValue = GetExcelStringValue(package, "CoverPage", "B10");
var nameOrg = GetExcelStringValue(package, "CoverPage", "B11");
var addCountryCode = EnumLookup.GetCountryCodeEnumType(GetExcelStringValue(package, "CoverPage", "B12"));
var adds = GetExcelStringValue(package, "CoverPage", "B13").Split(';');
var legAddType = EnumLookup.GetOECDLegalAddressTypeEnumType(GetExcelStringValue(package, "CoverPage", "B14"));
repEnt.Entity = GetOrganisationPartyType(resCountryCode, tinIssueBy, tinValue, OrgInTypeIssueBy, orgInTypeValue, nameOrg, addCountryCode, adds, legAddType);
repEnt.ReportingRole = EnumLookup.GetCbcReportingRoleEnumType(GetExcelStringValue(package, "CoverPage", "B16")); // CbcReportingRole_EnumType.CBC701; // (S: CoverPage; Cells: B17)
var docTypeIndic = GetExcelStringValue(package, "CoverPage", "B17");
var docRefId = GetExcelStringValue(package, "CoverPage", "B18");
var corrDocRefId = GetExcelStringValue(package, "CoverPage", "B19");
var corrMessageRefId = GetExcelStringValue(package, "CoverPage", "B3");
repEnt.DocSpec = GetDocSpec(package, docTypeIndic, docRefId, corrDocRefId, corrMessageRefId);
repEnt.NameMNEGroup = GetExcelStringValue(package, "CoverPage", "B15");
var reportEndString = GetExcelStringValue(package, "CoverPage", "B5");
var reportEnd = DateTime.Parse(reportEndString);
var reportStart = reportEnd.AddYears(-1);
reportStart = reportStart.AddDays(1);
repEnt.ReportingPeriod = new ReportingEntity_TypeReportingPeriod()
{
StartDate = reportStart,
EndDate = reportEnd
};
return(repEnt);
}
private List <ConstituentEntity_Type> GetConstituentEntities(ExcelPackage package, ReceivingCountryClass receivingCountryClass)
{
var workbookName = "CE_" + receivingCountryClass.CountryCode;
var constEntities = new List <ConstituentEntity_Type>();
int rowNumber = 2;
while (true)
{
var cellValue = GetExcelStringValue(package, workbookName, "A" + rowNumber);
if (string.IsNullOrEmpty(cellValue))
{
break;
}
var constEntity = new ConstituentEntity_Type();
var bizActivities = new List <CbcBizActivityType_EnumType>();
var excelActValue = GetExcelStringValue(package, workbookName, "H" + rowNumber);
var actCodes = excelActValue.Split(';');
foreach (var actCode in actCodes)
{
if (!string.IsNullOrEmpty(actCode))
{
bizActivities.Add(EnumLookup.GetCbcBizActivityTypeEnumType(actCode));
}
}
constEntity.BizActivities = bizActivities.ToArray();
constEntity.ConstEntity = GetOrganisationPartyType(EnumLookup.GetCountryCodeEnumType(GetExcelStringValue(package, workbookName, "G" + rowNumber)),
EnumLookup.GetCountryCodeEnumType(GetExcelStringValue(package, workbookName, "E" + rowNumber)),
GetExcelStringValue(package, workbookName, "D" + rowNumber),
EnumLookup.GetCountryCodeEnumType(GetExcelStringValue(package, workbookName, "C" + rowNumber)),
GetExcelStringValue(package, workbookName, "B" + rowNumber),
GetExcelStringValue(package, workbookName, "A" + rowNumber),
EnumLookup.GetCountryCodeEnumType(GetExcelStringValue(package, workbookName, "K" + rowNumber)),
GetExcelStringValue(package, workbookName, "J" + rowNumber).Split(';'),
EnumLookup.GetOECDLegalAddressTypeEnumType(GetExcelStringValue(package, workbookName, "L" + rowNumber)));
// TODO - It doesnt want to serialize this
constEntity.IncorpCountryCode = EnumLookup.GetCountryCodeEnumType(GetExcelStringValue(package, workbookName, "F" + rowNumber));
constEntity.IncorpCountryCodeSpecified = true;
constEntity.OtherEntityInfo = GetExcelStringValue(package, workbookName, "I" + rowNumber);
constEntities.Add(constEntity);
rowNumber++;
}
this.ConstituentEntitiesSummaries.Add(new ConstituentEntitiesSummary {
CountryCode = receivingCountryClass.CountryCode, ConstituentEntityCount = rowNumber - 2
});
return(constEntities);
}
private List <ConstituentEntity_Type> GetConstituentEntities(ExcelPackage package, ReceivingCountryClass receivingCountryClass)
{
var workbookName = "CE_" + receivingCountryClass.CountryCode;
var constEntities = new List <ConstituentEntity_Type>();
int rowNumber = 2;
while (true)
{
var cellValue = GetExcelStringValue(package, workbookName, "A" + rowNumber);
if (string.IsNullOrEmpty(cellValue))
{
break;
}
var constEntity = new ConstituentEntity_Type();
var bizActivities = new List <CbcBizActivityType_EnumType>();
var excelActValue = GetExcelStringValue(package, workbookName, "H" + rowNumber);
var actCodes = excelActValue.Split(';');
foreach (var actCode in actCodes)
{
if (!string.IsNullOrEmpty(actCode))
{
bizActivities.Add(EnumLookup.GetCbcBizActivityTypeEnumType(actCode));
}
}
constEntity.BizActivities = bizActivities.ToArray();
var resCountryCode = EnumLookup.GetCountryCodeEnumType(GetExcelStringValue(package, workbookName, "G" + rowNumber));
var tinIssueBy = EnumLookup.GetCountryCodeEnumType(GetExcelStringValue(package, workbookName, "E" + rowNumber));
var tinValue = GetExcelStringValue(package, workbookName, "D" + rowNumber);
var OrgInTypeIssueBy = EnumLookup.GetCountryCodeEnumType(GetExcelStringValue(package, workbookName, "C" + rowNumber));
var orgInTypeValue = GetExcelStringValue(package, workbookName, "B" + rowNumber);
var nameOrg = GetExcelStringValue(package, workbookName, "A" + rowNumber);
var addCountryCode = EnumLookup.GetCountryCodeEnumType(GetExcelStringValue(package, workbookName, "K" + rowNumber));
var adds = GetExcelStringValue(package, workbookName, "J" + rowNumber).Split(';');
var legAddType = EnumLookup.GetOECDLegalAddressTypeEnumType(GetExcelStringValue(package, workbookName, "L" + rowNumber));
constEntity.ConstEntity = GetOrganisationPartyType(resCountryCode, tinIssueBy, tinValue, OrgInTypeIssueBy, orgInTypeValue, nameOrg, addCountryCode, adds, legAddType);
constEntity.IncorpCountryCode = EnumLookup.GetCountryCodeEnumType(GetExcelStringValue(package, workbookName, "F" + rowNumber));
constEntity.IncorpCountryCodeSpecified = true;
constEntity.OtherEntityInfo = GetExcelStringValue(package, workbookName, "I" + rowNumber);
constEntity.Role = UltimateParentEntityRole_EnumType.CBC801;
constEntity.RoleSpecified = true;
constEntities.Add(constEntity);
rowNumber++;
}
this.ConstituentEntitiesSummaries.Add(new ConstituentEntitiesSummary {
CountryCode = receivingCountryClass.CountryCode, ConstituentEntityCount = rowNumber - 2
});
return(constEntities);
}
