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);
}
}
}
