USP_DATAFORMTEMPLATE_EDIT_ORDERTICKET_2

The save procedure used by the edit dataform template "Order Ticket Edit Data Form".

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter indicating the ID of the record being edited.
@EVENTID	uniqueidentifier	IN	Event ID
@ORDERID	uniqueidentifier	IN	Order ID
@PRICETYPES	xml	IN	Prices
@ISDAILYADMISSION	bit	IN	Daily admission
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@PROGRAMID	uniqueidentifier	IN	Program ID
@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

Definition

Copy



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


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

                    declare @CURRENTDATE datetime
                    set @CURRENTDATE = getdate()

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

                        if @ISDAILYADMISSION <> 1
                        begin
                            select @PROGRAMID = PROGRAMID from dbo.EVENT where ID = @EVENTID;

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

                        exec dbo.USP_SALESORDERITEMTICKETS_EDIT 
                            @ID,
                            @EVENTID,
                            @ORDERID,
                            @PRICETYPES,
                            @ISDAILYADMISSION,
                            @CHANGEAGENTID,
                            @PROGRAMID,
                            @CURRENTDATE,
                            @DATA,
                            @OPTIONS,
                            @CALLBACKURL,
                            @SYSTEMTYPENAME,
                            @ASSEMBLYNAME,
                            @ATTRIBUTES,
                            @CATEGORYNAME,
                            @EXPIREDCALLBACKURL,
                            @ACKNOWLEDGEMENT
                    end try

                    begin catch
                        exec dbo.USP_RAISE_ERROR
                        return 1
                    end catch                    

                    return 0;