USP_DATAFORMTEMPLATE_EDIT_DAILYSALESORDERITEMMEMBERSHIP

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN
@MEMBERSHIPID	uniqueidentifier	IN
@MEMBERSHIPPROGRAMID	uniqueidentifier	IN
@MEMBERSHIPLEVELID	uniqueidentifier	IN
@MEMBERSHIPLEVELTERMID	uniqueidentifier	IN
@MEMBERSHIPLEVELTYPECODEID	uniqueidentifier	IN
@COMMENTS	nvarchar(1000)	IN
@ISGIFT	bit	IN
@SENDRENEWALCODE	tinyint	IN
@EXPIRATIONDATE	datetime	IN
@MEMBERS	xml	IN
@MEMBERSHIPCARDS	xml	IN
@MEMBERSHIPPROGRAMADDON	xml	IN
@GIVENBYID	uniqueidentifier	IN
@STATUSCODE	tinyint	IN
@NUMBEROFCHILDREN	tinyint	IN
@PRICE	money	IN
@HASADDONS	bit	IN
@TOTALADDITIONALMEMBERS	tinyint	IN
@MIDTERMUPGRADEPRICE	money	IN

Definition

Copy


CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_DAILYSALESORDERITEMMEMBERSHIP(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null,
    @MEMBERSHIPID uniqueidentifier,
    @MEMBERSHIPPROGRAMID uniqueidentifier,
    @MEMBERSHIPLEVELID uniqueidentifier,
    @MEMBERSHIPLEVELTERMID uniqueidentifier,
    @MEMBERSHIPLEVELTYPECODEID uniqueidentifier,    
    @COMMENTS nvarchar(1000),
    @ISGIFT bit,
    @SENDRENEWALCODE tinyint,
    @EXPIRATIONDATE datetime,
    @MEMBERS xml,
    @MEMBERSHIPCARDS xml,
    @MEMBERSHIPPROGRAMADDON xml,
    @GIVENBYID uniqueidentifier,
    @STATUSCODE tinyint,
    @NUMBEROFCHILDREN tinyint,
    @PRICE money,
    @HASADDONS bit,
    @TOTALADDITIONALMEMBERS tinyint,
    @MIDTERMUPGRADEPRICE money
)
as
    set nocount on;

    begin try
        exec dbo.USP_SALESORDERITEMMEMBERSHIP_ADD2
            @ID output,
            @CHANGEAGENTID,
            null,
            @MEMBERSHIPID,
            @MEMBERSHIPPROGRAMID,
            @MEMBERSHIPLEVELID,
            @MEMBERSHIPLEVELTERMID,
            @MEMBERSHIPLEVELTYPECODEID,
            @NUMBEROFCHILDREN,
            @COMMENTS,
            @ISGIFT,
            @SENDRENEWALCODE,
            @EXPIRATIONDATE,
            @MEMBERS,
            @MEMBERSHIPCARDS,
            @MEMBERSHIPPROGRAMADDON,
            @GIVENBYID,
            1,
            @PRICE,
            1,
            @TOTALADDITIONALMEMBERS;
    end try

    begin catch
        exec dbo.USP_RAISE_ERROR;
        return 1;
    end catch

    return 0;