USP_DATAFORMTEMPLATE_EDIT_STEWARDSHIPPACKAGEPREPROCESS

The save procedure used by the edit dataform template "Stewardship Package Preprocess Edit Form".

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter indicating the ID of the record being edited.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@WORDTEMPLATEFILENAME	nvarchar(255)	IN	Word template
@WORDFILE	varbinary	IN	File
@BUSINESSPROCESSVIEWID	uniqueidentifier	IN	Output format
@CREATEOUTPUTIDSET	bit	IN	Create selection from results
@OUTPUTIDSETNAME	nvarchar(100)	IN	Selection name
@OVERWRITEOUTPUTIDSET	bit	IN	Overwrite existing selection
@CUSTOMPARAMETERDATAFORMITEM	xml	IN
@FILECHANGED	bit	IN	File changed?

Definition

Copy



                CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_STEWARDSHIPPACKAGEPREPROCESS
                (
                    @ID uniqueidentifier,
                    @CHANGEAGENTID uniqueidentifier = null,
                    @WORDTEMPLATEFILENAME nvarchar(255),
                    @WORDFILE varbinary(max),
                    @BUSINESSPROCESSVIEWID uniqueidentifier,
                    @CREATEOUTPUTIDSET bit,
                    @OUTPUTIDSETNAME nvarchar(100),                        
                    @OVERWRITEOUTPUTIDSET bit,
                    @CUSTOMPARAMETERDATAFORMITEM xml,
                    @FILECHANGED bit                                          
                )
                as                
                set nocount on;

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

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

                if @FILECHANGED = 1
                    update
                        dbo.STEWARDSHIPPACKAGEPROCESS
                    set
                        WORDTEMPLATEFILENAME = @WORDTEMPLATEFILENAME,
                        WORDFILE = @WORDFILE,
                        BUSINESSPROCESSVIEWID = @BUSINESSPROCESSVIEWID,
                        CREATEOUTPUTIDSET = @CREATEOUTPUTIDSET,
                        OUTPUTIDSETNAME = @OUTPUTIDSETNAME,
                        OVERWRITEOUTPUTIDSET = @OVERWRITEOUTPUTIDSET,
                        CUSTOMPARAMETERDATAFORMITEM = @CUSTOMPARAMETERDATAFORMITEM,
                        CHANGEDBYID = @CHANGEAGENTID,
                        DATECHANGED = @CURRENTDATE
                    where
                        ID = @ID;

                else
                    update
                        dbo.STEWARDSHIPPACKAGEPROCESS
                    set
                        WORDTEMPLATEFILENAME = @WORDTEMPLATEFILENAME,
                        BUSINESSPROCESSVIEWID = @BUSINESSPROCESSVIEWID,
                        CREATEOUTPUTIDSET = @CREATEOUTPUTIDSET,
                        OUTPUTIDSETNAME = @OUTPUTIDSETNAME,
                        OVERWRITEOUTPUTIDSET = @OVERWRITEOUTPUTIDSET,
                        CUSTOMPARAMETERDATAFORMITEM = @CUSTOMPARAMETERDATAFORMITEM,
                        CHANGEDBYID = @CHANGEAGENTID,
                        DATECHANGED = @CURRENTDATE
                    where
                        ID = @ID;                                                                                    
                end try

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

                return 0;