USP_DATAFORMTEMPLATE_ADD_MEMBERSHIP_PRELOAD

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

Parameters

Parameter	Parameter Type	Mode	Description
@MEMBERS	xml	INOUT	Members
@CONSTITUENTID	uniqueidentifier	IN	Input parameter indicating the context ID for the record being added.
@ISADD	bit	INOUT
@GIVENBYID	uniqueidentifier	INOUT	Given by
@TRANSACTIONDATE	datetime	INOUT	Transaction date
@AMOUNT	money	INOUT

Definition

Copy



                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_MEMBERSHIP_PRELOAD
                    (
                        @MEMBERS xml = null output,
                        @CONSTITUENTID uniqueidentifier,
                        @ISADD bit = null output,
                        @GIVENBYID uniqueidentifier = null output,
                        @TRANSACTIONDATE datetime = null output,
                        @AMOUNT money = null output
                    )
                    as
                        set nocount on;

                        set @TRANSACTIONDATE = dbo.UFN_DATE_GETEARLIESTTIME(getdate())

                        declare @ID uniqueidentifier
                        set @ID = newid()

                        declare @CARDID uniqueidentifier;
                        set @CARDID = newid()

                        set @MEMBERS = '<MEMBERS>
                                            <ITEM>
                                                <ID>'+convert(nvarchar(36),@ID)+'</ID>
                                                <CONSTITUENTID>'+convert(nvarchar(36),@CONSTITUENTID)+'</CONSTITUENTID>
                                                <ISPRIMARY>1</ISPRIMARY>
                                                <MEMBERSHIPCARDS>
                                                    <ITEM>
                                                        <ID>'+convert(nvarchar(36),@CARDID)+'</ID>
                                                        <NAMEONCARD>a</NAMEONCARD>
                                                    <EXPIRATIONDATE>'+convert(nvarchar(36),@TRANSACTIONDATE)+'</EXPIRATIONDATE>
                                                    </ITEM>
                                                </MEMBERSHIPCARDS>
                                            </ITEM>
                                    </MEMBERS>';

                        set @ISADD = 0

                        return 0