public void Create_Default()
{
const int id = 19334;
var test = new SetStatusTableStatusCommand(id, QueueStatuses.Processing);
Assert.Equal(id, test.QueueId);
Assert.Equal(QueueStatuses.Processing, test.Status);
}
public void Handle(SetStatusTableStatusCommand <long> command)
{
using (var connection = _dbConnectionFactory.Create())
{
connection.Open();
using (var commandSql = connection.CreateCommand())
{
_prepareCommand.Handle(command, commandSql, CommandStringTypes.UpdateStatusRecord);
commandSql.ExecuteNonQuery();
}
}
}
/// <inheritdoc />
public void Handle(SetStatusTableStatusCommand <long> command, IDbCommand dbCommand, CommandStringTypes commandType)
{
dbCommand.CommandText = _commandCache.GetCommand(commandType);
var queueId = dbCommand.CreateParameter();
queueId.ParameterName = "@QueueID";
queueId.DbType = DbType.Int64;
queueId.Value = command.QueueId;
dbCommand.Parameters.Add(queueId);
var status = dbCommand.CreateParameter();
status.ParameterName = "@Status";
status.DbType = DbType.Int16;
status.Value = Convert.ToInt16(command.Status);
dbCommand.Parameters.Add(status);
}
