USP_DATAFORMTEMPLATE_VIEW_MEMBERSHIPBASICCMS

The load procedure used by the view dataform template "Microsite Membership Program View"

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(512)	INOUT	Program name
@URL	nvarchar(max)	INOUT	URL
@ISACTIVE	bit	INOUT	Active
@ISBASICCMS	bit	INOUT	Approved for website
@ISLIVE	bit	INOUT	Live on website
@DESCRIPTION	nvarchar(255)	INOUT	Description
@SITEPAGESID	int	INOUT	Site Page ID

Definition

Copy


            CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_MEMBERSHIPBASICCMS
                (
                    @ID uniqueidentifier,
                    @DATALOADED bit = 0 output,
                    @NAME nvarchar(512) = null output,
                    @URL nvarchar(max) = null output,
                    @ISACTIVE bit = null output, 
                    @ISBASICCMS bit = null output,
                    @ISLIVE bit = null output,
                    @DESCRIPTION nvarchar(255) = null output,
                    @SITEPAGESID int = null output
                )
                as
                begin
                    set nocount on;

                    set @DATALOADED = 0;

                    select
                        @DATALOADED = 1,
                        @NAME = MEMBERSHIPPROGRAM.NAME,
                        @URL = CASE WHEN ISNULL(CAST(MP.SITEPAGESID AS BIT), 0) = 1 THEN dbo.UFN_BBNC_URL() + (SELECT TOP 1 VanityURL from dbo.VanityURL where PageID= MP.SITEPAGESID) ELSE '' END, 
                        @ISACTIVE = MEMBERSHIPPROGRAM.ISACTIVE, 
                        @ISBASICCMS = ISNULL(CAST(MP.SITEPAGESID AS BIT), 0),
                        @ISLIVE = CASE
                            WHEN
                                (ISNULL(CAST(MP.SITEPAGESID AS BIT), 0) = 1)
                                and (MEMBERSHIPPROGRAM.ISACTIVE = 1)
                                --and (((GETDATE() >= MEMBERSHIPPROGRAM.STARTDATE) or (MEMBERSHIPPROGRAM.STARTDATE is null)) and ((GETDATE() <= MEMBERSHIPPROGRAM.ENDDATE) or (MEMBERSHIPPROGRAM.ENDDATE is null)))
                                THEN 1 
                            ELSE 0 END, 
                        @DESCRIPTION = MEMBERSHIPPROGRAM.DESCRIPTION,
                        @SITEPAGESID = MP.SITEPAGESID
                    from dbo.MEMBERSHIPPROGRAM
                    left join dbo.MICROSITEPAGE MP 
                        on (MP.OBJECTID = MEMBERSHIPPROGRAM.ID) and (MP.EXCLUDED = 0)
                    where MEMBERSHIPPROGRAM.ID = @ID;        

                    return 0;
                end