USP_ETICKETSPARTSETTINGS_ADDUPDATE

Parameters

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

Definition

Copy



create procedure dbo.USP_ETICKETSPARTSETTINGS_ADDUPDATE (
    @CHANGEAGENTID uniqueidentifier,
    @SITECONTENTID int,
    @ID uniqueidentifier = null output,
    @PRINTBUTTONTEXT nvarchar(max) = '',
    @TICKETSTEXT nvarchar(max) = '',
    @FOOTERTEXT nvarchar(max) = ''
)
as
begin
    declare @CURRENTDATE datetime
    set @CURRENTDATE = getdate()

    select @ID = [Guid] --Making sure we're using the right ID

    from dbo.[SiteContent] with (nolock)
    where ID = @SITECONTENTID;

    merge dbo.[ETICKETSPARTSETTINGS] as [TARGET]
    using (select @ID as ID) as [SOURCE]
    on (TARGET.ID = SOURCE.ID)
    when matched then
        update 
        set 
            SITECONTENTID = @SITECONTENTID,
            PRINTBUTTONTEXT = isnull(@PRINTBUTTONTEXT, ''),
            TICKETSTEXT = isnull(@TICKETSTEXT, ''),
            FOOTERTEXT = isnull(@FOOTERTEXT, ''),
            CHANGEDBYID = @CHANGEAGENTID,
            DATECHANGED = @CURRENTDATE
    when not matched then
        insert (
            ID, 
            SITECONTENTID, 
            PRINTBUTTONTEXT,
            TICKETSTEXT,
            FOOTERTEXT,
            ADDEDBYID, 
            CHANGEDBYID, 
            DATEADDED, 
            DATECHANGED
        ) 
        values (
            @ID, 
            @SITECONTENTID, 
            isnull(@PRINTBUTTONTEXT,''),
            isnull(@TICKETSTEXT,''),
            isnull(@FOOTERTEXT,''),
            @CHANGEAGENTID, 
            @CHANGEAGENTID, 
            @CURRENTDATE, 
            @CURRENTDATE
        );
end