USP_DATAFORMTEMPLATE_ADD_APPLYTICKETSTOMEMBERSHIP_PRELOAD

The load procedure used by the edit dataform template "Apply Tickets To Membership Add Data Form"

Parameters

Parameter	Parameter Type	Mode	Description
@SALESORDERITEMID	uniqueidentifier	IN	Input parameter indicating the context ID for the record being added.
@SALESORDERID	uniqueidentifier	INOUT	Sales order ID
@SALESORDERITEMMEMBERSHIPITEMPROMOTIONID	uniqueidentifier	INOUT	Sales order item membership item promotion ID
@SOURCESALESORDERID	uniqueidentifier	INOUT	Order number
@TOTALDISCOUNT	money	INOUT	Total amount to apply
@ITEMS	xml	INOUT

Definition

Copy


CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_APPLYTICKETSTOMEMBERSHIP_PRELOAD
(    
    @SALESORDERITEMID uniqueidentifier,
    @SALESORDERID uniqueidentifier = null output,
    @SALESORDERITEMMEMBERSHIPITEMPROMOTIONID uniqueidentifier = null output,
    @SOURCESALESORDERID uniqueidentifier = null output,
    @TOTALDISCOUNT 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
    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;