USP_DATAFORMTEMPLATE_EDIT_MEMBERSHIPPROGRAMCONTRIBUTIONPROCESS

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN
@NAME	nvarchar(100)	IN
@DESCRIPTION	nvarchar(255)	IN
@MEMBERSHIPPROGRAMID	uniqueidentifier	IN
@PROCESSPROGRAMSCODE	tinyint	IN
@CREATEOUTPUTIDSET	bit	IN
@OUTPUTSELECTIONNAME	nvarchar(100)	IN
@OVERWRITEOUTPUTSELECTION	bit	IN

Definition

Copy


                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_MEMBERSHIPPROGRAMCONTRIBUTIONPROCESS (
                            @ID uniqueidentifier,                        
                            @CHANGEAGENTID uniqueidentifier = null,                        
                            @NAME nvarchar(100), 
                            @DESCRIPTION nvarchar(255),
                            @MEMBERSHIPPROGRAMID uniqueidentifier ,
                            @PROCESSPROGRAMSCODE tinyint,
                            @CREATEOUTPUTIDSET bit ,
                            @OUTPUTSELECTIONNAME nvarchar(100) ,
                            @OVERWRITEOUTPUTSELECTION bit 
                    )
                    as

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

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

                            update
                                dbo.MEMBERSHIPPROGRAMCONTRIBUTIONPROCESS
                            set
                                NAME = @NAME, 
                                DESCRIPTION = @DESCRIPTION, 
                                MEMBERSHIPPROGRAMID = @MEMBERSHIPPROGRAMID,
                                PROCESSPROGRAMSCODE = @PROCESSPROGRAMSCODE,
                                CREATEOUTPUTIDSET = @CREATEOUTPUTIDSET,
                                OUTPUTSELECTIONNAME = @OUTPUTSELECTIONNAME,
                                OVERWRITEOUTPUTSELECTION = @OVERWRITEOUTPUTSELECTION,
                                CHANGEDBYID = @CHANGEAGENTID,
                                DATECHANGED = @CURRENTDATE
                            where
                                ID = @ID;

                        end try

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

                        return 0;