USP_DATAFORMTEMPLATE_ADD_ORDERTICKET

The save procedure used by the add dataform template "Order Ticket Add Data Form".

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	INOUT	The output parameter indicating the ID of the record added.
@EVENTID	uniqueidentifier	IN	Input parameter indicating the context ID for the record being added.
@ORDERID	uniqueidentifier	IN	Order ID
@PRICETYPES	xml	IN	Prices
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@DATA	xml	IN	Data
@OPTIONS	xml	IN	Options
@CALLBACKURL	nvarchar(255)	IN	Callback URL
@SYSTEMTYPENAME	nvarchar(255)	IN	System Type Name
@ASSEMBLYNAME	nvarchar(255)	IN	Assembly Name
@ATTRIBUTES	xml	IN	Attributes
@CATEGORYNAME	nvarchar(255)	IN	Category Name
@EXPIREDCALLBACKURL	nvarchar(255)	IN	Expired callback URL
@ACKNOWLEDGEMENT	nvarchar(max)	IN	Acknowledgement
@ALLOWPASTEVENTS	bit	IN	Allow sales to past events

Definition

Copy



                CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_ORDERTICKET
                (
                    @ID uniqueidentifier output,
                    @EVENTID uniqueidentifier,
                    @ORDERID uniqueidentifier = null,
                    @PRICETYPES xml = null,
                    @CHANGEAGENTID uniqueidentifier = null,
                    @DATA xml = null,
                    @OPTIONS xml = null,
                    @CALLBACKURL nvarchar(255) = '',
                    @SYSTEMTYPENAME nvarchar(255) = '',
                    @ASSEMBLYNAME nvarchar(255) = '',
                    @ATTRIBUTES xml = null,
                    @CATEGORYNAME nvarchar(255) = '',
                    @EXPIREDCALLBACKURL nvarchar(255) = '',
                    @ACKNOWLEDGEMENT nvarchar(max) = '',
                    @ALLOWPASTEVENTS bit = 0
                )
                as
                    set nocount on;

                    if @CHANGEAGENTID is null  
                        exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;

                    declare @CURRENTDATE datetime;
                    set @CURRENTDATE = getdate();

                    declare @PROGRAMID uniqueidentifier;
                    select @PROGRAMID = PROGRAMID from dbo.EVENT where ID = @EVENTID;

                    begin try
                        exec dbo.USP_SALESORDER_ISCOMPLETE_RAISERROR @ORDERID, @EXCLUDEGROUPSALES = 1;

                        if dbo.UFN_PROGRAM_ISPREREGISTERED(@PROGRAMID) = 1
                            raiserror('ERR_PREREGISTERED', 13, 1);

                        exec dbo.USP_SALESORDERITEMTICKETS_ADD
                            @ORDERID,
                            @CHANGEAGENTID,
                            @CURRENTDATE,
                            @EVENTID,
                            @PRICETYPES,
                            @DATA,
                            @OPTIONS,
                            @CALLBACKURL,
                            @SYSTEMTYPENAME,
                            @ASSEMBLYNAME,
                            @ATTRIBUTES,
                            @CATEGORYNAME,
                            @EXPIREDCALLBACKURL,
                            @ACKNOWLEDGEMENT,
                            @ALLOWPASTEVENTS;
                    end try

                    begin catch
                        exec dbo.USP_RAISE_ERROR;
                        return 1;
                    end catch

                    return 0;