USP_DATAFORMTEMPLATE_EDIT_DISCOUNTDETAIL

Edit save for the discount detail form.

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter indicating the ID of the record being edited.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@NUMBERTOPURCHASE	int	IN	Quantity at full price
@NUMBERTODISCOUNTTYPECODE	tinyint	IN	Quantity discounted
@NUMBERTODISCOUNT	int	IN	Number to discount
@CALCULATIONTYPECODE	tinyint	IN	Type
@DISCOUNTTICKETSFORCODE	tinyint	IN	Limit discount to
@LIMITDISCOUNTSPERORDER	bit	IN	Limit the number of times this discount may be applied
@NUMBEROFDISCOUNTSPERORDER	int	IN	Uses allowed
@DISCOUNTQUALIFYINGPRICETYPES	xml	IN	Buy these price types
@DISCOUNTPRICETYPES	xml	IN	Apply discounts to these price types

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_DISCOUNTDETAIL
(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null,
    @NUMBERTOPURCHASE int,                    
    @NUMBERTODISCOUNTTYPECODE tinyint,
    @NUMBERTODISCOUNT int,
    @CALCULATIONTYPECODE tinyint,
    @DISCOUNTTICKETSFORCODE tinyint,
    @LIMITDISCOUNTSPERORDER bit,
    @NUMBEROFDISCOUNTSPERORDER int,                    
    @DISCOUNTQUALIFYINGPRICETYPES xml,
    @DISCOUNTPRICETYPES xml
)
as
    set nocount on;


    declare @DISCOUNTMERCHANDISEDEPARTMENTS xml
    declare @DISCOUNTMERCHANDISEITEMS xml
    declare @ITEMMERCHANDISEPERCENT decimal(5, 2)
    declare @ITEMMERCHANDISEAMOUNT money
    declare @QUALIFYINGDISCOUNTMERCHANDISEDEPARTMENTS xml
    declare @QUALIFYINGDISCOUNTMERCHANDISEITEMS xml
    declare @QUALIFYINGITEMTYPECODE tinyint
    declare @DISCOUNTITEMTYPECODE tinyint
    declare @DISCOUNTMERCHANDISEFORCODE tinyint
    declare @APPLIESTOMERCHANDISECODE tinyint
    declare @QUALIFYINGAPPLIESTOMERCHANDISECODE tinyint
    declare @DISCOUNTPROGRAMS xml

    exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_DISCOUNTDETAIL
        @ID = @ID,
        @DISCOUNTMERCHANDISEDEPARTMENTS = @DISCOUNTMERCHANDISEDEPARTMENTS output,
        @DISCOUNTMERCHANDISEITEMS = @DISCOUNTMERCHANDISEITEMS output,
        @ITEMMERCHANDISEPERCENT = @ITEMMERCHANDISEPERCENT,
        @ITEMMERCHANDISEAMOUNT = @ITEMMERCHANDISEAMOUNT,
        @QUALIFYINGDISCOUNTMERCHANDISEDEPARTMENTS = @QUALIFYINGDISCOUNTMERCHANDISEDEPARTMENTS,
        @QUALIFYINGDISCOUNTMERCHANDISEITEMS = @QUALIFYINGDISCOUNTMERCHANDISEITEMS,
        @QUALIFYINGITEMTYPECODE = @QUALIFYINGITEMTYPECODE,
        @DISCOUNTITEMTYPECODE = @DISCOUNTITEMTYPECODE,
        @DISCOUNTMERCHANDISEFORCODE = @DISCOUNTMERCHANDISEFORCODE,
        @APPLIESTOMERCHANDISECODE = @APPLIESTOMERCHANDISECODE,
        @QUALIFYINGAPPLIESTOMERCHANDISECODE = @QUALIFYINGAPPLIESTOMERCHANDISECODE,
        @DISCOUNTPROGRAMS = @DISCOUNTPROGRAMS

    exec dbo.USP_DATAFORMTEMPLATE_EDIT_DISCOUNTDETAIL_2
        @ID,
        @CHANGEAGENTID,
        @NUMBERTOPURCHASE,                    
        @NUMBERTODISCOUNTTYPECODE,
        @NUMBERTODISCOUNT,
        @CALCULATIONTYPECODE,
        @DISCOUNTTICKETSFORCODE,
        @LIMITDISCOUNTSPERORDER,
        @NUMBEROFDISCOUNTSPERORDER,                    
        @DISCOUNTQUALIFYINGPRICETYPES,
        @DISCOUNTPRICETYPES,
        @DISCOUNTMERCHANDISEDEPARTMENTS,
        @DISCOUNTMERCHANDISEITEMS,
        @ITEMMERCHANDISEPERCENT,
        @ITEMMERCHANDISEAMOUNT,
        @QUALIFYINGDISCOUNTMERCHANDISEDEPARTMENTS,
        @QUALIFYINGDISCOUNTMERCHANDISEITEMS,
        @QUALIFYINGITEMTYPECODE,
        @DISCOUNTITEMTYPECODE,
        @DISCOUNTMERCHANDISEFORCODE,
        @APPLIESTOMERCHANDISECODE,
        @QUALIFYINGAPPLIESTOMERCHANDISECODE,
        @DISCOUNTPROGRAMS

    return 0;