USP_DATAFORMTEMPLATE_VIEW_PRINTMEMBERSHIPCARDSPROCESS

The load procedure used by the view dataform template "Print Membership Cards 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
@DESCRIPTION	nvarchar(255)	INOUT	Description
@MEMBERSHIPPROGRAM	nvarchar(100)	INOUT	Membership program
@INCLUDESELECTION	nvarchar(100)	INOUT	Include selection
@CARDFORMAT	nvarchar(255)	INOUT	Card format
@CREATEOUTPUTIDSET	nvarchar(3)	INOUT	Create output selection
@OVERWRITEOUTPUTIDSET	nvarchar(3)	INOUT	Overwrite existing selection
@OUTPUTIDSETNAME	nvarchar(100)	INOUT	Output selection name
@PARAMETERSID	uniqueidentifier	INOUT	PARAMETERSID
@LIMITTO	int	INOUT	LIMITTO

Definition

Copy



                CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_PRINTMEMBERSHIPCARDSPROCESS
                (
                    @ID uniqueidentifier,
                    @DATALOADED bit = 0 output,
                    @NAME nvarchar(100) = null output,
                    @DESCRIPTION nvarchar(255) = null output,
                    @MEMBERSHIPPROGRAM nvarchar(100) = null output,
                    @INCLUDESELECTION nvarchar(100) = null output,
                    @CARDFORMAT nvarchar(255) = null output,
                    @CREATEOUTPUTIDSET nvarchar(3) = null output,
                    @OVERWRITEOUTPUTIDSET nvarchar(3) = null output,
                    @OUTPUTIDSETNAME nvarchar(100) = null output,
                    @PARAMETERSID uniqueidentifier = null output,
                    @LIMITTO integer = null output
                )
                as
                    set nocount on;

                    set @DATALOADED = 0;

                    select
                        @DATALOADED = 1,
                        @NAME = NAME,
                        @DESCRIPTION = DESCRIPTION,
                        @MEMBERSHIPPROGRAM = dbo.UFN_MEMBERSHIPPROGRAM_GETNAME(MEMBERSHIPPROGRAMID),
                        @INCLUDESELECTION = 
                            case
                                when MEMBERSHIPLEVELID is not null then
                                    dbo.UFN_MEMBERSHIPLEVEL_GETNAME(MEMBERSHIPLEVELID)
                                when IDSETREGISTERID is not null then
                                    dbo.UFN_IDSET_GETNAME(IDSETREGISTERID)
                                else
                                    ''
                            end,
                        @CARDFORMAT = 
                            case
                                when LETTERTEMPLATEID is null then MEMBERSHIPCARDFORMAT
                                else dbo.UFN_LETTERTEMPLATE_GETNAME(LETTERTEMPLATEID)
                            end,
                        @CREATEOUTPUTIDSET =
                            case CREATEOUTPUTIDSET
                                when 0 then
                                    'No'
                                else
                                    'Yes'
                            end,
                        @OVERWRITEOUTPUTIDSET =
                            case OVERWRITEOUTPUTIDSET
                                when 0 then
                                    'No'
                                else
                                    'Yes'
                            end,
                        @OUTPUTIDSETNAME = OUTPUTIDSETNAME,
                        @PARAMETERSID = @ID,
                        @LIMITTO = [LIMITTO]
                    from
                        dbo.PRINTMEMBERSHIPCARDSPROCESS
                    where
                        ID = @ID

                    return 0;