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);
}
