USP_BBWORKFLOW_WORKFLOWDATAITEM_SETVALUE

CREATE PROCEDURE dbo.USP_BBWORKFLOW_WORKFLOWDATAITEM_SETVALUE
/*
Associates the xml data with the given workflow instance record using the key provided.
(Adds or updates a row in dbo.BBWORKFLOWDATAITEM).
*/

@BBWORKFLOWINSTANCEINFOID uniqueidentifier,
@ITEMKEY nvarchar(255),
@DATAITEM nvarchar(max),
@CHANGEAGENTID uniqueidentifier = null

as


set nocount on;


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

declare @CURRENTDATE datetime;
set @CURRENTDATE = getdate();


if exists ( select 1 from dbo.BBWORKFLOWDATAITEM where BBWORKFLOWINSTANCEINFOID=@BBWORKFLOWINSTANCEINFOID AND ITEMKEY=@ITEMKEY) 
    BEGIN
        update dbo.BBWORKFLOWDATAITEM set 
        DATAITEM=@DATAITEM,
        CHANGEDBYID=@CHANGEAGENTID,
        DATECHANGED=@CURRENTDATE 

        where BBWORKFLOWINSTANCEINFOID=@BBWORKFLOWINSTANCEINFOID AND ITEMKEY=@ITEMKEY;
    END
else
    BEGIN
        insert into dbo.BBWORKFLOWDATAITEM(BBWORKFLOWINSTANCEINFOID,ITEMKEY,DATAITEM,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED)    
        values (@BBWORKFLOWINSTANCEINFOID,@ITEMKEY,@DATAITEM,@CHANGEAGENTID,@CHANGEAGENTID,@CURRENTDATE,@CURRENTDATE);
    END