USP_DATAFORMTEMPLATE_ADD_MEMBERSHIP

The save procedure used by the add dataform template "Membership Add Data Form".

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	INOUT	The output parameter indicating the ID of the record added.
@CONSTITUENTID	uniqueidentifier	IN	Input parameter indicating the context ID for the record being added.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@MEMBERSHIPPROGRAMID	uniqueidentifier	IN	Program
@MEMBERSHIPLEVELID	uniqueidentifier	IN	Level
@MEMBERSHIPLEVELTERMID	uniqueidentifier	IN	Term
@MEMBERSHIPTYPECODEID	uniqueidentifier	IN	Type
@STATUSCODE	smallint	IN	Status
@TRANSACTIONDATE	datetime	IN	Transaction date
@NUMBEROFCHILDREN	smallint	IN	No. of children
@COMMENTS	nvarchar(1000)	IN	Comments
@ISGIFT	bit	IN	This membership is a gift
@SENDRENEWALCODE	smallint	IN	Send renewal notice to
@EXPIRATIONDATE	datetime	IN	Expiration date
@MEMBERS	xml	IN	Members
@GIVENBYID	uniqueidentifier	IN	Given by
@AMOUNT	money	IN

Definition

Copy



                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_MEMBERSHIP
                    (
                        @ID uniqueidentifier = null output,
                        @CONSTITUENTID uniqueidentifier,
                        @CHANGEAGENTID uniqueidentifier = null,
                        @MEMBERSHIPPROGRAMID uniqueidentifier = null,
                        @MEMBERSHIPLEVELID uniqueidentifier = null,
                        @MEMBERSHIPLEVELTERMID uniqueidentifier = null,
                        @MEMBERSHIPTYPECODEID uniqueidentifier = null,
                        @STATUSCODE smallint = 0,
                        @TRANSACTIONDATE datetime = null,
                        @NUMBEROFCHILDREN smallint = 0,
                        @COMMENTS nvarchar(1000) = null,
                        @ISGIFT bit = 0,
                        @SENDRENEWALCODE smallint = 1,
                        @EXPIRATIONDATE datetime = null,
                        @MEMBERS xml = null,
                        @GIVENBYID uniqueidentifier = null,
                        @AMOUNT money = null
                    )
                    as
                        begin try
                            exec dbo.USP_MEMBERSHIP_ADD
                                        @ID output,
                                        @CHANGEAGENTID,
                                        @CONSTITUENTID,
                                        @MEMBERSHIPPROGRAMID,
                                        @MEMBERSHIPLEVELID,
                                        @MEMBERSHIPLEVELTERMID,
                                        @MEMBERSHIPTYPECODEID,
                                        @STATUSCODE,
                                        @TRANSACTIONDATE,
                                        @NUMBEROFCHILDREN,
                                        @COMMENTS,
                                        @ISGIFT,
                                        @SENDRENEWALCODE,
                                        @EXPIRATIONDATE,
                                        @MEMBERS,
                                        @GIVENBYID,
                                        null;
                        end try
                        begin catch
                            exec dbo.USP_RAISE_ERROR
                            return 1
                        end catch

                        return 0