private static CommitmentsTableColumnStructure ParseCommitmentsTableStructure(Table commitments)
{
var structure = new CommitmentsTableColumnStructure();
for (var c = 0; c < commitments.Header.Count; c++)
{
var header = commitments.Header.ElementAt(c);
switch (header)
{
case "ULN":
structure.UlnIndex = c;
break;
case "priority":
structure.PriorityIndex = c;
break;
case "Employer":
structure.EmployerIndex = c;
break;
case "Provider":
structure.ProviderIndex = c;
break;
case "agreed price":
structure.PriceIndex = c;
break;
case "commitment Id":
structure.CommitmentIdIndex = c;
break;
case "version Id":
structure.VersionIdIndex = c;
break;
case "start date":
structure.StartDateIndex = c;
break;
case "end date":
structure.EndDateIndex = c;
break;
case "status":
structure.StatusIndex = c;
break;
case "effective from":
structure.EffectiveFromIndex = c;
break;
case "effective to":
structure.EffectiveToIndex = c;
break;
case "standard code":
structure.StandardCodeIndex = c;
break;
case "framework code":
structure.FrameworkCodeIndex = c;
break;
case "programme type":
structure.ProgrammeTypeIndex = c;
break;
case "pathway code":
structure.PathwayCodeIndex = c;
break;
default:
throw new ArgumentException($"Unexpected column in commitments table: {header}");
}
}
if (structure.UlnIndex == -1)
{
throw new ArgumentException("Commitments table is missing ULN column");
}
if (structure.StartDateIndex == -1)
{
throw new ArgumentException("Commitments table is missing start date column");
}
if (structure.EndDateIndex == -1)
{
throw new ArgumentException("Commitments table is missing end date column");
}
return(structure);
}
private static CommitmentReferenceData ParseCommitmentsTableRow(TableRow row, CommitmentsTableColumnStructure structure, int rowIndex, LookupContext lookupContext)
{
var learnerId = row[structure.UlnIndex];
var uln = lookupContext.AddOrGetUln(learnerId);
var providerId = structure.ProviderIndex > -1 ? row[structure.ProviderIndex] : Defaults.ProviderId;
var ukprn = lookupContext.AddOrGetUkprn(providerId);
var status = (CommitmentPaymentStatus)row.ReadRowColumnValue <string>(structure.StatusIndex, "status", Defaults.CommitmentStatus).ToEnumByDescription(typeof(CommitmentPaymentStatus));
int priority = Defaults.CommitmentPriority;
if (structure.PriorityIndex > -1 && !int.TryParse(row[structure.PriorityIndex], out priority))
{
throw new ArgumentException($"'{row[structure.PriorityIndex]}' is not a valid priority");
}
var employerAccountId = Defaults.EmployerAccountId;
if (structure.EmployerIndex > -1 && (row[structure.EmployerIndex].Length < 10 || !int.TryParse(row[structure.EmployerIndex].Substring(9), out employerAccountId)))
{
throw new ArgumentException($"'{row[structure.EmployerIndex]}' is not a valid employer reference");
}
var price = Defaults.AgreePrice;
if (structure.PriceIndex > -1 && !int.TryParse(row[structure.PriceIndex], out price))
{
throw new ArgumentException($"'{row[structure.PriceIndex]}' is not a valid agreed price");
}
var commitmentId = rowIndex + 1;
if (structure.CommitmentIdIndex > -1 && !int.TryParse(row[structure.CommitmentIdIndex], out commitmentId))
{
throw new ArgumentException($"'{row[structure.CommitmentIdIndex]}' is not a valid commitment id");
}
var versionId = Defaults.CommitmentVersionId;
if (structure.VersionIdIndex > -1)
{
if (string.IsNullOrEmpty(row[structure.VersionIdIndex]))
{
throw new ArgumentException($"'{row[structure.VersionIdIndex]}' is not a valid version id");
}
else
{
versionId = row[structure.VersionIdIndex];
}
if (!versionId.Contains('-'))
{
versionId = int.Parse(versionId).ToString("000");
versionId = $"{commitmentId}-{versionId}";
}
}
DateTime startDate;
if (!DateTime.TryParse(row[structure.StartDateIndex], out startDate))
{
throw new ArgumentException($"'{row[structure.StartDateIndex]}' is not a valid start date");
}
DateTime endDate;
if (!DateTime.TryParse(row[structure.EndDateIndex], out endDate))
{
throw new ArgumentException($"'{row[structure.EndDateIndex]}' is not a valid end date");
}
DateTime?effectiveFrom = null;
if (structure.EffectiveFromIndex > -1 && !TryParseNullableDateTime(row[structure.EffectiveFromIndex], out effectiveFrom))
{
throw new ArgumentException($"'{row[structure.EffectiveFromIndex]}' is not a valid effective from");
}
DateTime?effectiveTo = null;
if (structure.EffectiveToIndex > -1 && string.IsNullOrEmpty(row[structure.EffectiveToIndex]))
{
effectiveTo = null;
}
else if (structure.EffectiveToIndex > -1 && !TryParseNullableDateTime(row[structure.EffectiveToIndex], out effectiveTo))
{
throw new ArgumentException($"'{row[structure.EffectiveToIndex]}' is not a valid effective to");
}
var standardCode = row.ReadRowColumnValue <long>(structure.StandardCodeIndex, "standard code", Defaults.StandardCode);
var frameworkCode = row.ReadRowColumnValue <int>(structure.FrameworkCodeIndex, "framework code");
var programmeType = row.ReadRowColumnValue <int>(structure.ProgrammeTypeIndex, "programme type");
var pathwayCode = row.ReadRowColumnValue <int>(structure.PathwayCodeIndex, "pathway code");
if (effectiveFrom == null)
{
effectiveFrom = startDate;
}
return(new CommitmentReferenceData
{
EmployerAccountId = employerAccountId,
LearnerId = learnerId,
Uln = uln,
Priority = priority,
ProviderId = providerId,
Ukprn = ukprn,
AgreedPrice = price,
CommitmentId = commitmentId,
VersionId = versionId,
StartDate = startDate,
EndDate = endDate,
EffectiveFrom = effectiveFrom.Value,
EffectiveTo = effectiveTo,
Status = status,
StandardCode = standardCode,
FrameworkCode = frameworkCode == 0 ? 0 : frameworkCode,
ProgrammeType = programmeType == 0 ? 0 : programmeType,
PathwayCode = pathwayCode == 0 ? 0 : pathwayCode,
});
}