public async Task GetTableDataDisadvantagedReturnsEmptyListIfItemsAreNotInCache()
{
//Arrange
SetupEmptyMockCache();
//Act
IEnumerable <TableViewModelDisadvantaged> result = await _redisCache.GetTableDataDisadvantaged();
//Assert
Assert.AreEqual(0, result.Count());
}
public async Task <IActionResult> GetResultsDisadvantaged()
{
_logger.LogInformation("Request made to get JSON object with data for Table All page");
//Check if data is in cache
var resultViewModel = await _cache.GetTableDataDisadvantaged();
//Get results for all schools if data is not in cache
if (resultViewModel.Count() == 0)
{
_logger.LogInformation("Table disadvantaged data is being retrieved from the database");
//Get results for all schools
//where the percentage of disadvantaged pupils is not null
var result = await _result.Get(
r => r.PTFSM6CLA1A != null,
r => r.OrderBy(s => s.School.SCHNAME),
r => r.School);
//Converts from list of SchoolResult to List of TableViewModel
resultViewModel = result.ConvertToTableViewModelDisadvantaged();
//Save list of TableViewModel data to cache
await _cache.SaveTableDataDisadvantaged(resultViewModel);
}
//Check if data is in cache
var resultNatViewModel = await _cache.GetNationalTableDataDisadvantaged();
//Get the national data from database if not in cache
if (resultNatViewModel == null)
{
_logger.LogInformation("Table national disadvantaged data is being retrieved from the database");
var nationalResultLst = await _result.GetNational();
//Because there is only currently national data for 2019 there should only be 1 result
var nationalResult = nationalResultLst.First();
//Convert national SchoolResult object to a TableViewModel object
resultNatViewModel = nationalResult;
//Save National TableViewModel data to cache
await _cache.SaveNationalTableDataDisadvantaged(resultNatViewModel);
}
var data = new { data = resultViewModel, national = resultNatViewModel };
return(Json(data));
}