USP_PDACCOUNTSYSTEMSITE_UPDATEENTRY

Update account system site.

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@PDACCOUNTSYSTEMID	nvarchar(50)	IN
@SITEID	nvarchar(255)	IN
@CHANGEAGENTID	uniqueidentifier	IN

Definition

Copy



create procedure dbo.USP_PDACCOUNTSYSTEMSITE_UPDATEENTRY
(
    @ID uniqueidentifier,
    @PDACCOUNTSYSTEMID nvarchar(50),    
    @SITEID nvarchar(255),
    @CHANGEAGENTID uniqueidentifier = NULL        
)
as
begin

declare @CHANGEDATE datetime;

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

if (select count(ID) from dbo.PDACCOUNTSYSTEMSITE where ID = @ID) = 0
    insert into dbo.PDACCOUNTSYSTEMSITE(ID,PDACCOUNTSYSTEMID,SITEID, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)
        values(@ID,@PDACCOUNTSYSTEMID,@SITEID, @CHANGEAGENTID, @CHANGEAGENTID, @CHANGEDATE, @CHANGEDATE)
else
    update dbo.PDACCOUNTSYSTEMSITE
        set PDACCOUNTSYSTEMID = @PDACCOUNTSYSTEMID,
            SITEID = @SITEID,
            CHANGEDBYID = @CHANGEAGENTID,
            DATECHANGED = @CHANGEDATE
        where ID = @ID;

return 0
end