USP_DATAFORMTEMPLATE_EDIT_GIFTFEEOVERRIDEREASONCODE_2

The save procedure used by the edit dataform template "Gift Fee Override Reason Code Edit Form".

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter indicating the ID of the record being edited.
@CODE	nvarchar(10)	IN	Reason code
@DESCRIPTION	nvarchar(50)	IN	Description
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@ISPAYMENTEDITDEFAULT	bit	IN	Default for gift fees edited via payment edits

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_GIFTFEEOVERRIDEREASONCODE_2
(
  @ID uniqueidentifier,
  @CODE nvarchar(10),
  @DESCRIPTION nvarchar(50),
  @CHANGEAGENTID uniqueidentifier = null,
  @ISPAYMENTEDITDEFAULT bit
)
as
  set nocount on

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

  declare @CURRENTDATE datetime
  set @CURRENTDATE = getdate()

  begin try
    if @ISPAYMENTEDITDEFAULT = 1
    begin
      update dbo.GIFTFEEOVERRIDEREASONCODE set
        ISPAYMENTEDITDEFAULT = 0,
        CHANGEDBYID = @CHANGEAGENTID,
        DATECHANGED = @CURRENTDATE
      where
        ISPAYMENTEDITDEFAULT = 1;
    end

    update dbo.GIFTFEEOVERRIDEREASONCODE set
      CODE = @CODE,
      DESCRIPTION = @DESCRIPTION,
      ISPAYMENTEDITDEFAULT = @ISPAYMENTEDITDEFAULT,
      DATECHANGED = @CURRENTDATE,
      CHANGEDBYID = @CHANGEAGENTID
    where ID = @ID
  end try
  begin catch
    exec dbo.USP_RAISE_ERROR
    return 1
  end catch