USP_PDCATEGORYDEFINITION_UPDATEENTRY

Adds/updates a system-defined entry in the PDCATEGORYDEFINITION table

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@CATEGORYNAME	nvarchar(100)	IN
@CATEGORYNAMEID	tinyint	IN
@TSLONG	int	IN
@CHANGEAGENTID	uniqueidentifier	IN

Definition

Copy



create procedure dbo.USP_PDCATEGORYDEFINITION_UPDATEENTRY(
    @ID uniqueidentifier,
    @CATEGORYNAME nvarchar(100),
    @CATEGORYNAMEID tinyint,
     @TSLONG int=0,            
    @CHANGEAGENTID uniqueidentifier = NULL        

)
as
begin

declare @CHANGEDATE datetime;

exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;
set @CHANGEDATE = getdate();        

if (select count(ID) from dbo.PDCATEGORYDEFINITION where ID = @ID) = 0
    insert into dbo.PDCATEGORYDEFINITION(ID,CATEGORYNAME,CATEGORYNAMEID,ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)
        values(@ID,@CATEGORYNAME, @CATEGORYNAMEID,@CHANGEAGENTID, @CHANGEAGENTID, @CHANGEDATE, @CHANGEDATE)


else
    update dbo.PDCATEGORYDEFINITION
        set CATEGORYNAME = @CATEGORYNAME, 
            CATEGORYNAMEID = @CATEGORYNAMEID,    
            CHANGEDBYID = @CHANGEAGENTID,
            DATECHANGED = @CHANGEDATE
        where ID = @ID;

return 0
end