USP_DATAFORMTEMPLATE_VIEW_MEMBERSHIPPRINTDATA

The load procedure used by the view dataform template "Membership 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

Definition

Copy


                CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_MEMBERSHIPPRINTDATA
                (
                    @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
                )
                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
                    from
                        dbo.MEMBERSHIP MS
                    inner join
                        dbo.MEMBERSHIPPROGRAM MP
                            on MS.MEMBERSHIPPROGRAMID = MP.ID
                    where
                        MS.ID = @ID;

                    return 0;