public async Task <IList <ILR1617.EsfLearningDeliveryDeliverablePeriodisedValues> > Get1617PeriodisedValues(
            int ukPrn,
            ILRConfiguration configuration,
            CancellationToken cancellationToken)
        {
            IList <ILR1617.EsfLearningDeliveryDeliverablePeriodisedValues> values = null;

            try
            {
                if (cancellationToken.IsCancellationRequested)
                {
                    return(null);
                }

                var optionsBuilder = new DbContextOptionsBuilder <ILR1617.ILR1617Context>();
                optionsBuilder.UseSqlServer(
                    configuration.ILR1617ConnectionString,
                    providerOptions => providerOptions.CommandTimeout(60));

                using (_1617Context = new ILR1617.ILR1617Context(optionsBuilder.Options))
                {
                    values = await _1617Context.EsfLearningDeliveryDeliverablePeriodisedValues
                             .Where(v => v.Ukprn == ukPrn)
                             .ToListAsync(cancellationToken);
                }
            }
            catch (Exception ex)
            {
                // _logger.LogError($"Failed to get 16/17 FM70 periodised values with ukPrn {ukPrn}", ex);
            }

            return(values);
        }
        public async Task <ILRFileDetails> GetLatest1617FileDetailsPerUkPrn(
            int ukPrn,
            ILRConfiguration configuration,
            CancellationToken cancellationToken)
        {
            ILRFileDetails result = null;

            try
            {
                if (cancellationToken.IsCancellationRequested)
                {
                    return(null);
                }

                var optionsBuilder = new DbContextOptionsBuilder <ILR1617.ILR1617Context>();
                optionsBuilder.UseSqlServer(
                    configuration.ILR1617ConnectionString,
                    providerOptions => providerOptions.CommandTimeout(60));

                using (_1617Context = new ILR1617.ILR1617Context(optionsBuilder.Options))
                {
                    result = await _1617Context.FileDetails
                             .Where(fd => fd.Ukprn == ukPrn)
                             .OrderByDescending(fd => fd.SubmittedTime)
                             .Select(fd => new ILRFileDetails
                    {
                        FileName       = fd.Filename,
                        LastSubmission = fd.SubmittedTime
                    }).FirstOrDefaultAsync(cancellationToken);
                }
            }
            catch (Exception ex)
            {
                // _logger.LogError($"Failed to get 16/17 file details with ukPrn {ukPrn}", ex);
            }

            return(result);
        }