USP_DATAFORMTEMPLATE_EDIT_INTERACTION_2

The save procedure used by the edit dataform template "Interaction Edit Form 2".

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.
@EXPECTEDDATE	datetime	IN	Expected date
@ACTUALDATE	datetime	IN	Actual date
@FUNDRAISERID	uniqueidentifier	IN	Owner
@INTERACTIONTYPECODEID	uniqueidentifier	IN	Type
@OBJECTIVE	nvarchar(100)	IN	Summary
@STATUSCODE	tinyint	IN	Status
@COMMENT	nvarchar(max)	IN	Comment
@EVENTID	uniqueidentifier	IN	Event

Definition

Copy



                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_INTERACTION_2
                    (
                        @ID uniqueidentifier,
                        @CHANGEAGENTID uniqueidentifier = null,
                        @EXPECTEDDATE datetime,
                        @ACTUALDATE datetime,
                        @FUNDRAISERID uniqueidentifier,
                        @INTERACTIONTYPECODEID uniqueidentifier,
                        @OBJECTIVE nvarchar(100),
                        @STATUSCODE tinyint,
                        @COMMENT nvarchar(max),
                        @EVENTID uniqueidentifier
                    ) as begin
                        set nocount on;

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

                        update dbo.INTERACTION set
                            CHANGEDBYID = @CHANGEAGENTID,
                            DATECHANGED = getdate(),
                            EXPECTEDDATE = @EXPECTEDDATE,
                            ACTUALDATE = @ACTUALDATE,
                            FUNDRAISERID = @FUNDRAISERID,
                            INTERACTIONTYPECODEID = @INTERACTIONTYPECODEID,
                            OBJECTIVE = @OBJECTIVE,
                            STATUSCODE = @STATUSCODE,
                            COMMENT = @COMMENT,
                            EVENTID = @EVENTID
                        where
                            ID = @ID

                        return 0;

                    end