USP_DATAFORMTEMPLATE_VIEW_EVENTINVITATIONPAGEEXPRESSION

The load procedure used by the view dataform template "Event Invitation Page Expression View Form"

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter used to load the fields defined on the form.
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@INVITATIONID	uniqueidentifier	INOUT	INVITATIONID
@INVITATIONNAME	nvarchar(100)	INOUT	Invitation
@EVENTID	uniqueidentifier	INOUT	EVENTID
@ISMAINEVENT	bit	INOUT	ISMAINEVENT
@HASAPPEAL	bit	INOUT	HASAPPEAL
@EVENTNAME	nvarchar(100)	INOUT	Event
@BUSINESSPROCESSVIEWID	uniqueidentifier	INOUT	BUSINESSPROCESSVIEWID
@OUTPUTFORMAT	nvarchar(255)	INOUT	Output format
@BUSINESSPROCESSCATALOGID	uniqueidentifier	INOUT	BUSINESSPROCESSCATALOGID
@EXPORTPROCESSID	uniqueidentifier	INOUT	EXPORTPROCESSID

Definition

Copy



                CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_EVENTINVITATIONPAGEEXPRESSION
                (
                    @ID uniqueidentifier,
                    @DATALOADED bit = 0 output,
                    @INVITATIONID uniqueidentifier = null output,
                    @INVITATIONNAME nvarchar(100) = null output,
                    @EVENTID uniqueidentifier = null output,
                    @ISMAINEVENT bit = null output,
                    @HASAPPEAL bit = null output,
                    @EVENTNAME nvarchar(100) = null output,
                    @BUSINESSPROCESSVIEWID uniqueidentifier = null output,
                    @OUTPUTFORMAT nvarchar(255) = null output,
                    @BUSINESSPROCESSCATALOGID uniqueidentifier = null output,
                    @EXPORTPROCESSID uniqueidentifier = null output
                )
                as
                    set nocount on;

                    set @DATALOADED = 0;

                    select
                        @DATALOADED = 1,
                        @INVITATIONID = INVITATION.ID,
                        @INVITATIONNAME = INVITATION.NAME,
                        @EVENTID = INVITATION.EVENTID,
                        @ISMAINEVENT = case when exists(select ID from dbo.EVENT SUPPORTINGEVENT where SUPPORTINGEVENT.MAINEVENTID = INVITATION.EVENTID) then 1 else 0 end,
                        @HASAPPEAL = case when (select APPEALID from dbo.EVENT where ID = INVITATION.EVENTID) is not null then 1 else 0 end,
                        @EVENTNAME = dbo.UFN_EVENT_GETNAME(INVITATION.EVENTID),
                        @BUSINESSPROCESSVIEWID = coalesce(INVITATION.BUSINESSPROCESSVIEWID, '00000000-0000-0000-0000-000000000000'),
                        @OUTPUTFORMAT = dbo.UFN_BUSINESSPROCESSVIEW_GETNAME(INVITATION.BUSINESSPROCESSVIEWID),
                        @BUSINESSPROCESSCATALOGID = '116332AF-BB79-4608-9709-4203BD2BA318',
                        @EXPORTPROCESSID = MKTSEGMENTATIONEXPORTPROCESS.ID
                    from
                        dbo.INVITATION
                    left join dbo.MKTSEGMENTATIONEXPORTPROCESS
                        on INVITATION.ID = MKTSEGMENTATIONEXPORTPROCESS.SEGMENTATIONID
                    where
                        INVITATION.ID = @ID;

                    return 0;