private static string ExtractAddress(CorrectableReportingEntity_Type reportingEntity, out string addressCountryCode)
{
var entityAddress = string.Empty;
addressCountryCode = string.Empty;
var entityAddresses = reportingEntity.Entity.Address;
foreach (var address in entityAddresses)
{
foreach (var addressItem in address.Items)
{
if (addressItem is AddressFix_Type)
{
var addFixed = (AddressFix_Type)addressItem;
entityAddress = addFixed.Street;
entityAddress += string.Format(" {0}", addFixed.BuildingIdentifier);
entityAddress += string.Format(" {0}", addFixed.SuiteIdentifier);
entityAddress += string.Format(" {0}", addFixed.FloorIdentifier);
entityAddress += string.Format(" {0}", addFixed.DistrictName);
entityAddress += string.Format(" {0}", addFixed.POB);
entityAddress += string.Format(" {0}", addFixed.PostCode);
entityAddress += string.Format(" {0}", addFixed.City);
entityAddress += string.Format(" {0}", addFixed.CountrySubentity);
}
else
{
entityAddress = entityAddress + addressItem + "|";
}
}
addressCountryCode += address.CountryCode + "|";
}
return(entityAddress);
}
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();
repEnt.Entity = GetOrganisationPartyType(GetCountryCodeEnumType(GetExcelStringValue(package, "CoverPage", "B7")), // CountryCode_Type.ZA, // (S: CoverPage; Cells: B7)
GetCountryCodeEnumType(GetExcelStringValue(package, "CoverPage", "B8")), // CountryCode_Type.ZA, // (S: CoverPage; Cells: B8)
GetExcelStringValue(package, "CoverPage", "B9"), //"9000051715", // (S: CoverPage; Cells: B9)
GetCountryCodeEnumType(GetExcelStringValue(package, "CoverPage", "B10")), // CountryCode_Type.ZA, // (S: CoverPage; Cells: B10)
GetExcelStringValue(package, "CoverPage", "B11"), //"1918/000095/06", // (S: CoverPage; Cells: B11)
GetExcelStringValue(package, "CoverPage", "B12"), //"Barloworld Limited", // (S: CoverPage; Cells: B12)
GetCountryCodeEnumType(GetExcelStringValue(package, "CoverPage", "B13")), // CountryCode_Type.ZA, // (S: CoverPage; Cells: B13)
GetExcelStringValue(package, "CoverPage", "B14").Split(';'), // new object[] { "61 Katherine Street", "Sandton", "2196" }, // (S: CoverPage; Cells: B14) "61 Katherine Street;Sandton;2196" (Split on ;)
GetOECDLegalAddressTypeEnumType(GetExcelStringValue(package, "CoverPage", "B15"))); //OECDLegalAddressType_EnumType.OECD304);// (S: CoverPage; Cells: B15)
repEnt.NameMNEGroup = GetExcelStringValue(package, "CoverPage", "B16"); // "Barloworld Limited"; // (S: CoverPage; Cells: B16)
repEnt.ReportingRole = GetCbcReportingRoleEnumType(GetExcelStringValue(package, "CoverPage", "B17")); // CbcReportingRole_EnumType.CBC701; // (S: CoverPage; Cells: B17)
repEnt.ReportingPeriod = new ReportingEntity_TypeReportingPeriod()
{
StartDate = new DateTime(GetExcelIntValue(package, "CoverPage", "B18").Value, GetExcelIntValue(package, "CoverPage", "B19").Value, GetExcelIntValue(package, "CoverPage", "B20").Value), // new DateTime(2018, 10, 1), // (S: CoverPage; Cells: B18, B19, B20)
EndDate = new DateTime(GetExcelIntValue(package, "CoverPage", "B21").Value, GetExcelIntValue(package, "CoverPage", "B22").Value, GetExcelIntValue(package, "CoverPage", "B23").Value), // new DateTime(2019, 09, 30) // (S: CoverPage; Cells: B21, B22, B23)
};
repEnt.DocSpec = gloabalDocSpec;
return(repEnt);
}
private static ReportingEntity GetReportingEntity(CorrectableReportingEntity_Type e)
{
if (e is null)
{
return(new ReportingEntity());
}
return(new ReportingEntity
{
Doc = GetDoc(e.DocSpec),
Organisation = GetOrganisation(e.Entity),
NameMNEGroup = string.Empty,
Role = Parse <ReportingRoleEnum>(e.ReportingRole),
StartDate = default,
private static ReportingEntity GetReportingEntity(CorrectableReportingEntity_Type e)
{
if (e is null)
{
return(new ReportingEntity());
}
return(new ReportingEntity
{
Doc = GetDoc(e.DocSpec),
Organisation = GetOrganisation(e.Entity),
NameMNEGroup = e.NameMNEGroup,
Role = Parse <ReportingRoleEnum>(e.ReportingRole),
StartDate = e.ReportingPeriod?.StartDate ?? default,
EndDate = e.ReportingPeriod?.EndDate ?? default,
});
private static StringBuilder CreateReportingEntityRowAndData(CorrectableReportingEntity_Type reportingEntity)
{
var reportingEntityBuilder = new StringBuilder();
var trimCahrs = new[] { '|', ' ' };
var IN = string.Empty;
var inIssuedBy = string.Empty;
if (reportingEntity.Entity.IN != null && reportingEntity.Entity.IN.Any())
{
foreach (var _in in reportingEntity.Entity.IN)
{
IN = IN + _in.Value + "|";
inIssuedBy = _in.issuedBySpecified ? inIssuedBy + _in.issuedBy + "|" : string.Empty;
}
}
var entityName = string.Empty;
if (reportingEntity.Entity.Name != null && reportingEntity.Entity.Name.Any())
{
foreach (var name in reportingEntity.Entity.Name)
{
entityName = entityName + name.Value + "| ";
}
}
string entityAddressCountryCode;
var entityAddress = ExtractAddress(reportingEntity, out entityAddressCountryCode);
reportingEntityBuilder.AppendFormat("<tr {0}>", GetRowAttributes());
reportingEntityBuilder.AppendFormat("<td nowrap {1}>{0}</td>", entityName.Trim(trimCahrs), GetReportingEntityColumnAttributes());
reportingEntityBuilder.AppendFormat("<td nowrap {1}>{0}</td>", string.Join(",", reportingEntity.Entity.ResCountryCode), GetReportingEntityColumnAttributes());
reportingEntityBuilder.AppendFormat("<td nowrap {1}>{0}</td>", reportingEntity.ReportingRole, GetReportingEntityColumnAttributes());
reportingEntityBuilder.AppendFormat("<td nowrap {1}>{0}</td>", reportingEntity.Entity.TIN != null? reportingEntity.Entity.TIN.Value : string.Empty, GetReportingEntityColumnAttributes());
reportingEntityBuilder.AppendFormat("<td nowrap {1}>{0}</td>", reportingEntity.Entity.TIN != null ? (reportingEntity.Entity.TIN.issuedBySpecified ? reportingEntity.Entity.TIN.issuedBy.ToString() : string.Empty) : string.Empty, GetReportingEntityColumnAttributes());
reportingEntityBuilder.AppendFormat("<td nowrap {1}>{0}</td>", IN.TrimEnd(trimCahrs), GetReportingEntityColumnAttributes());
reportingEntityBuilder.AppendFormat("<td nowrap {1}>{0}</td>", inIssuedBy.TrimEnd(trimCahrs), GetReportingEntityColumnAttributes());
reportingEntityBuilder.AppendFormat("<td nowrap {1}>{0}</td>", entityAddress.Trim(trimCahrs), GetReportingEntityColumnAttributes());
reportingEntityBuilder.AppendFormat("<td nowrap {1}>{0}</td>", entityAddressCountryCode.Trim(trimCahrs), GetReportingEntityColumnAttributes());
reportingEntityBuilder.AppendFormat("<td nowrap {1}>{0}</td>", reportingEntity.DocSpec.DocRefId, GetReportingEntityColumnAttributes());
reportingEntityBuilder.AppendFormat("<td nowrap {1}>{0}</td>", reportingEntity.DocSpec.DocTypeIndic, GetReportingEntityColumnAttributes());
reportingEntityBuilder.AppendFormat("<td nowrap {1}>{0}</td>", reportingEntity.DocSpec.CorrDocRefId, GetReportingEntityColumnAttributes());
reportingEntityBuilder.Append("</tr>");
return(reportingEntityBuilder);
}
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);
}
