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