USP_DATAFORMTEMPLATE_EDIT_FINANCIALSYSTEMSETTINGS

The save procedure used by the edit dataform template "Financial System Settings Edit Form".

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter indicating the ID of the record being edited.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@ISSUMMARYDISTRIBUTIONEDITABLE	tinyint	IN	Allow summary account editing in transactions

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_FINANCIALSYSTEMSETTINGS (
    @ID uniqueidentifier
    ,@CHANGEAGENTID uniqueidentifier = null
    ,@ISSUMMARYDISTRIBUTIONEDITABLE tinyint 
)
as

    set nocount on;

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

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

    begin try
    if exists(select * from FINANCIALSYSTEMSETTINGS where FINANCIALSYSTEMID=@ID)
          update dbo.FINANCIALSYSTEMSETTINGS set
              ISSUMMARYDISTRIBUTIONEDITABLE = @ISSUMMARYDISTRIBUTIONEDITABLE
              ,CHANGEDBYID = @CHANGEAGENTID
              ,DATECHANGED = @CURRENTDATE
          where FINANCIALSYSTEMID = @ID
      ;
    else
      insert into dbo.FINANCIALSYSTEMSETTINGS 
      (
        ID
        ,FINANCIALSYSTEMID
        ,ISSUMMARYDISTRIBUTIONEDITABLE 
        ,DATECHANGED
        ,DATEADDED
        ,CHANGEDBYID
        ,ADDEDBYID
      )
      values
      (
        NEWID()
        ,@ID
        ,@ISSUMMARYDISTRIBUTIONEDITABLE 
        ,@CURRENTDATE
        ,@CURRENTDATE
        ,@CHANGEAGENTID
        ,@CHANGEAGENTID
      )
      ;
    end try
    begin catch
        exec dbo.USP_RAISE_ERROR;
        return 1;
    end catch

return 0;