protected void Increment(Guid id, string propertyName)
{
try
{
MetaDataMember member = m_objectMapper.GetMember(propertyName);
string commandText = "update " + m_objectMapper.TableName + " set " + propertyName + " = " + propertyName + " + 1 where id = '" + id + "'";
ExecuteCommand(commandText);
}
catch (Exception excp)
{
logger.Error("Exception SIPAssetPersistor IncrementProperty (for " + typeof(T).Name + "). " + excp.Message);
throw;
}
}
public override void UpdateProperty(Guid id, string propertyName, object value)
{
try
{
using (IDbConnection connection = m_dbProviderFactory.CreateConnection())
{
connection.ConnectionString = m_dbConnectionStr;
connection.Open();
IDbCommand updateCommand = connection.CreateCommand();
MetaDataMember member = m_objectMapper.GetMember(propertyName);
string parameterName = "1";
DbParameter dbParameter = base.GetParameter(m_dbProviderFactory, member, value, parameterName);
updateCommand.Parameters.Add(dbParameter);
updateCommand.CommandText = "update " + m_objectMapper.TableName + " set " + propertyName + " = ?" + parameterName + " where id = '" + id + "'";
updateCommand.ExecuteNonQuery();
}
}
catch (Exception excp)
{
logger.Error("Exception SQLAssetPersistor UpdateProperty (for " + typeof(T).Name + "). " + excp.Message);
throw;
}
}
