USP_DATAFORMTEMPLATE_EDIT_INTERACTION_5

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

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
@EVENTID	uniqueidentifier	IN	Event
@PARTICIPANTS	xml	IN	Participants
@INTERACTIONCATEGORYID	uniqueidentifier	IN	Category
@INTERACTIONSUBCATEGORYID	uniqueidentifier	IN	Subcategory
@SITES	xml	IN	Sites
@EXPECTEDSTARTTIME	UDT_HOURMINUTE	IN	Expected start time
@EXPECTEDENDTIME	UDT_HOURMINUTE	IN	Expected end time
@ISALLDAYEVENT	bit	IN
@TIMEZONEENTRYID	uniqueidentifier	IN	Time zone
@ACTUALSTARTTIME	UDT_HOURMINUTE	IN	Actual start time
@ACTUALENDTIME	UDT_HOURMINUTE	IN	Actual end time

Definition

Copy


CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_INTERACTION_5
(
    @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
) as begin
    set nocount on;

    exec dbo.USP_DATAFORMTEMPLATE_EDIT_INTERACTION_6
        @ID,
        @CHANGEAGENTID,
        @EXPECTEDDATE,
        @ACTUALDATE,
        @FUNDRAISERID,
        @INTERACTIONTYPECODEID,
        @OBJECTIVE,
        @STATUSCODE,
        @COMMENT,
        @EVENTID,
        @PARTICIPANTS,
        @INTERACTIONCATEGORYID,
        @INTERACTIONSUBCATEGORYID,
        @SITES,
        @EXPECTEDSTARTTIME,
        @EXPECTEDENDTIME,
        @ISALLDAYEVENT, 
        @TIMEZONEENTRYID,
        @ACTUALSTARTTIME,
        @ACTUALENDTIME;

    return 0;                        
end