private void GetRoatpProviders(ExcelPackage package, List <RoatpProvider> roatpProviders) { var roatpWorkSheet = package.Workbook.Worksheets.FirstOrDefault(x => x.Name == "RoATP"); if (roatpWorkSheet == null) { return; } for (var i = roatpWorkSheet.Dimension.Start.Row + 1; i <= roatpWorkSheet.Dimension.End.Row; i++) { var ukprn = roatpWorkSheet.Cells[i, UkprnPosition].Value != null ? roatpWorkSheet.Cells[i, UkprnPosition].Value.ToString() : string.Empty; if (!string.IsNullOrEmpty(ukprn)) { var roatpData = new RoatpProvider { Ukprn = ukprn, Name = roatpWorkSheet.Cells[i, NamePosition].Value != null ? roatpWorkSheet.Cells[i, NamePosition].Value.ToString() : string.Empty, ProviderType = GetProviderType(roatpWorkSheet.Cells[i, ProviderTypePosition].Value, ukprn, i), ContractedForNonLeviedEmployers = GetBooleanValue(roatpWorkSheet.Cells[i, ContractedForNonLeviedEmployersPosition]), ParentCompanyGuarantee = GetBooleanValue(roatpWorkSheet.Cells[i, ParentCompanyGuaranteePosition]), NewOrganisationWithoutFinancialTrackRecord = GetBooleanValue(roatpWorkSheet.Cells[i, NewOrganisationWithoutFinancialTrackRecordPosition]), StartDate = GetDateTimeValue(roatpWorkSheet.Cells[i, StartDatePosition]), EndDate = GetDateTimeValue(roatpWorkSheet.Cells[i, EndDatePosition]), ApplicationDeterminedDate = GetDateTimeValue(roatpWorkSheet.Cells[i, ApplicationDeterminedDatePosition]), CurrentlyNotStartingNewApprentices = GetDateTimeValue(roatpWorkSheet.Cells[i, NotStartingNewApprenticesPosition]) != null }; roatpProviders.Add(roatpData); } } }
public RoatpProviderDocument CreateRoatpProviderDocument(RoatpProvider roatpProvider) { return(new RoatpProviderDocument { Ukprn = roatpProvider.Ukprn, Name = roatpProvider.Name, ContractedForNonLeviedEmployers = roatpProvider.ContractedForNonLeviedEmployers, StartDate = roatpProvider.StartDate, EndDate = roatpProvider.EndDate, ApplicationDeterminedDate = roatpProvider.ApplicationDeterminedDate, NewOrganisationWithoutFinancialTrackRecord = roatpProvider.NewOrganisationWithoutFinancialTrackRecord, ParentCompanyGuarantee = roatpProvider.ParentCompanyGuarantee, ProviderType = roatpProvider.ProviderType, CurrentlyNotStartingNewApprentices = roatpProvider.CurrentlyNotStartingNewApprentices }); }