USP_DATAFORMTEMPLATE_EDIT_DISBURSEMENTPROCESS_RESULTSSETTINGS

The save procedure used by the edit dataform template "Disbursement Process Results Settings Edit Data 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.
@DISBURSEMENTDATE	datetime	IN	Disbursement date
@POSTSTATUSCODE	tinyint	IN	Post status
@POSTDATE	datetime	IN	Post date
@CREATESELECTIONFROMRESULT	bit	IN	Create selection from results
@OUTPUTIDSETRECORDTYPEID	uniqueidentifier	IN	Selection type
@OUTPUTIDSETNAME	nvarchar(100)	IN	Selection name
@OVERWRITEOUTPUTIDSET	bit	IN	Overwrite existing selection

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_DISBURSEMENTPROCESS_RESULTSSETTINGS (
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null,
    @DISBURSEMENTDATE datetime, 
    @POSTSTATUSCODE tinyint,
    @POSTDATE datetime, 
  @CREATESELECTIONFROMRESULT bit,
  @OUTPUTIDSETRECORDTYPEID uniqueidentifier,
  @OUTPUTIDSETNAME nvarchar(100),
  @OVERWRITEOUTPUTIDSET bit
)
as

    set nocount on;

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

    declare @CURRENTDATE datetime
    set @CURRENTDATE = getdate()

  if @POSTSTATUSCODE = 3
    set @POSTDATE = NULL;

    begin try
        -- handle updating the data

        update dbo.DISBURSEMENTPROCESS set
            DISBURSEMENTDATE = @DISBURSEMENTDATE, 
            POSTSTATUSCODE = @POSTSTATUSCODE,
            POSTDATE = @POSTDATE, 
      CREATESELECTIONFROMRESULT = @CREATESELECTIONFROMRESULT,
      OUTPUTIDSETRECORDTYPEID = @OUTPUTIDSETRECORDTYPEID,
      OUTPUTIDSETNAME = @OUTPUTIDSETNAME,
      OVERWRITEOUTPUTIDSET = @OVERWRITEOUTPUTIDSET,
            CHANGEDBYID = @CHANGEAGENTID,
            DATECHANGED = @CURRENTDATE
        where ID = @ID

    update FT
      set 
        POSTDATE = @POSTDATE
        ,POSTSTATUSCODE = @POSTSTATUSCODE
        ,DATE = @DISBURSEMENTDATE
      from
        dbo.FINANCIALTRANSACTION as FT
        inner join dbo.DISBURSEMENTPROCESSDISBURSEMENT as DPD
          on FT.ID = DPD.ID
      where 
        DPD.DISBURSEMENTPROCESSID = @ID;
    end try
    begin catch
        exec dbo.USP_RAISE_ERROR
        return 1
    end catch

return 0;