USP_QUEUEPROCESS_ADD

Adds a queue business process to the database.

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	INOUT
@NAME	nvarchar(255)	IN
@DESCRIPTION	nvarchar(1000)	IN
@STEPLISTXML	xml	IN
@CHANGEAGENTID	uniqueidentifier	IN
@CURRENTAPPUSERID	uniqueidentifier	IN

Definition

Copy



      CREATE procedure dbo.USP_QUEUEPROCESS_ADD
      (
        @ID uniqueidentifier = null output,
          @NAME nvarchar(255),
          @DESCRIPTION nvarchar(1000),
          @STEPLISTXML xml,
          @CHANGEAGENTID uniqueidentifier,
        @CURRENTAPPUSERID uniqueidentifier
      )
      as begin
          set nocount on;

          if @ID is null set @ID = newid();

        declare @GRANTED bit;

        -- BTR CR291118-010908 1/28/2008

        -- check to make sure the user has rights to all of the business process parameter sets

        -- used by the steps

        if dbo.[UFN_APPUSER_ISSYSADMIN](@CURRENTAPPUSERID) = 1
          set @GRANTED = 1
        else
          exec dbo.[USP_QUEUEPROCESS_APPUSER_GRANTED_ALL_STEPS] @CURRENTAPPUSERID, @STEPLISTXML, @GRANTED output;

        if @GRANTED = 1
            insert into dbo.QUEUEPROCESS 
          (
            ID, 
                NAME, 
                DESCRIPTION, 
                STEPLISTXML, 
                ADDEDBYID, 
                CHANGEDBYID, 
                DATEADDED, 
                DATECHANGED
          )
            values 
          (
            @ID, 
                @NAME, 
                @DESCRIPTION, 
                @STEPLISTXML, 
                @CHANGEAGENTID, 
                @CHANGEAGENTID, 
                getdate(), 
                getdate()
          )
        else
          raiserror('The current user does not have rights to one or more of the business process parameter sets used in the queue.', 13, 1)

      end;