UFN_EVENTREGISTRANTPAYMENT_USERHASSITEACCESS

Returns 1 is the given user has access to the site for the event the given payment was used to register for.

Return

Return Type
bit

Parameters

Parameter	Parameter Type	Mode	Description
@PAYMENTID	uniqueidentifier	IN
@CURRENTAPPUSERID	uniqueidentifier	IN

Definition

Copy



            CREATE function dbo.UFN_EVENTREGISTRANTPAYMENT_USERHASSITEACCESS
            (
                @PAYMENTID uniqueidentifier,
                @CURRENTAPPUSERID uniqueidentifier
            )
            returns bit
            as
            begin

                declare @SITEGRANTED bit                 
                set @SITEGRANTED = 0

                if exists(select EVENT.ID from dbo.EVENT left join dbo.EVENTSITE on EVENTSITE.EVENTID = EVENT.ID where dbo.UFN_SITEALLOWEDFORUSER(@CURRENTAPPUSERID, EVENTSITE.SITEID) = 1) begin
                    set @SITEGRANTED = 1
                end                

                return @SITEGRANTED
            end