private static string ExtractAddress(ConstituentEntity_Type constEntity, out string addressCountryCode)
{
var entityAddress = string.Empty;
addressCountryCode = string.Empty;
var entityAddresses = constEntity.ConstEntity.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 static StringBuilder CreateConstEntityRowAndData(ConstituentEntity_Type constEntity)
{
var trimCahrs = new[] { '|', ' ' };
var reportingEntityBuilder = new StringBuilder();
var IN = string.Empty;
var inIssuedBy = string.Empty;
if (constEntity.ConstEntity.IN != null && constEntity.ConstEntity.IN.Any())
{
foreach (var _in in constEntity.ConstEntity.IN)
{
IN = IN + _in.Value + "|";
inIssuedBy = _in.issuedBySpecified ? inIssuedBy + _in.issuedBy + "|" : string.Empty;
}
}
var entityName = string.Empty;
if (constEntity.ConstEntity.Name != null && constEntity.ConstEntity.Name.Any())
{
foreach (var name in constEntity.ConstEntity.Name)
{
entityName = entityName + name.Value + "| ";
}
}
string entityAddressCountryCode;
var entityAddress = ExtractAddress(constEntity, out entityAddressCountryCode);
var bizActivities = string.Empty;
if (constEntity.BizActivities != null && constEntity.BizActivities.Any())
{
foreach (var activity in constEntity.BizActivities)
{
bizActivities = bizActivities + activity + "| ";
}
}
reportingEntityBuilder.AppendFormat("<tr {0}>", GetRowAttributes());
reportingEntityBuilder.AppendFormat("<td nowrap {1}>{0}</td>", entityName.Trim(trimCahrs), GetColumnAttributes());
reportingEntityBuilder.AppendFormat("<td nowrap {1}>{0}</td>", string.Join(",", constEntity.ConstEntity.ResCountryCode), GetColumnAttributes());
reportingEntityBuilder.AppendFormat("<td nowrap {1}>{0}</td>", constEntity.ConstEntity.TIN.Value, GetColumnAttributes());
reportingEntityBuilder.AppendFormat("<td nowrap {1}>{0}</td>", constEntity.ConstEntity.TIN.issuedBySpecified ? constEntity.ConstEntity.TIN.issuedBy.ToString() : string.Empty, GetColumnAttributes());
reportingEntityBuilder.AppendFormat("<td nowrap {1}>{0}</td>", IN.TrimEnd(trimCahrs), GetColumnAttributes());
reportingEntityBuilder.AppendFormat("<td nowrap {1}>{0}</td>", inIssuedBy.TrimEnd(trimCahrs), GetColumnAttributes());
reportingEntityBuilder.AppendFormat("<td nowrap {1}>{0}</td>", entityAddress.Trim(trimCahrs), GetColumnAttributes());
reportingEntityBuilder.AppendFormat("<td nowrap {1}>{0}</td>", entityAddressCountryCode.Trim(trimCahrs), GetColumnAttributes());
reportingEntityBuilder.AppendFormat("<td nowrap {1}>{0}</td>", constEntity.IncorpCountryCodeSpecified ? constEntity.IncorpCountryCode.ToString() : string.Empty, GetColumnAttributes());
reportingEntityBuilder.AppendFormat("<td nowrap {1}>{0}</td>", bizActivities.Trim(trimCahrs), GetColumnAttributes());
reportingEntityBuilder.AppendFormat("<td nowrap {1}>{0}</td>", constEntity.OtherEntityInfo, GetColumnAttributes());
reportingEntityBuilder.Append("</tr>");
return(reportingEntityBuilder);
}
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)
{
// (S: CE_XX like CE_AO; Cells: X Count)
var cellValue = GetExcelStringValue(package, workbookName, "A" + rowNumber);
if (string.IsNullOrEmpty(cellValue))
{
break;
}
// // Loop
//for (int i = 0; i < 10; i++) // (S: CE_XX like CE_AO; Cells: X Count)
//{
var constEntity = new ConstituentEntity_Type();
var bizActivities = new List <CbcBizActivityType_EnumType>();
//for (int bizA = 0; bizA < 10; bizA++) // (S: CE_XX; Cells: X Count)
//{
// bizActivities.Add(CbcBizActivityType_EnumType.CBC505); // (S: CE_XX; Cells: H)
//}
var excelActValue = GetExcelStringValue(package, workbookName, "H" + rowNumber);
var actCodes = excelActValue.Split(';');
foreach (var actCode in actCodes)
{
if (!string.IsNullOrEmpty(actCode))
{
bizActivities.Add(GetCbcBizActivityTypeEnumType(actCode));
}
}
constEntity.BizActivities = bizActivities.ToArray();
constEntity.ConstEntity = GetOrganisationPartyType(GetCountryCodeEnumType(GetExcelStringValue(package, workbookName, "G" + rowNumber)), // CountryCode_Type.AO, // (S: CE_XX; Cells: G)
GetCountryCodeEnumType(GetExcelStringValue(package, workbookName, "E" + rowNumber)), // CountryCode_Type.AO, // (S: CE_XX; Cells: E)
GetExcelStringValue(package, workbookName, "D" + rowNumber), //"5410000595", // (S: CE_XX; Cells: D)
GetCountryCodeEnumType(GetExcelStringValue(package, workbookName, "C" + rowNumber)), // CountryCode_Type.AO, // (S: CE_XX; Cells: C)
GetExcelStringValue(package, workbookName, "B" + rowNumber), //"1996.1", // (S: CE_XX; Cells: B)
GetExcelStringValue(package, workbookName, "A" + rowNumber), //"Barloworld Equipamentos Angola Limitada", // (S: CE_XX; Cells: A)
GetCountryCodeEnumType(GetExcelStringValue(package, workbookName, "K" + rowNumber)), // CountryCode_Type.AO, // (S: CE_XX; Cells: K)
GetExcelStringValue(package, workbookName, "J" + rowNumber).Split(';'), //new object[] { "", "" }, // (S: CE_XX; Cells: J)
GetOECDLegalAddressTypeEnumType(GetExcelStringValue(package, workbookName, "L" + rowNumber))); // OECDLegalAddressType_EnumType.OECD304); // (S: CE_XX; Cells: L)
constEntity.IncorpCountryCode = GetCountryCodeEnumType(GetExcelStringValue(package, workbookName, "F" + rowNumber)); // CountryCode_Type.AO; // (S: CE_XX; Cells: F)
constEntity.IncorpCountryCodeSpecified = true;
constEntity.OtherEntityInfo = GetExcelStringValue(package, workbookName, "I" + rowNumber); // ""; // (S: CE_XX; Cells: I)
constEntity.Role = GetUltimateParentEntityRoleEnumType(GetExcelStringValue(package, workbookName, "M" + rowNumber)); // UltimateParentEntityRole_EnumType.CBC803; // (S: CE_XX; Cells: M)
constEntity.RoleSpecified = true;
constEntities.Add(constEntity);
rowNumber++;
}
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);
}
