USP_PDACCOUNTSYSTEM_UPDATEENTRY

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

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@NAME	nvarchar(50)	IN
@DESCRIPTION	nvarchar(255)	IN
@ISDEFAULT	bit	IN
@CHANGEAGENTID	uniqueidentifier	IN
@CURRENCYSETID	uniqueidentifier	IN

Definition

Copy



CREATE procedure dbo.USP_PDACCOUNTSYSTEM_UPDATEENTRY 
(
    @ID uniqueidentifier,
    @NAME nvarchar(50),    
    @DESCRIPTION nvarchar(255),
    @ISDEFAULT bit,
    @CHANGEAGENTID uniqueidentifier = null,
    @CURRENCYSETID uniqueidentifier = null
)
as
begin

declare @CHANGEDATE datetime;

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

if @CURRENCYSETID is null
    set @CURRENCYSETID = dbo.UFN_CURRENCYSET_GETAPPUSERDEFAULTCURRENCYSET();

if (select count(ID) from dbo.PDACCOUNTSYSTEM where ID = @ID) = 0
    insert into dbo.PDACCOUNTSYSTEM(ID,NAME,DESCRIPTION,ISDEFAULT, CURRENCYSETID, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)
        values(@ID,@NAME,@DESCRIPTION,@ISDEFAULT, @CURRENCYSETID, @CHANGEAGENTID, @CHANGEAGENTID, @CHANGEDATE, @CHANGEDATE)
else
    update dbo.PDACCOUNTSYSTEM
        set NAME = @NAME,
            DESCRIPTION = @DESCRIPTION, 
            CHANGEDBYID = @CHANGEAGENTID,
            ISDEFAULT = @ISDEFAULT,
            DATECHANGED = @CHANGEDATE
        where ID = @ID;

return 0
end