USP_DATAFORMTEMPLATE_ADD_INTERACTIONWITHOUTCONSTITUENT

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	INOUT
@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
@SELECTEDCONSTITUENTID	uniqueidentifier	IN
@EXPECTEDSTARTTIME	UDT_HOURMINUTE	IN
@EXPECTEDENDTIME	UDT_HOURMINUTE	IN
@ISALLDAYEVENT	bit	IN
@TIMEZONEENTRYID	uniqueidentifier	IN
@ACTUALSTARTTIME	UDT_HOURMINUTE	IN
@ACTUALENDTIME	UDT_HOURMINUTE	IN

Definition

Copy


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

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

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

    begin try
        insert into dbo.INTERACTION (
            ID,
            ADDEDBYID,
            CHANGEDBYID,
            CONSTITUENTID,
            EXPECTEDDATE,
            ACTUALDATE,
            FUNDRAISERID,
            INTERACTIONTYPECODEID,
            OBJECTIVE,
            STATUSCODE,
            COMMENT,
            EVENTID,
            INTERACTIONSUBCATEGORYID,
            EXPECTEDSTARTTIME,
            EXPECTEDENDTIME,
            ISALLDAYEVENT, 
            TIMEZONEENTRYID,
            ACTUALSTARTTIME,
            ACTUALENDTIME
        ) values (
            @ID,
            @CHANGEAGENTID,
            @CHANGEAGENTID,
            @SELECTEDCONSTITUENTID,
            @EXPECTEDDATE,
            @ACTUALDATE,
            @FUNDRAISERID,
            @INTERACTIONTYPECODEID,
            @OBJECTIVE,
            @STATUSCODE,
            @COMMENT,
            @EVENTID,
            @INTERACTIONSUBCATEGORYID,
            @EXPECTEDSTARTTIME,
            @EXPECTEDENDTIME,
            @ISALLDAYEVENT, 
            @TIMEZONEENTRYID,
            @ACTUALSTARTTIME,
            @ACTUALENDTIME
        );

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

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

end;