USP_DATAFORMTEMPLATE_EDIT_SALESORDERITEMMEMBERSHIP_2

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter indicating the ID of the record being edited.
@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
@MEMBERSHIPLEVELTYPECODEID	uniqueidentifier	IN	Type
@NUMBEROFCHILDREN	smallint	IN	No. of children
@COMMENTS	nvarchar(1000)	IN	Comments
@ISGIFT	bit	IN	This membership is a gift
@SENDRENEWALCODE	tinyint	IN	Send renewal notice to
@EXPIRATIONDATE	datetime	IN	Expiration date
@MEMBERS	xml	IN	Members
@GIVENBYID	uniqueidentifier	IN	Given by
@NUMBEROFADDONADULTS	smallint	IN	Number of additional members purchased
@NUMBEROFADDONGUESTS	smallint	IN	Number of guests purchased

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_SALESORDERITEMMEMBERSHIP_2 (
                        @ID uniqueidentifier,
                        @CHANGEAGENTID uniqueidentifier = null,
                        @MEMBERSHIPPROGRAMID uniqueidentifier,
                        @MEMBERSHIPLEVELID uniqueidentifier,
                        @MEMBERSHIPLEVELTERMID uniqueidentifier,
                        @MEMBERSHIPLEVELTYPECODEID uniqueidentifier,
                        @NUMBEROFCHILDREN smallint,
                        @COMMENTS nvarchar(1000),
                        @ISGIFT bit,
                        @SENDRENEWALCODE tinyint,
                        @EXPIRATIONDATE datetime,
                        @MEMBERS xml,
                        @GIVENBYID uniqueidentifier,
                        @NUMBEROFADDONADULTS smallint,
                        @NUMBEROFADDONGUESTS smallint)
as
begin
    set nocount on;

    declare @ISMIDTERMUPGRADE bit;
    declare @MIDTERMUPGRADEPRICE money;

    exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_SALESORDERITEMMEMBERSHIP
        @ID = @ID,
        @ISMIDTERMUPGRADE = @ISMIDTERMUPGRADE output,
        @MIDTERMUPGRADEPRICE = @MIDTERMUPGRADEPRICE output;

   exec dbo.USP_DATAFORMTEMPLATE_EDIT_SALESORDERITEMMEMBERSHIP_3
        @ID,
        @CHANGEAGENTID,
        @MEMBERSHIPPROGRAMID,
        @MEMBERSHIPLEVELID,
        @MEMBERSHIPLEVELTERMID,
        @MEMBERSHIPLEVELTYPECODEID,
        @NUMBEROFCHILDREN,
        @COMMENTS,
        @ISGIFT,
        @SENDRENEWALCODE,
        @EXPIRATIONDATE,
        @MEMBERS,
        @GIVENBYID,
        @NUMBEROFADDONADULTS,
        @NUMBEROFADDONGUESTS,
        @ISMIDTERMUPGRADE,
        @MIDTERMUPGRADEPRICE;

   return 0;

end