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