USP_DATAFORMTEMPLATE_EDIT_INTERACTIONMOVE_2

The save procedure used by the edit dataform template "Interaction Move 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	Contact method
@OBJECTIVE	nvarchar(100)	IN	Summary
@STATUSCODE	tinyint	IN	Status
@COMMENT	nvarchar(max)	IN	Comment
@PARTICIPANTS	xml	IN	Participants
@INTERACTIONCATEGORYID	uniqueidentifier	IN	Category
@INTERACTIONSUBCATEGORYID	uniqueidentifier	IN	Subcategory

Definition

Copy



          CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_INTERACTIONMOVE_2
          (
            @ID uniqueidentifier,
            @CHANGEAGENTID uniqueidentifier = null,
            @EXPECTEDDATE datetime,
            @ACTUALDATE datetime,
            @FUNDRAISERID uniqueidentifier,
            @INTERACTIONTYPECODEID uniqueidentifier,
            @OBJECTIVE nvarchar(100),
            @STATUSCODE tinyint,
            @COMMENT nvarchar(max),
            @PARTICIPANTS xml,
            @INTERACTIONCATEGORYID uniqueidentifier,
            @INTERACTIONSUBCATEGORYID 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,
              INTERACTIONSUBCATEGORYID = @INTERACTIONSUBCATEGORYID
            where
              ID = @ID

            exec dbo.USP_INTERACTION_PARTICIPANTS_UPDATEFROMXML @ID, @PARTICIPANTS, @CHANGEAGENTID;

            return 0;

          end