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