USP_DATAFORMTEMPLATE_VIEW_MEMBERSHIPLEVELEXPRESSION

The load procedure used by the view dataform template "Membership Level 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.
@NAME	nvarchar(100)	INOUT	Name
@PROGRAMNAME	nvarchar(100)	INOUT	Program name
@PROGRAMID	uniqueidentifier	INOUT	Program ID
@ISACTIVE	bit	INOUT	Is active
@HASGLMAPPING	bit	INOUT	HASGLMAPPING
@MEMBERSALLOWED	smallint	INOUT	Members allowed
@CHILDRENALLOWED	smallint	INOUT	Children allowed
@PROGRAMISBASICCMS	bit	INOUT	Program is Basic CMS
@ISBASICCMS	bit	INOUT	Is Basic CMS
@HASBASICDEVELOPMENT	bit	INOUT
@ISANNUALDUESBASED	bit	INOUT

Definition

Copy


            CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_MEMBERSHIPLEVELEXPRESSION
            (
                @ID uniqueidentifier,
                @DATALOADED bit = 0 output,
                @NAME nvarchar(100) = null output,
                @PROGRAMNAME nvarchar(100) = null output,
                @PROGRAMID uniqueidentifier = null output,
                @ISACTIVE bit = null output,
                @HASGLMAPPING bit = null output,
                @MEMBERSALLOWED smallint = null output,
                @CHILDRENALLOWED smallint = null output,
                @PROGRAMISBASICCMS bit = null output,
                @ISBASICCMS bit = null output,
                @HASBASICDEVELOPMENT bit = null output,
                @ISANNUALDUESBASED bit = null output
            )
            as
                set nocount on;

                set @DATALOADED = 0;

                select 
                    @DATALOADED = 1,
                    @NAME = ML.NAME,
                    @PROGRAMNAME = MP.NAME,
                    @PROGRAMID = MP.ID,
                    @ISACTIVE = ML.ISACTIVE,
                    @MEMBERSALLOWED = ML.MEMBERSALLOWED,
                    @CHILDRENALLOWED = ML.CHILDRENALLOWED,
                    @PROGRAMISBASICCMS = case when [MICROSITEPAGE].[ID] is not null then 1 else 0 end,
                    @ISBASICCMS = case when [MICROSITEMEMBERSHIPLEVEL].[ID] is not null then 1 else 0 end,
                    @ISANNUALDUESBASED = case when (MP.PROGRAMTYPECODE = 0 and MP.PROGRAMBASEDONCODE = 0) then 1 else 0 end
                from 
                    dbo.MEMBERSHIPLEVEL ML
                inner join 
                    dbo.MEMBERSHIPPROGRAM MP
                    on 
                        ML.MEMBERSHIPPROGRAMID = MP.ID
                left join dbo.MICROSITEPAGE 
                    on 
                        (MICROSITEPAGE.OBJECTID = MP.ID) and 
                        (MICROSITEPAGE.EXCLUDED = 0)
                left join dbo.MICROSITEMEMBERSHIPLEVEL
                    on ML.ID = MICROSITEMEMBERSHIPLEVEL.ID
                where ML.ID = @ID

                if exists (select ID from dbo.PDACCOUNTSTRUCTURE where PDACCOUNTTABLESAVAILABLEFORSEGMENTID = '1C2A58EB-40E1-47B7-AE99-B1660A71D7A9')
                    set @HASGLMAPPING = 1;

                if exists(select 1 from dbo.INSTALLEDPRODUCTLIST where ID = '42C15648-749E-4859-A56D-3A6474814CC7')
                    set @HASBASICDEVELOPMENT = 1

                return 0;