USP_DATAFORMTEMPLATE_ADD_PROGRAM_TICKET_PART_SETTINGS

The save procedure used by the add dataform template "Program Ticket Part Settings Add Form".

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	INOUT	The output parameter indicating the ID of the record added.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@CONTENTID	int	IN	Content
@ORDERPAGEID	int	IN	Order Page
@ONSALEHORIZON	int	IN	On-sale Horizon
@TIMECOUNTTHRESHOLD	int	IN	Time Count Threshold
@CATEGORYFILTER	bit	IN	Category Filter
@MAXIMUMQUANTITY	int	IN	Maximum Quantity
@TIMEOUTMINUTES	int	IN	Timeout Minutes
@LOWAVAILABILITYTHRESHOLD	int	IN	Low Availability Threshold
@SHOWSOLDOUTEVENTS	bit	IN	Show Sold-out Events
@EVENTCONTACTEMAILADDRESS	UDT_EMAILADDRESS	IN	Event Contact Email Address
@ITEMDEFAULTIMAGEID	int	IN	Item Default Image
@ACKTEMPLATE	nvarchar(max)	IN	Acknowledgement Template

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_PROGRAM_TICKET_PART_SETTINGS
(
    @ID uniqueidentifier output, --removing = null because this should always be set to the SiteContent Guid

    @CHANGEAGENTID uniqueidentifier = null,
    @CONTENTID int,
    @ORDERPAGEID int = 0,
    @ONSALEHORIZON int = 400,
    @TIMECOUNTTHRESHOLD int = 0,
    @CATEGORYFILTER bit = 0,
    @MAXIMUMQUANTITY int = 100,
    @TIMEOUTMINUTES int = 0,
    @LOWAVAILABILITYTHRESHOLD int = 0,
    @SHOWSOLDOUTEVENTS bit = 0,
    @EVENTCONTACTEMAILADDRESS dbo.UDT_EMAILADDRESS = '',
    @ITEMDEFAULTIMAGEID int = 0,
    @ACKTEMPLATE nvarchar(max) = ''
)
as

set nocount on;

--if @ID is null

--    set @ID = newid()


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

declare @CURRENTDATE datetime
set @CURRENTDATE = getdate()

begin try
    -- handle inserting the data

    insert into dbo.PROGRAMTICKETPARTCONTENT
        (ID, CONTENTID, ORDERPAGEID, ONSALEHORIZON, TIMECOUNTTHRESHOLD, CATEGORYFILTER, MAXIMUMQUANTITY, TIMEOUTMINUTES, LOWAVAILABILITYTHRESHOLD, SHOWSOLDOUTEVENTS, EVENTCONTACTEMAILADDRESS, ITEMDEFAULTIMAGEID, ACKTEMPLATE, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED) 
    values
        (@ID, @CONTENTID, @ORDERPAGEID, @ONSALEHORIZON, @TIMECOUNTTHRESHOLD, @CATEGORYFILTER, @MAXIMUMQUANTITY, @TIMEOUTMINUTES, @LOWAVAILABILITYTHRESHOLD, @SHOWSOLDOUTEVENTS, @EVENTCONTACTEMAILADDRESS, @ITEMDEFAULTIMAGEID, @ACKTEMPLATE, @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE) 
end try

begin catch
    exec dbo.USP_RAISE_ERROR
    return 1
end catch

return 0