USP_DATAFORMTEMPLATE_VIEW_DISCOUNTDETAILS

The load procedure used by the view dataform template "Discount Details View Form"

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter used to load the fields defined on the form.
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@NUMBERTOPURCHASE	int	INOUT	Quantity at full price
@NUMBERTODISCOUNTTYPE	nvarchar(50)	INOUT	Quantity discounted
@NUMBERTODISCOUNTTYPECODE	tinyint	INOUT	Quantity discounted code
@NUMBERTODISCOUNT	int	INOUT	Number to discount
@CALCULATIONTYPE	nvarchar(50)	INOUT	Calculation type
@CALCULATIONTYPECODE	tinyint	INOUT	Calculation type code
@DISCOUNTTICKETSFOR	nvarchar(50)	INOUT	Limit discount to
@LIMITDISCOUNTSPERORDER	bit	INOUT	Limit the number of times this discount may be applied in an order
@NUMBEROFDISCOUNTSPERORDER	int	INOUT	Discount may be applied
@DISCOUNTQUALIFYINGPRICETYPES	xml	INOUT	Buy these price types
@DISCOUNTPRICETYPES	xml	INOUT	Apply discounts to these price types
@DISCOUNTITEMTYPE	nvarchar(100)	INOUT	Item type
@DISCOUNTITEMTYPECODE	tinyint	INOUT	DISCOUNTITEMTYPECODE
@QUALIFYINGITEMTYPE	nvarchar(100)	INOUT	Item type
@QUALIFYINGITEMTYPECODE	tinyint	INOUT	QUALIFYINGITEMTYPECODE
@MERCHANDISEAMOUNT	money	INOUT	Value
@MERCHANDISEPERCENT	decimal(5, 2)	INOUT	Value
@DISCOUNTMERCHANDISEFOR	nvarchar(100)	INOUT	Limit discount to

Definition

Copy



                CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_DISCOUNTDETAILS
                (
                    @ID uniqueidentifier,
                    @DATALOADED bit = 0 output,                                                                        
                    @NUMBERTOPURCHASE int = null output,                    
                    @NUMBERTODISCOUNTTYPE nvarchar(50) = null output,
                    @NUMBERTODISCOUNTTYPECODE tinyint = null output,
                    @NUMBERTODISCOUNT int = null output,
                    @CALCULATIONTYPE nvarchar(50) = null output,
                    @CALCULATIONTYPECODE tinyint = null output,
                    @DISCOUNTTICKETSFOR nvarchar(50) = null output,
                    @LIMITDISCOUNTSPERORDER bit = null output,
                    @NUMBEROFDISCOUNTSPERORDER int = null output,                    
                    @DISCOUNTQUALIFYINGPRICETYPES xml = null output,
                    @DISCOUNTPRICETYPES xml = null output,
                    @DISCOUNTITEMTYPE nvarchar(100) = null output,
                    @DISCOUNTITEMTYPECODE tinyint = null output,
                    @QUALIFYINGITEMTYPE nvarchar(100) = null output,
                    @QUALIFYINGITEMTYPECODE tinyint = null output,
                    @MERCHANDISEAMOUNT money = null output,
                    @MERCHANDISEPERCENT decimal(5, 2) = null output,
                    @DISCOUNTMERCHANDISEFOR nvarchar(100) = null output
                )
                as
                    set nocount on;

                    set @DATALOADED = 0;

                    declare @APPLIESTOCODE tinyint;

                    select
                        @DATALOADED = 1,                        
                        @NUMBERTOPURCHASE = NUMBERTOPURCHASE,
                        @NUMBERTODISCOUNTTYPE = NUMBERTODISCOUNTTYPE,
                        @NUMBERTODISCOUNTTYPECODE = NUMBERTODISCOUNTTYPECODE,
                        @NUMBERTODISCOUNT = NUMBERTODISCOUNT,
                        @CALCULATIONTYPE = CALCULATIONTYPE,
                        @CALCULATIONTYPECODE = CALCULATIONTYPECODE,
                        @DISCOUNTTICKETSFOR = DISCOUNTTICKETSFOR,
                        @LIMITDISCOUNTSPERORDER = LIMITDISCOUNTSPERORDER,
                        @NUMBEROFDISCOUNTSPERORDER = NUMBEROFDISCOUNTSPERORDER,
                        @DISCOUNTITEMTYPE = DISCOUNTITEMTYPE,
                        @DISCOUNTITEMTYPECODE = DISCOUNTITEMTYPECODE,
                        @QUALIFYINGITEMTYPE = QUALIFYINGITEMTYPE,
                        @QUALIFYINGITEMTYPECODE = QUALIFYINGITEMTYPECODE,
                        @MERCHANDISEAMOUNT = MERCHANDISEAMOUNT,
                        @MERCHANDISEPERCENT = MERCHANDISEPERCENT,
                        @DISCOUNTMERCHANDISEFOR = DISCOUNTMERCHANDISEFOR
                    from
                        dbo.DISCOUNT
                    where
                        ID = @ID;                    

                    set @DISCOUNTQUALIFYINGPRICETYPES = dbo.UFN_DISCOUNT_VIEW_GETQUALIFYINGPRICETYPES_TOITEMLISTXML(@ID);
                    set @DISCOUNTPRICETYPES = dbo.UFN_DISCOUNT_VIEW_GETPRICETYPES_TOITEMLISTXML(@ID);

                    return 0;