USP_DATAFORMTEMPLATE_ADD_INTERACTION_2

The save procedure used by the add dataform template "Interaction Add Form 2".

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	INOUT	The output parameter indicating the ID of the record added.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@CONSTITUENTID	uniqueidentifier	IN	Input parameter indicating the context ID for the record being added.
@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
@SELECTEDCONSTITUENTID	uniqueidentifier	IN	Constituent
@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
@LOCATIONID	uniqueidentifier	IN
@OTHERLOCATION	nvarchar(300)	IN

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_INTERACTION_2
(
  @ID uniqueidentifier = null output,
  @CHANGEAGENTID uniqueidentifier = null,
    @CONSTITUENTID uniqueidentifier,
    @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,
  @LOCATIONID uniqueidentifier = null,
  @OTHERLOCATION nvarchar(300) = ''
)
as begin
    set nocount on;

  declare @LOCATION nvarchar(300) = '';

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

    if @CONSTITUENTID = '3b1ac3d7-10a4-4e8e-a11f-eef07c1a7202'
        set @CONSTITUENTID = @SELECTEDCONSTITUENTID;

    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,
      LOCATION
        ) values (
            @ID,
            @CHANGEAGENTID,
            @CHANGEAGENTID,
            @CONSTITUENTID,
            @EXPECTEDDATE,
            @ACTUALDATE,
            @FUNDRAISERID,
            @INTERACTIONTYPECODEID,
            @OBJECTIVE,
            @STATUSCODE,
            @COMMENT,
            @EVENTID,
            @INTERACTIONSUBCATEGORYID,
            @EXPECTEDSTARTTIME,
            @EXPECTEDENDTIME,
            @ISALLDAYEVENT, 
            @TIMEZONEENTRYID,
            @ACTUALSTARTTIME,
            @ACTUALENDTIME,
      @LOCATION
        );

        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;