private static List <EasSubmission> BuildSubmissionList(int ukprn, IEnumerable <EasCsvRecord> easCsvRecords, Guid submissionId)
{
var ukprnString = ukprn.ToString();
List <int> distinctCollectionPeriods = new List <int>();
var submissionList = new List <EasSubmission>();
foreach (var record in easCsvRecords)
{
distinctCollectionPeriods.Add(
CollectionPeriodHelper.GetCollectionPeriod(Convert.ToInt32(record.CalendarYear), Convert.ToInt32(record.CalendarMonth)));
}
distinctCollectionPeriods = distinctCollectionPeriods.Distinct().ToList();
foreach (var collectionPeriod in distinctCollectionPeriods)
{
var easSubmission = new EasSubmission()
{
SubmissionId = submissionId,
CollectionPeriod = collectionPeriod,
DeclarationChecked = true,
NilReturn = false,
ProviderName = string.Empty,
Ukprn = ukprnString,
UpdatedOn = DateTime.Now,
};
submissionList.Add(easSubmission);
}
return(submissionList);
}
public async Task <List <EasSubmissionValue> > GetEasSubmissionValuesAsync(int UkPrn, CancellationToken cancellationToken)
{
List <EasSubmissionValue> easSubmissionValues = new List <EasSubmissionValue>();
EasSubmission easSubmission = await _easdbContext.EasSubmissions.Where(x => x.Ukprn == UkPrn.ToString()).OrderByDescending(x => x.UpdatedOn).FirstOrDefaultAsync(cancellationToken);
if (easSubmission != null)
{
easSubmissionValues = easSubmission.EasSubmissionValues.ToList();
}
return(easSubmissionValues);
}
