public string FailureCountTranslator(DataTable dataTable) { FailuresInBooking failuresInBooking = new FailuresInBooking(); foreach (DataRow dataRow in dataTable.Rows) { failuresInBooking.counter = Convert.ToInt32(dataRow["Failure"]); } var json = JsonConvert.SerializeObject(failuresInBooking); return(json); }
public async Task <FailuresInBooking> FailureCountService(UIRequest query) { string result = null; string redisKey = "FailureCount"; result = _cache.Get(redisKey); if (result == null) { DataTable dataTable = await _sqlDatabase.FailureCountDataBase(query); result = _hotelTranslator.FailureCountTranslator(dataTable); _cache.Add(redisKey, result); } FailuresInBooking FailureCount = JsonConvert.DeserializeObject <FailuresInBooking>(result); return(FailureCount); }