USP_DATAFORMTEMPLATE_EDIT_INTERACTION_7

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN
@EXPECTEDDATE	datetime	IN
@ACTUALDATE	datetime	IN
@FUNDRAISERID	uniqueidentifier	IN
@INTERACTIONTYPECODEID	uniqueidentifier	IN
@OBJECTIVE	nvarchar(100)	IN
@STATUSCODE	tinyint	IN
@COMMENT	nvarchar(max)	IN
@EVENTID	uniqueidentifier	IN
@PARTICIPANTS	xml	IN
@INTERACTIONCATEGORYID	uniqueidentifier	IN
@INTERACTIONSUBCATEGORYID	uniqueidentifier	IN
@SITES	xml	IN
@EXPECTEDSTARTTIME	UDT_HOURMINUTE	IN
@EXPECTEDENDTIME	UDT_HOURMINUTE	IN
@ISALLDAYEVENT	bit	IN
@TIMEZONEENTRYID	uniqueidentifier	IN
@ACTUALSTARTTIME	UDT_HOURMINUTE	IN
@ACTUALENDTIME	UDT_HOURMINUTE	IN
@LOCATIONID	uniqueidentifier	IN
@OTHERLOCATION	nvarchar(300)	IN

Definition

Copy



                    create procedure dbo.USP_DATAFORMTEMPLATE_EDIT_INTERACTION_7
                    (
                        @ID uniqueidentifier,
                        @CHANGEAGENTID uniqueidentifier = null,
                        @EXPECTEDDATE datetime,
                        @ACTUALDATE datetime,
                        @FUNDRAISERID uniqueidentifier,
                        @INTERACTIONTYPECODEID uniqueidentifier,
                        @OBJECTIVE nvarchar(100),
                        @STATUSCODE tinyint,
                        @COMMENT nvarchar(max),
                        @EVENTID uniqueidentifier,
                        @PARTICIPANTS xml,
                        @INTERACTIONCATEGORYID uniqueidentifier,
                        @INTERACTIONSUBCATEGORYID uniqueidentifier,
                        @SITES xml,
                        @EXPECTEDSTARTTIME dbo.UDT_HOURMINUTE,
                        @EXPECTEDENDTIME dbo.UDT_HOURMINUTE,
                        @ISALLDAYEVENT bit, 
                        @TIMEZONEENTRYID uniqueidentifier,
                        @ACTUALSTARTTIME dbo.UDT_HOURMINUTE,
                        @ACTUALENDTIME dbo.UDT_HOURMINUTE,
            @LOCATIONID uniqueidentifier,
            @OTHERLOCATION nvarchar(300)
                    ) as begin
                        set nocount on;

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

            declare @LOCATION nvarchar(300) = '';

            set @LOCATION = dbo.UFN_INTERACTION_GETSINGLELINELOCATION(@LOCATIONID, @OTHERLOCATION);

                        begin try
                            update dbo.INTERACTION set
                                CHANGEDBYID = @CHANGEAGENTID,
                                DATECHANGED = getdate(),
                                EXPECTEDDATE = @EXPECTEDDATE,
                                ACTUALDATE = @ACTUALDATE,
                                FUNDRAISERID = @FUNDRAISERID,
                                INTERACTIONTYPECODEID = @INTERACTIONTYPECODEID,
                                OBJECTIVE = @OBJECTIVE,
                                STATUSCODE = @STATUSCODE,
                                COMMENT = @COMMENT,
                                EVENTID = @EVENTID,
                                INTERACTIONSUBCATEGORYID = @INTERACTIONSUBCATEGORYID,
                                EXPECTEDSTARTTIME = @EXPECTEDSTARTTIME,
                                EXPECTEDENDTIME = @EXPECTEDENDTIME,
                                ISALLDAYEVENT = @ISALLDAYEVENT, 
                                TIMEZONEENTRYID = @TIMEZONEENTRYID,
                                ACTUALSTARTTIME = @ACTUALSTARTTIME,
                                ACTUALENDTIME = @ACTUALENDTIME,
                LOCATION=@LOCATION
                            where
                                ID = @ID;

                            declare @CURRENTDATE datetime;
                            set @CURRENTDATE = getdate();
                            exec dbo.USP_CONSTITUENTINTERACTION_GETSITES_UPDATEFROMXML @ID, @SITES, @CHANGEAGENTID, @CURRENTDATE;

                            exec dbo.USP_INTERACTION_PARTICIPANTS_UPDATEFROMXML @ID, @PARTICIPANTS, @CHANGEAGENTID;
                        end try
                        begin catch
                            exec dbo.USP_RAISE_ERROR;
                            return 1;
                        end catch;

                        return 0;                        
                    end