public async Task <ILRFileDetailsModel> GetFileDetails(int ukPrn, CancellationToken cancellationToken) { ILRFileDetailsModel fileDetail = null; try { if (cancellationToken.IsCancellationRequested) { return(null); } fileDetail = await _context.FileDetails .Where(fd => fd.UKPRN == ukPrn) .OrderBy(fd => fd.SubmittedTime) .Select(fd => new ILRFileDetailsModel { FileName = fd.Filename, LastSubmission = fd.SubmittedTime }) .FirstOrDefaultAsync(cancellationToken); } catch (Exception ex) { _logger.LogError($"Failed to get file details with ukPrn {ukPrn}", ex); } if (fileDetail != null && !string.IsNullOrEmpty(fileDetail.FileName)) { fileDetail.Year = FileNameHelper.GetFundingYearFromILRFileName(fileDetail.FileName); } return(fileDetail); }
public async Task <ILRFileDetails> GetFileDetails( int ukPrn, CancellationToken cancellationToken) { ILRFileDetails fileDetail; cancellationToken.ThrowIfCancellationRequested(); using (var context = _rulebaseContext()) { fileDetail = await context.FileDetails .Where(fd => fd.Ukprn == ukPrn) .OrderBy(fd => fd.SubmittedTime) .Select(fd => new ILRFileDetails { FileName = fd.Filename, LastSubmission = fd.SubmittedTime }) .FirstOrDefaultAsync(cancellationToken); } if (fileDetail != null && !string.IsNullOrEmpty(fileDetail.FileName)) { fileDetail.Year = FileNameHelper.GetFundingYearFromILRFileName(fileDetail.FileName); } return(fileDetail); }