USP_ADD_APPLYTICKETSTOMEMBERSHIP_PRELOAD

Parameters

Parameter	Parameter Type	Mode
@SALESORDERITEMID	uniqueidentifier	IN
@SALESORDERID	uniqueidentifier	INOUT
@SALESORDERITEMMEMBERSHIPITEMPROMOTIONID	uniqueidentifier	INOUT
@SOURCESALESORDERID	uniqueidentifier	INOUT
@TOTALDISCOUNT	money	INOUT
@MEMBERSHIPTOAPPLYPRICE	money	INOUT
@ITEMS	xml	INOUT

Definition

Copy



create procedure dbo.USP_ADD_APPLYTICKETSTOMEMBERSHIP_PRELOAD
(    
    @SALESORDERITEMID uniqueidentifier,
    @SALESORDERID uniqueidentifier = null output,
    @SALESORDERITEMMEMBERSHIPITEMPROMOTIONID uniqueidentifier = null output,
    @SOURCESALESORDERID uniqueidentifier = null output,
    @TOTALDISCOUNT money = null output,
    @MEMBERSHIPTOAPPLYPRICE money = null output,
    @ITEMS xml = null output
)
as
    set nocount on;

    select top 1
        @SALESORDERID = SALESORDERITEM.SALESORDERID,
        @SOURCESALESORDERID = APPLIEDSALESORDERITEM.SALESORDERID,
        @SALESORDERITEMMEMBERSHIPITEMPROMOTIONID = SALESORDERITEMMEMBERSHIPITEMPROMOTION.ID,
        @TOTALDISCOUNT = SALESORDERITEMMEMBERSHIPITEMPROMOTION.AMOUNT,
        @MEMBERSHIPTOAPPLYPRICE = SALESORDERITEM.TOTAL
    from
        dbo.SALESORDERITEM
    left outer join
        dbo.SALESORDERITEMMEMBERSHIPITEMPROMOTION on SALESORDERITEM.ID = SALESORDERITEMMEMBERSHIPITEMPROMOTION.SALESORDERITEMID and SALESORDERITEMMEMBERSHIPITEMPROMOTION.MEMBERSHIPPROMOID is null
    left outer join
        dbo.SALESORDERITEMMEMBERSHIPITEMPROMOTIONAPPLIEDITEM on SALESORDERITEMMEMBERSHIPITEMPROMOTION.ID = SALESORDERITEMMEMBERSHIPITEMPROMOTIONAPPLIEDITEM.SALESORDERITEMMEMBERSHIPITEMPROMOTIONID
    left outer join
        dbo.SALESORDERITEM APPLIEDSALESORDERITEM on SALESORDERITEMMEMBERSHIPITEMPROMOTIONAPPLIEDITEM.APPLIEDSALESORDERITEMID = APPLIEDSALESORDERITEM.ID
    where
        SALESORDERITEM.ID = @SALESORDERITEMID;

    set @ITEMS = dbo.UFN_APPLYTICKETSTOMEMBERSHIP_GETTICKETS_TOITEMLISTXML(@SOURCESALESORDERID);

    return 0;