USP_DATAFORMTEMPLATE_ADD_INTERACTION_PRELOAD_2

The load procedure used by the edit dataform template "Interaction Add Form 2"

Parameters

Parameter	Parameter Type	Mode	Description
@CONSTITUENTID	uniqueidentifier	IN	Input parameter indicating the context ID for the record being added.
@CONSTITUENTNAME	nvarchar(700)	INOUT	Constituent name
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.
@SITEREQUIRED	bit	INOUT	Site required
@SITES	xml	INOUT	Sites
@FUNDRAISERID	uniqueidentifier	INOUT

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_INTERACTION_PRELOAD_2
(
    @CONSTITUENTID uniqueidentifier,
    @CONSTITUENTNAME nvarchar(700) = null output,
    @CURRENTAPPUSERID uniqueidentifier,
    @SITEREQUIRED bit = null output,
    @SITES xml = null output,
    @FUNDRAISERID uniqueidentifier = null output
)
as 
begin
    set nocount on;

    select
        @CONSTITUENTNAME = NF.NAME
    from
        dbo.UFN_CONSTITUENT_DISPLAYNAME(@CONSTITUENTID) NF

    select
        @FUNDRAISERID = CONSTITUENTID
    from dbo.APPUSER
    where ID = @CURRENTAPPUSERID


    set @SITEREQUIRED = dbo.UFN_SITEREQUIREDFORUSER(@CURRENTAPPUSERID)

    declare @USERSITEID uniqueidentifier = dbo.UFN_APPUSER_DEFAULTSITEFORUSER(@CURRENTAPPUSERID)
    if @USERSITEID is not null
    begin
        set @SITES = (
            select newid() ID, @USERSITEID SITEID
            for xml raw('ITEM'),type,elements,root('SITES'),BINARY BASE64
        )
    end
end