USP_SIMPLEDATALIST_MEMBERSHIPPROGRAM

Returns all membership programs.

Parameters

Parameter	Parameter Type	Mode	Description
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.
@INCLUDEINACTIVE	bit	IN	INCLUDEINACTIVE
@SECURITYFEATUREID	uniqueidentifier	IN
@SECURITYFEATURETYPE	tinyint	IN
@BASECURRENCYID	uniqueidentifier	IN
@EXCEPTPROGRAMBASEDONCODE	tinyint	IN

Definition

Copy



                CREATE procedure dbo.USP_SIMPLEDATALIST_MEMBERSHIPPROGRAM
                (
                    @CURRENTAPPUSERID uniqueidentifier,
                    @INCLUDEINACTIVE bit = 0,
                    @SECURITYFEATUREID uniqueidentifier = null,
                    @SECURITYFEATURETYPE tinyint = null,
          @BASECURRENCYID uniqueidentifier = null,
          @EXCEPTPROGRAMBASEDONCODE tinyint = null
                )
                as
                    select 
                        MEMBERSHIPPROGRAM.ID as VALUE, 
                        MEMBERSHIPPROGRAM.NAME as LABEL
                    from 
                        dbo.MEMBERSHIPPROGRAM
                    where
                        (@INCLUDEINACTIVE = 1 or MEMBERSHIPPROGRAM.ISACTIVE = 1)
            and (@BASECURRENCYID = MEMBERSHIPPROGRAM.BASECURRENCYID or @BASECURRENCYID is null)
            and (@EXCEPTPROGRAMBASEDONCODE != MEMBERSHIPPROGRAM.PROGRAMBASEDONCODE or @EXCEPTPROGRAMBASEDONCODE is null)
                        and (dbo.UFN_APPUSER_ISSYSADMIN(@CURRENTAPPUSERID) = 1 or exists (select 1 from dbo.UFN_SITESFORUSERONFEATURE(@CURRENTAPPUSERID,@SECURITYFEATUREID,@SECURITYFEATURETYPE) where SITEID=[MEMBERSHIPPROGRAM].[SITEID] or (SITEID is null and [MEMBERSHIPPROGRAM].[SITEID] is null)))
                    order by LABEL