USP_DATAFORMTEMPLATE_VIEW_MEMBERSHIPCARDPRINTDATA

The load procedure used by the view dataform template "Membership Card Print Data 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.
@PRINTMEMBERSHIPCARDSPROCESSID	uniqueidentifier	INOUT	PRINTMEMBERSHIPCARDSPROCESSID
@MEMBERSHIPPROGRAMID	uniqueidentifier	INOUT	MEMBERSHIPPROGRAMID
@MEMBERSHIPCARDFORMAT	nvarchar(255)	INOUT	MEMBERSHIPCARDFORMAT
@REPORTCATALOGID	uniqueidentifier	INOUT	REPORTCATALOGID
@LETTERTEMPLATEID	uniqueidentifier	INOUT	LETTERTEMPLATEID
@MEMBERSHIPEXPIRED	bit	INOUT

Definition

Copy


                CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_MEMBERSHIPCARDPRINTDATA
                (
                    @ID uniqueidentifier,
                    @DATALOADED bit = 0 output,
                    @PRINTMEMBERSHIPCARDSPROCESSID uniqueidentifier = null output,
                    @MEMBERSHIPPROGRAMID uniqueidentifier = null output,
                    @MEMBERSHIPCARDFORMAT nvarchar(255) = null output,
                    @REPORTCATALOGID uniqueidentifier = null output,
                    @LETTERTEMPLATEID uniqueidentifier = null output,
                    @MEMBERSHIPEXPIRED bit = null output
                )
                as
                    set nocount on;

                    set @DATALOADED = 0;

                    select @PRINTMEMBERSHIPCARDSPROCESSID = ID from dbo.PRINTMEMBERSHIPCARDSPROCESS where NAME = 'Default Parameter Set for Membership Card Printing';

                    select
                        @DATALOADED = 1,
                        @MEMBERSHIPPROGRAMID = MP.ID,
                        @MEMBERSHIPCARDFORMAT = MP.CARDFORMAT,
                        @REPORTCATALOGID = MP.REPORTCATALOGID,
                        @LETTERTEMPLATEID = MP.LETTERTEMPLATEID,
                        @MEMBERSHIPEXPIRED = case 
                                                when (MS.EXPIRATIONDATE > getdate() or MS.EXPIRATIONDATE is null) then 0
                                                else 1
                                             end
                    from
                        dbo.MEMBERSHIPCARD MC
                    inner join
                        dbo.MEMBER M
                            on MC.MEMBERID = M.ID
                    inner join
                        dbo.MEMBERSHIP MS
                            on M.MEMBERSHIPID = MS.ID
                    inner join
                        dbo.MEMBERSHIPPROGRAM MP
                            on MS.MEMBERSHIPPROGRAMID = MP.ID
                    where
                        MC.ID = @ID;

                    return 0;