USP_DATAFORMTEMPLATE_ADD_WORKFLOW_CONFIGURATION_TEST

The save procedure used by the add dataform template "Workflow Configuration Test Add Data Form".

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	INOUT	The output parameter indicating the ID of the record added.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.
@SECONDSTOPAUSE	int	IN	Seconds to pause
@TESTERRORHANDLING	bit	IN	Test error handling
@TESTMESSAGE	nvarchar(max)	IN	Message

Definition

Copy


CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_WORKFLOW_CONFIGURATION_TEST

   @ID uniqueidentifier = null output,
   @CHANGEAGENTID uniqueidentifier = null,
   @CURRENTAPPUSERID uniqueidentifier,   
   @SECONDSTOPAUSE int = 60 ,
   @TESTERRORHANDLING bit = 0,
   @TESTMESSAGE nvarchar(max) = ''


as

set nocount on;


/*  Standard Data Form prelude code */
-------------------------------------------------------------------------------
if @ID is null
    set @ID = newid();

if @CHANGEAGENTID is null  
    exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;

declare @CURRENTDATE datetime;
set @CURRENTDATE = getdate();
------------------------------------------------------------------------------


/* This is the ID from the WorkflowConfigurationTest.Workflow.xml workflow spec. */
------------------------------------------------------------------------------
declare @THISWORKFLOW_CATALOGID uniqueidentifier='63dd6f7e-ea31-4d5d-b5e5-54ba052d7e8c'
------------------------------------------------------------------------------

begin try


  --first, create a row in the BBWORKFLOWINSTANCEINFO table.
  exec dbo.USP_BBWORKFLOW_WORKFLOW_INSTANCE_ADD_STATUS_PENDING 

                @BBWORKFLOWINSTANCEINFOID = @ID, 
                @INITIATEDBY_APPUSERID = @CURRENTAPPUSERID,
                @BBWORKFLOWCATALOGID = @THISWORKFLOW_CATALOGID, 
                @CHANGEAGENTID = @CHANGEAGENTID ;



    -- handle inserting the data for use by the workflow        
    declare @SECONDSTEXT nvarchar(max) = cast(@SECONDSTOPAUSE as nvarchar(max));    
    exec dbo.USP_BBWORKFLOW_WORKFLOWDATAITEM_SETVALUE @ID , 'SECONDSTOPAUSE', @SECONDSTEXT ;


    declare @TESTERRORTEXT nvarchar(max) = cast(@TESTERRORHANDLING as nvarchar(max));    
    exec dbo.USP_BBWORKFLOW_WORKFLOWDATAITEM_SETVALUE @ID , 'TESTERRORHANDLING', @TESTERRORTEXT ;


    exec dbo.USP_BBWORKFLOW_WORKFLOWDATAITEM_SETVALUE @ID , 'TESTMESSAGE', @TESTMESSAGE ;


    -- Send a message to the workflow server to start the workflow
    exec dbo.USP_BBWORKFLOW_SERVICE_SENDMESSAGE_STARTWORKFLOW @ID, @CHANGEAGENTID,  @CURRENTAPPUSERID ;



end try

begin catch
    exec dbo.USP_RAISE_ERROR;
    return 3;
end catch

return 0;