USP_DATAFORMTEMPLATE_ADD_DAILYSALESORDERITEMMEMBERSHIP

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	INOUT
@CHANGEAGENTID	uniqueidentifier	IN
@SALESORDERID	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

Definition

Copy


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

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

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

    return 0;