public void UpdateJsonObject(EditJsonItem model) { var final = new UpdateCacheItemAccessObj(); var byteCode = _cacheService.GetAll(model.CacheKey).SingleOrDefault(x => x.Key == model.CacheKey).Value; //REFACTOR LATER !!!!! var decompressed = Decompress(byteCode); var allItems = DeserializeWholeObject(decompressed, model.JsonPropCount); var editedItems = EditJson(model, allItems); var serializedItems = Serialize(editedItems); var compressedItems = Compress(serializedItems); final.Key = model.CacheKey; final.Value = compressedItems; _cacheRepository.UpdateBytesValue(final); }
public void UpdateBytesValue(UpdateCacheItemAccessObj item) { string sqlQuery = "UPDATE dbo.CacheItems SET value = @Value WHERE key = @Key"; using (var connection = new SqlConnection(_connectionString)) { try { var affectedRows = connection.Execute(sqlQuery, new { Key = item.Key, Value = item.Value }); } catch (Exception ex) { throw new GeneralDatabaseException("A Db related error occured when trying to run your query", ex); } } }