USP_DATAFORMTEMPLATE_ADD_CONSTITUENTGROUPINTERACTION_PRELOAD

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

Parameters

Parameter	Parameter Type	Mode	Description
@GROUPCONSTITUENTID	uniqueidentifier	IN	Input parameter indicating the context ID for the record being added.
@CONSTITUENTNAME	nvarchar(154)	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_CONSTITUENTGROUPINTERACTION_PRELOAD
                    (
                        @GROUPCONSTITUENTID uniqueidentifier,
                        @CONSTITUENTNAME nvarchar(154) = null output,
                        @CURRENTAPPUSERID uniqueidentifier,
                        @SITEREQUIRED bit = null output,
                        @SITES xml = null output,
                        @FUNDRAISERID uniqueidentifier = null output
                    )
                    as 
                    begin
                        set nocount on;

                        select
                            @CONSTITUENTNAME = NAME
                        from dbo.CONSTITUENT
                        where
                            ID = @GROUPCONSTITUENTID;

                        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

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