USP_DATAFORMTEMPLATE_ADD_STANDINGORDEREXPORTPROCESS

The save procedure used by the add dataform template "Standing Orders Export Process Add 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.
@NAME	nvarchar(100)	IN	Process name
@DESCRIPTION	nvarchar(255)	IN	Process description
@IDSETREGISTERID	uniqueidentifier	IN	Selected records
@BUSINESSPROCESSVIEWID	uniqueidentifier	IN	Output format
@UPDATESTANDINGORDERS	bit	IN	Mark exported standing orders as set up

Definition

Copy



                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_STANDINGORDEREXPORTPROCESS
                    (
                        @ID uniqueidentifier = null output,                        
                        @CHANGEAGENTID uniqueidentifier = null,    
                        @CURRENTAPPUSERID uniqueidentifier,
                        @NAME nvarchar(100)='', 
                        @DESCRIPTION nvarchar(255)='',
                        @IDSETREGISTERID uniqueidentifier = null,
                        @BUSINESSPROCESSVIEWID uniqueidentifier = null,
                        @UPDATESTANDINGORDERS bit = 1
                    )
                    as

                    set nocount on;

                    declare @CURRENTDATE datetime;                                        

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

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

                    set @CURRENTDATE = GetDate();

                    begin try
                        insert into dbo.STANDINGORDERSEXPORTPROCESS
                        (
                            ID,
                            NAME,
                            DESCRIPTION,
                            IDSETREGISTERID,
                            BUSINESSPROCESSVIEWID,
                            UPDATESTANDINGORDERS,
                            ADDEDBYID,
                            CHANGEDBYID,
                            DATEADDED,
                            DATECHANGED
                        )
                        values
                        (
                            @ID,
                            @NAME,
                            @DESCRIPTION,
                            @IDSETREGISTERID,
                            @BUSINESSPROCESSVIEWID,
                            @UPDATESTANDINGORDERS,
                            @CHANGEAGENTID,
                            @CHANGEAGENTID,
                            @CURRENTDATE,
                            @CURRENTDATE
                        );

                        exec dbo.USP_BUSINESSPROCESSINSTANCE_ADD @CHANGEAGENTID = 
                            @CHANGEAGENTID, 
                            @BUSINESSPROCESSCATALOGID = 'E55B96E9-7FDA-4B19-AC2C-D38FE75469AF', 
                            @BUSINESSPROCESSPARAMETERSETID = @ID, 
                            @OWNERID = @CURRENTAPPUSERID;

                    end try

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

                    return 0;