public string ListOfAirportsWithCodeTranslator(DataTable dataTable)
{
AirportsWithCodes list = new AirportsWithCodes();
foreach (DataRow dataRow in dataTable.Rows)
{
string airportNameAndCode = Convert.ToString(dataRow["AirportName"]) + "-" + Convert.ToString(dataRow["AirportCode"]);
list.AirportNameWithCode.Add(airportNameAndCode);
}
var json = JsonConvert.SerializeObject(list);
return(json);
}
public async Task <AirportsWithCodes> ListOfAirportsWithCodeService()
{
string result = null;
string redisKey = "AirPortsWithCodes";
result = _cache.Get(redisKey);
if (result == null)
{
DataTable dataTable = await _sqlDatabase.ListOfAirportsWithCodeDatabase();
result = _airTranslator.ListOfAirportsWithCodeTranslator(dataTable);
_cache.Add(redisKey, result);
}
AirportsWithCodes airportsWithCodes = JsonConvert.DeserializeObject <AirportsWithCodes>(result);
return(airportsWithCodes);
}
