USP_DATAFORMTEMPLATE_ADDLOAD_DAILYSALESORDER_MANUALDISCOUNT

The load procedure used by the edit dataform template "Daily Sales Order Manual Discount Add Data Form"

Parameters

Parameter	Parameter Type	Mode	Description
@SALESORDERID	uniqueidentifier	IN	Input parameter indicating the context ID for the record being added.
@DISCOUNTS	xml	INOUT
@DISCOUNTSANDPROMOS	xml	INOUT
@BOGODISCOUNTSWITHUNLIMITEDQUANTITY	xml	INOUT

Definition

Copy


CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADDLOAD_DAILYSALESORDER_MANUALDISCOUNT
(
    @SALESORDERID uniqueidentifier,
    @DISCOUNTS xml = null output,
    @DISCOUNTSANDPROMOS xml = null output,
    @BOGODISCOUNTSWITHUNLIMITEDQUANTITY xml = null output
)
as

set nocount on;

set @DISCOUNTS = dbo.UFN_SALESORDER_GETAVAILABLEMANUALDISCOUNTS_TOITEMLISTXML(@SALESORDERID);

if exists (select 1 from dbo.SALESORDER where @SALESORDERID = ID and SALESMETHODTYPECODE = 3)
begin
    set @DISCOUNTSANDPROMOS =
    (
        select [APPLIESTO], [APPLIESTOCODE], [CALCULATIONTYPECODE], [DESCRIPTION], [DISCOUNTTYPECODE], [ID], [MAXVALUE], [MINVALUE], [NAME], [NUMBERTODISCOUNT], [NUMBERTOPURCHASE], [VALUE]
        from dbo.[UFN_SALESORDER_GETAVAILABLEMANUALDISCOUNTSMEMBERSHIPPROMOS](@SALESORDERID)
        where APPLIESTOCODE <> -1
        order by NAME
        for xml raw('ITEM'),type,elements,root('DISCOUNTS'),BINARY BASE64
    )
end
else
    set @DISCOUNTSANDPROMOS = dbo.UFN_SALESORDER_GETAVAILABLEMANUALDISCOUNTSMEMBERSHIPPROMOS_TOITEMLISTXML(@SALESORDERID);

set @BOGODISCOUNTSWITHUNLIMITEDQUANTITY =
(
    select DISCOUNT.ID
    from dbo.DISCOUNT
    where DISCOUNT.DISCOUNTTYPECODE = 1
        and DISCOUNT.NUMBERTODISCOUNTTYPECODE = 1
    order by DISCOUNT.NAME
    for xml raw('ITEM'),type,elements,root('BOGODISCOUNTSWITHUNLIMITEDQUANTITY'),BINARY BASE64
)

return 0;