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); }
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(EnumLookup.GetCbcBizActivityTypeEnumType(actCode)); } } constEntity.BizActivities = bizActivities.ToArray(); constEntity.ConstEntity = GetOrganisationPartyType(EnumLookup.GetCountryCodeEnumType(GetExcelStringValue(package, workbookName, "G" + rowNumber)), // CountryCode_Type.AO, // (S: CE_XX; Cells: G) EnumLookup.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) EnumLookup.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) EnumLookup.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) EnumLookup.GetOECDLegalAddressTypeEnumType(GetExcelStringValue(package, workbookName, "L" + rowNumber))); // OECDLegalAddressType_EnumType.OECD304); // (S: CE_XX; Cells: L) constEntity.IncorpCountryCode = EnumLookup.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 = EnumLookup.GetUltimateParentEntityRoleEnumType(GetExcelStringValue(package, workbookName, "M" + rowNumber)); // UltimateParentEntityRole_EnumType.CBC803; // (S: CE_XX; Cells: M) constEntity.RoleSpecified = true; constEntities.Add(constEntity); rowNumber++; } return(constEntities); }