USP_TASKWIZARDCATALOG_CREATEORUPDATE

Creates or updates a task wizard definition.

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@NAME	nvarchar(100)	IN
@DESCRIPTION	nvarchar(255)	IN
@SPECXML	xml	IN
@CHANGEAGENTID	uniqueidentifier	IN

Definition

Copy



create procedure dbo.USP_TASKWIZARDCATALOG_CREATEORUPDATE
    @ID uniqueidentifier,
    @NAME nvarchar(100),
    @DESCRIPTION nvarchar(255),
    @SPECXML xml,
    @CHANGEAGENTID uniqueidentifier = null

as
set nocount on

declare @CURRENTDATE datetime = getdate();

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

if @ID is null or @ID = '00000000-0000-0000-0000-000000000000'
begin
    set @ID = newid();
end;

if exists(select ID from dbo.TASKWIZARDCATALOG where ID = @ID) 
begin
    update dbo.TASKWIZARDCATALOG set
        ID = @ID,
        NAME = @NAME,
        DESCRIPTION = @DESCRIPTION,
        SPECXML = @SPECXML,
        CHANGEDBYID = @CHANGEAGENTID,
        DATECHANGED = @CURRENTDATE
    where dbo.TASKWIZARDCATALOG.ID = @ID;
end
else
begin
    insert into dbo.TASKWIZARDCATALOG
    (
        ID,
        NAME,
        DESCRIPTION,
        SPECXML,
        ADDEDBYID,
        CHANGEDBYID,
        DATEADDED,
        DATECHANGED
    )
    values
    (
        @ID,
        @NAME,
        @DESCRIPTION,
        @SPECXML,
        @CHANGEAGENTID,
        @CHANGEAGENTID,
        @CURRENTDATE,
        @CURRENTDATE
    )
end;