UFN_MERCHANTACCOUNT_USERHASSITEACCESS

Validates that an application user has access to a merchant account based on site permissions.

Return

Return Type
bit

Parameters

Parameter	Parameter Type	Mode
@MERCHANTACCOUNTID	uniqueidentifier	IN
@CURRENTAPPUSERID	uniqueidentifier	IN
@SECURITYFEATUREID	uniqueidentifier	IN
@SECURITYFEATURETYPE	tinyint	IN

Definition

Copy



            CREATE function dbo.UFN_MERCHANTACCOUNT_USERHASSITEACCESS
            (
                @MERCHANTACCOUNTID uniqueidentifier,
                @CURRENTAPPUSERID uniqueidentifier,
                @SECURITYFEATUREID uniqueidentifier = null,
                @SECURITYFEATURETYPE tinyint = null
            )
            returns bit
            as
            begin

                if exists
                (
                            select MERCHANTACCOUNT.ID
                            from 
                            dbo.MERCHANTACCOUNT
                            left join dbo.MERCHANTACCOUNTSITE 
                                on MERCHANTACCOUNTSITE.MERCHANTACCOUNTID = MERCHANTACCOUNT.ID
                            inner join dbo.UFN_SITESFORUSERONFEATURE(@CURRENTAPPUSERID, @SECURITYFEATUREID, @SECURITYFEATURETYPE) SITES
                                on (SITES.SITEID = MERCHANTACCOUNTSITE.SITEID) or (SITES.SITEID is null and MERCHANTACCOUNTSITE.SITEID is null)
                            where
                                MERCHANTACCOUNT.ID = @MERCHANTACCOUNTID
                )
                    return 1;
                if not exists
                (
                    select 1 from dbo.MERCHANTACCOUNT where MERCHANTACCOUNT.ID = @MERCHANTACCOUNTID
                )
                    return 1;

                return 0;
            end