public bool MoveMessageToSubqueue(DbConnection conn, string queueTable, string messageId, Subqueue toSubqueue, Subqueue? fromSubqueue)
{
using (DbCommand cmd = _sql.CreateCommand(conn))
{
cmd.CommandText = string.Format(GetSqlFormatString("MoveMessageToSubqueue"), queueTable);
if (fromSubqueue.HasValue)
{
_sql.AddParameter(cmd, "sq_from", fromSubqueue.Value.ToString());
cmd.CommandText += " and subqueue=@sq_from";
}
_sql.AddParameter(cmd, "id", Convert.ToInt64(messageId));
_sql.AddParameter(cmd, "sq_to", toSubqueue.ToString());
int rows = cmd.ExecuteNonQuery();
log.Info("{0} messages returned to queue {1}", rows, queueTable);
return rows > 0;
}
}
public bool MoveMessageToSubqueue(DbConnection conn, string queueTable, string messageId, Subqueue toSubqueue, Subqueue?fromSubqueue)
{
using (DbCommand cmd = _sql.CreateCommand(conn))
{
cmd.CommandText = string.Format(GetSqlFormatString("MoveMessageToSubqueue"), queueTable);
if (fromSubqueue.HasValue)
{
_sql.AddParameter(cmd, "sq_from", fromSubqueue.Value.ToString());
cmd.CommandText += " and subqueue=@sq_from";
}
_sql.AddParameter(cmd, "id", Convert.ToInt64(messageId));
_sql.AddParameter(cmd, "sq_to", toSubqueue.ToString());
int rows = cmd.ExecuteNonQuery();
log.Info("{0} messages returned to queue {1}", rows, queueTable);
return(rows > 0);
}
}
