namespace FrameworkDAL.Query.OutboxMonitor
{
    public static class OutboxMonitorQB
    {
        public const string GET_STATUS_LIST = @"
SELECT
    OUTBOXID        AS OutboxId,
    OBJECTTYPEID    AS ObjectTypeId,
    OBJECTID        AS ObjectId,
    EVENTTYPEID     AS EventTypeId,
    VERSION         AS Version,
    CORRELATIONKEY  AS CorrelationKey,
    USERID          AS UserId,
    TENANTID        AS TenantId,
    STATUS          AS Status,
    CREATEDON       AS CreatedOn,
    PAYLOAD         AS Payload,
    HEADERROWGUID   AS HeaderRowGuid
FROM TOUTBOX
WHERE TENANTID  = @TenantId
  AND (@Status  IS NULL OR STATUS = @Status)
ORDER BY CREATEDON DESC
OFFSET @PageOffset ROWS FETCH NEXT @PageSize ROWS ONLY";

        public const string GET_BY_CORRELATION = @"
SELECT
    OUTBOXID        AS OutboxId,
    OBJECTTYPEID    AS ObjectTypeId,
    OBJECTID        AS ObjectId,
    EVENTTYPEID     AS EventTypeId,
    VERSION         AS Version,
    CORRELATIONKEY  AS CorrelationKey,
    USERID          AS UserId,
    TENANTID        AS TenantId,
    STATUS          AS Status,
    CREATEDON       AS CreatedOn,
    PAYLOAD         AS Payload,
    HEADERROWGUID   AS HeaderRowGuid
FROM TOUTBOX
WHERE TENANTID      = @TenantId
  AND CORRELATIONKEY = @CorrelationKey
ORDER BY CREATEDON";
    }
}