USP_DATAFORMTEMPLATE_ADD_MEMBERSHIPCARD_PRELOAD

The load procedure used by the edit dataform template "Membership Card Add Data Form"

Parameters

Parameter	Parameter Type	Mode	Description
@MEMBERSHIPID	uniqueidentifier	IN	Input parameter indicating the context ID for the record being added.
@CONSTITUENTID	uniqueidentifier	INOUT	Member
@NAMEONCARD	nvarchar(700)	INOUT	Name on card
@EXPIRATIONDATE	datetime	INOUT	Expires on
@MEMBERSHIPSTATUSCODE	tinyint	INOUT

Definition

Copy



                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_MEMBERSHIPCARD_PRELOAD
                    (
                        @MEMBERSHIPID uniqueidentifier,
                        @CONSTITUENTID uniqueidentifier = null output,
                        @NAMEONCARD nvarchar(700) = null output,
                        @EXPIRATIONDATE datetime = null output,
                        @MEMBERSHIPSTATUSCODE tinyint = null output
                    )
                    as
                        set nocount on;

                        select
                            @CONSTITUENTID = M.CONSTITUENTID,
                            --@NAMEONCARD = dbo.UFN_CONSTITUENT_BUILDNAME(M.CONSTITUENTID),

                            @EXPIRATIONDATE = MS.EXPIRATIONDATE,
                            @MEMBERSHIPSTATUSCODE = MS.STATUSCODE
                        from
                            dbo.MEMBER M
                        inner join
                            dbo.MEMBERSHIP MS
                                on M.MEMBERSHIPID = MS.ID
                        where
                            MS.ID = @MEMBERSHIPID
                            and M.ISPRIMARY = 1

                        return 0;