USP_DATAFORMTEMPLATE_EDIT_DISBURSEMENTPROCESSTEMPLATE_TRANSACTIONCRITERIA

The save procedure used by the edit dataform template "Disbursement Process Template Transaction Criteria 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.
@FILTERCODE	tinyint	IN	Filter type
@DUEDATENUMBEROFDAYS	int	IN	Number of days after
@DUEDATECODE	tinyint	IN	Before or after the process date
@INCLUDEINVOICESWITHDISCOUNT	bit	IN	Include invoices with discounts that expire
@DISCOUNTDATENUMBEROFDAYS	int	IN	Number of days after
@DISCOUNTDATECODE	tinyint	IN	Before or after the process date
@IDSETREGISTERID	uniqueidentifier	IN	Selection
@CALCULATEDISCOUNTDAYS	int	IN	Number of days before the process date

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_DISBURSEMENTPROCESSTEMPLATE_TRANSACTIONCRITERIA (
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null,
  @FILTERCODE tinyint,
    @DUEDATENUMBEROFDAYS integer,
    @DUEDATECODE tinyint,
    @INCLUDEINVOICESWITHDISCOUNT bit,
  @DISCOUNTDATENUMBEROFDAYS integer,
  @DISCOUNTDATECODE tinyint,
  @IDSETREGISTERID uniqueidentifier,
  @CALCULATEDISCOUNTDAYS integer
)
as

    set nocount on;

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

    declare @CURRENTDATE datetime
    set @CURRENTDATE = getdate()

  if @FILTERCODE <> 0 
  begin
    set @INCLUDEINVOICESWITHDISCOUNT = 0;
    set @DISCOUNTDATENUMBEROFDAYS = 0;
    set @DISCOUNTDATECODE = 0;
  end

    begin try
        -- handle updating the data

        update dbo.DISBURSEMENTPROCESSTEMPLATE set
      FILTERCODE = @FILTERCODE,
            DUEDATENUMBEROFDAYS = @DUEDATENUMBEROFDAYS,
            DUEDATECODE = @DUEDATECODE,
            INCLUDEINVOICESWITHDISCOUNT = @INCLUDEINVOICESWITHDISCOUNT,
      DISCOUNTDATENUMBEROFDAYS = @DISCOUNTDATENUMBEROFDAYS,
      DISCOUNTDATECODE = @DISCOUNTDATECODE,
      IDSETREGISTERID = @IDSETREGISTERID,
      CALCULATEDISCOUNTDAYS = @CALCULATEDISCOUNTDAYS,
            CHANGEDBYID = @CHANGEAGENTID,
            DATECHANGED = @CURRENTDATE
        where ID = @ID
    end try
    begin catch
        exec dbo.USP_RAISE_ERROR
        return 1
    end catch

return 0;