/// <inheritdoc />
public void Handle(MoveRecordToErrorQueueCommand<long> command, IDbCommand dbCommand, CommandStringTypes commandType)
{
dbCommand.CommandText = _buildSql.Create();
var queueId = dbCommand.CreateParameter();
queueId.ParameterName = "@QueueID";
queueId.DbType = DbType.Int64;
queueId.Value = command.QueueId;
dbCommand.Parameters.Add(queueId);
var exception = dbCommand.CreateParameter();
exception.ParameterName = "@LastException";
exception.DbType = DbType.AnsiString;
exception.Value = command.Exception.ToString();
dbCommand.Parameters.Add(exception);
}
/// <summary>
/// Handles the specified command.
/// </summary>
/// <param name="command">The command.</param>
/// <param name="dbCommand">The database command.</param>
/// <param name="commandType">Type of the command.</param>
public void Handle(MoveRecordToErrorQueueCommand <long> command, IDbCommand dbCommand, CommandStringTypes commandType)
{
dbCommand.CommandText = _buildSql.Create();
var commandSql = dbCommand;
var param = commandSql.CreateParameter();
param.ParameterName = "@QueueID";
param.DbType = DbType.Int64;
param.Value = command.QueueId;
commandSql.Parameters.Add(param);
param = commandSql.CreateParameter();
param.ParameterName = "@LastException";
param.DbType = DbType.String;
param.Value = command.Exception.ToString();
commandSql.Parameters.Add(param);
param = commandSql.CreateParameter();
param.ParameterName = "@CurrentDateTime";
param.DbType = DbType.Int64;
param.Value = _getTime.GetCurrentUtcDate().Ticks;
commandSql.Parameters.Add(param);
}
