USP_DATAFORMTEMPLATE_ADD_SALESORDERITEMTICKET_COMBINATION_PRELOAD

The load procedure used by the edit dataform template "Sales Order Item Ticket Combination Add Data Form"

Parameters

Parameter	Parameter Type	Mode	Description
@COMBINATIONID	uniqueidentifier	IN	Input parameter indicating the context ID for the record being added.
@DATESELECTTYPE	int	INOUT	Date
@STARTDATE	datetime	INOUT	From
@ENDDATE	datetime	INOUT	To
@ORDERID	uniqueidentifier	INOUT	Order ID
@COMBINATIONNAME	nvarchar(100)	INOUT	Name
@SAMEDAYEVENT	bit	INOUT	Same day event
@PROGRAMGROUPS	xml	INOUT	Program group
@PRICETYPES	xml	INOUT	Prices
@COMBINATIONPRICES	xml	INOUT	Combination prices
@SALESMETHODEXCLUDEDPRICETYPE	xml	INOUT	Sales method exclude price types
@CURRENTDATE	datetime	INOUT
@TICKETCOMBINATIONID	uniqueidentifier	INOUT

Definition

Copy


            CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_SALESORDERITEMTICKET_COMBINATION_PRELOAD
            (
                @COMBINATIONID uniqueidentifier,
                @DATESELECTTYPE int = null output,
                @STARTDATE datetime = null output,
                @ENDDATE datetime = null output,
                @ORDERID uniqueidentifier  = null output,
                @COMBINATIONNAME nvarchar(100) = null output,
                @SAMEDAYEVENT bit = null output,
                @PROGRAMGROUPS xml = null output,
                @PRICETYPES xml = null output,
                @COMBINATIONPRICES xml = null output,
                @SALESMETHODEXCLUDEDPRICETYPE xml = null output,
                @CURRENTDATE datetime = null output,
                @TICKETCOMBINATIONID uniqueidentifier = null output
            )
            as
                set nocount on;

                select @COMBINATIONNAME = COMBINATION.NAME, @SAMEDAYEVENT = EVENTSSAMEDAY
                from dbo.COMBINATION where COMBINATION.ID = @COMBINATIONID

                set @PROGRAMGROUPS = (
                    select ID, NAME, IDSETREGISTERID as SELECTIONID
                    from dbo.PROGRAMGROUP where PROGRAMGROUP.COMBINATIONID = @COMBINATIONID
                    for xml raw('ITEM'),type,elements,root('PROGRAMGROUPS'),BINARY BASE64
                )

                set @COMBINATIONPRICES = (
                    select 
                        [COMBINATIONPRICETYPE].[PRICETYPECODEID] as [PRICETYPECODEID],
                        dbo.UFN_PRICETYPECODE_GETDESCRIPTION([COMBINATIONPRICETYPE].[PRICETYPECODEID]) as [PRICETYPE]
                    from dbo.UFN_COMBINATION_GETPRICETYPES(@COMBINATIONID) as [COMBINATIONPRICETYPE]
                    for xml raw ('ITEM'), type, elements, root('COMBINATIONPRICES'), BINARY BASE64
                );

                set @SALESMETHODEXCLUDEDPRICETYPE = (
                    select 
                        [SALESMETHODEXCLUDEDPRICETYPE].[PRICETYPECODEID] as [PRICETYPECODEID],
                        [SALESMETHOD].[TYPECODE] as [SALESMETHODTYPECODE]
                    from dbo.[SALESMETHODEXCLUDEDPRICETYPE]
                    inner join dbo.[SALESMETHOD]
                        on [SALESMETHODEXCLUDEDPRICETYPE].[SALESMETHODID] = [SALESMETHOD].[ID]
                    for xml raw ('ITEM'), type, elements, root('SALESMETHODEXCLUDEDPRICETYPE'), BINARY BASE64
                )

                set @CURRENTDATE = sysdatetimeoffset();

            return 0;