USP_DATAFORMTEMPLATE_VIEW_MICROSITE_MODALINFORMATION

The load procedure used by the view dataform template "Web Forms Modal Information"

Parameters

Parameter	Parameter Type	Mode	Description
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@INTEGRATIONURL	nvarchar(255)	INOUT	Integration URL
@CLIENTUSERID	int	INOUT	Client user ID
@TOKEN	uniqueidentifier	INOUT	User token
@TICKETPARTID	int	INOUT	Ticket part ID
@MEMBERSHIPRENEWALPARTID	int	INOUT	Membership renewal part ID
@PAYMENTPARTID	int	INOUT	Payment part ID
@PRIVACYPOLICYPARTID	int	INOUT	Privacy policy part ID
@EMAILPREFERENCESPARTID	int	INOUT	Email preferences part ID
@WEBFORMSUSERREGISTRATIONPARTID	int	INOUT
@ETICKETSPARTID	int	INOUT

Definition

Copy


                CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_MICROSITE_MODALINFORMATION
                (
                    @DATALOADED bit = 0 output,
                    @INTEGRATIONURL nvarchar(255) = null output,
                    @CLIENTUSERID integer = null output,
                    @TOKEN uniqueidentifier = null output,
                    @TICKETPARTID int = null output,
                    @MEMBERSHIPRENEWALPARTID int = null output,
                    @PAYMENTPARTID int = null output,
                    @PRIVACYPOLICYPARTID int = null output,
                    @EMAILPREFERENCESPARTID int = null output,
                    @WEBFORMSUSERREGISTRATIONPARTID int = null output,
                    @ETICKETSPARTID int = null output
                )
                as
                    set nocount on;

                    set @DATALOADED = 1;
                    select @INTEGRATIONURL = dbo.UFN_BBNC_URL();

                    --User autolog credentials
                    set @CLIENTUSERID = 1;
                    set @TOKEN = newid();
                    exec dbo.USP_REGISTER_CMS_AUTOLOG_TOKEN @TOKEN, @CLIENTUSERID, 60; --1 minute window

                    select @TICKETPARTID = PRIMARYKEY 
                    from dbo.PAGEMODELITEM with (nolock)
                    where ARTIFACTID = 'b3ace1e4-01d3-49bb-9f24-6e0e251fcb73' --Tickets

                    select @MEMBERSHIPRENEWALPARTID = PRIMARYKEY 
                    from dbo.PAGEMODELITEM with (nolock) 
                    where ARTIFACTID = 'db6055d8-960b-4392-8819-337ee341a3c6' --Renewal

                    select @PAYMENTPARTID = PRIMARYKEY 
                    from dbo.PAGEMODELITEM with (nolock) 
                    where ARTIFACTID = 'f4f84e8c-12da-43d8-8957-0feff9cedd53' --Payment

                    select @PRIVACYPOLICYPARTID = PRIMARYKEY 
                    from dbo.PAGEMODELITEM with (nolock) 
                    where ARTIFACTID = 'E36952BA-49D0-4494-B77E-2EB671B205E9' --Privacy

                    select @EMAILPREFERENCESPARTID = PRIMARYKEY 
                    from dbo.PAGEMODELITEM with (nolock) 
                    where ARTIFACTID = '229719C4-DDBA-4CFF-B618-FF3993C3EDB8' --Email preference

                    select @WEBFORMSUSERREGISTRATIONPARTID = PRIMARYKEY 
                    from dbo.PAGEMODELITEM with (nolock) 
                    where ARTIFACTID = '7DBA73A4-7718-46D3-A9CE-BD68B3848AD6' --User registration

                    select @ETICKETSPARTID = PRIMARYKEY 
                    from dbo.PAGEMODELITEM with (nolock) 
                    where ARTIFACTID = '4BFC6F3E-7A29-43B7-A731-0A479C09C11B' --eTickets

                return 0;