USP_DATAFORMTEMPLATE_ADD_VOLUNTEERSCREENPLANSTEP

The save procedure used by the add dataform template "Volunteer Screening Plan Step 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.
@VOLUNTEERSCREENPLANID	uniqueidentifier	IN	Input parameter indicating the context ID for the record being added.
@STEPCODEID	uniqueidentifier	IN	Action
@STATUSCODE	tinyint	IN	Status
@DUEDATE	datetime	IN	Due date
@DATECOMPLETE	datetime	IN	Completed on
@COMMENTS	nvarchar(max)	IN	Comments

Definition

Copy



                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_VOLUNTEERSCREENPLANSTEP
                    (
                        @ID uniqueidentifier = null output,
                        @CHANGEAGENTID uniqueidentifier = null,    
                        @VOLUNTEERSCREENPLANID uniqueidentifier,
                        @STEPCODEID uniqueidentifier,
                        @STATUSCODE tinyint = 0,
                        @DUEDATE datetime,
                        @DATECOMPLETE datetime = null,
                        @COMMENTS nvarchar(max) = ''
                    )
                    as
                        set nocount on;

                        declare @CURRENTDATE datetime;
                        declare @SEQUENCE integer;

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

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

                            set @CURRENTDATE = getdate();

                            select @SEQUENCE = coalesce(max(SEQUENCE), 0) + 1
                            from dbo.VOLUNTEERSCREENPLANSTEP
                            where SCREENPLANID = @VOLUNTEERSCREENPLANID

                            insert into dbo.[VOLUNTEERSCREENPLANSTEP] (
                                [ID],
                                [SCREENPLANID],
                                [STEPCODEID],
                                [STATUSCODE],
                                [DUEDATE],
                                [DATECOMPLETE],
                                [COMMENTS],
                                [SEQUENCE],
                                [ADDEDBYID],
                                [CHANGEDBYID],
                                [DATEADDED],
                                [DATECHANGED]
                            ) values (
                                @ID,
                                @VOLUNTEERSCREENPLANID,
                                @STEPCODEID,
                                @STATUSCODE,
                                @DUEDATE,
                                @DATECOMPLETE,
                                @COMMENTS,
                                @SEQUENCE,
                                @CHANGEAGENTID,
                                @CHANGEAGENTID,
                                @CURRENTDATE,
                                @CURRENTDATE
                            );

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

                        return 0;