USP_DATAFORMTEMPLATE_ADD_ETICKETSPARTSETTINGS

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	INOUT
@CHANGEAGENTID	uniqueidentifier	IN
@SITECONTENTID	int	IN
@PRINTBUTTONTEXT	nvarchar(max)	IN
@TICKETSTEXT	nvarchar(max)	IN
@FOOTERTEXT	nvarchar(max)	IN

Definition

Copy


create procedure dbo.USP_DATAFORMTEMPLATE_ADD_ETICKETSPARTSETTINGS
(
    @ID uniqueidentifier output,
    @CHANGEAGENTID uniqueidentifier = null,
    @SITECONTENTID int,
    @PRINTBUTTONTEXT nvarchar(max) = '',
    @TICKETSTEXT nvarchar(max) = '',
    @FOOTERTEXT nvarchar(max) = ''
)
as
    set nocount on;

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

    begin try
        exec dbo.USP_ETICKETSPARTSETTINGS_ADDUPDATE 
            @CHANGEAGENTID, 
            @SITECONTENTID, 
            @ID output, 
            @PRINTBUTTONTEXT, 
            @TICKETSTEXT, 
            @FOOTERTEXT;
    end try
    begin catch
        exec dbo.USP_RAISE_ERROR
        return 1
    end catch

return 0;