private static DataLockEventsTableColumnStructure ParseDataLockEventsTableStructure(Table dataLockEvents)
{
var structure = new DataLockEventsTableColumnStructure();
for (var c = 0; c < dataLockEvents.Header.Count; c++)
{
var header = dataLockEvents.Header.ElementAt(c);
switch (header)
{
case "Price Episode identifier":
structure.PriceEpisodeIdentifierIndex = c;
break;
case "Apprenticeship Id":
structure.ApprenticeshipIdIndex = c;
break;
case "ULN":
structure.UlnIndex = c;
break;
case "ILR Start Date":
structure.IlrStartDateIndex = c;
break;
case "ILR Training Price":
structure.IlrTrainingPriceIndex = c;
break;
case "ILR End point assessment price":
structure.IlrEndpointAssementPriceIndex = c;
break;
case "ILR Effective from":
structure.IlrEffectiveFromIndex = c;
break;
case "ILR Effective to":
structure.IlrEffectiveToIndex = c;
break;
default:
throw new ArgumentException($"Unexpected column in data lock events table: {header}");
}
}
if (structure.PriceEpisodeIdentifierIndex == -1)
{
throw new ArgumentException("Data lock events table is missing Price Episode identifier column");
}
return(structure);
}
private static DataLockEventReferenceData ParseDataLockEventsRow(TableRow row, DataLockEventsTableColumnStructure structure, LookupContext lookupContext)
{
var learnerId = row.ReadRowColumnValue <string>(structure.UlnIndex, "ULN");
var startDate = row.ReadRowColumnValue <DateTime>(structure.IlrStartDateIndex, "ILR Start Date");
var effectiveFrom = row.ReadRowColumnValue <DateTime>(structure.IlrEffectiveFromIndex, "ILR Effective from", startDate);
return(new DataLockEventReferenceData
{
PriceEpisodeIdentifier = row.ReadRowColumnValue <string>(structure.PriceEpisodeIdentifierIndex, "Price Episode identifier"),
ApprenticeshipId = row.ReadRowColumnValue <int>(structure.ApprenticeshipIdIndex, "Apprenticeship Id"),
Uln = lookupContext.AddOrGetUln(learnerId),
IlrStartDate = startDate,
IlrTrainingPrice = row.ReadRowColumnValue <decimal>(structure.IlrTrainingPriceIndex, "ILR Training Price"),
IlrEndpointAssementPrice = row.ReadRowColumnValue <decimal>(structure.IlrEndpointAssementPriceIndex, "ILR End point assessment price"),
ILrEffectiveFrom = effectiveFrom,
ILrEffectiveTo = row.ReadRowColumnValue <DateTime?>(structure.IlrEffectiveToIndex, "ILR Effective to"),
});
}
