USP_DATAFORMTEMPLATE_ADD_GIFTFEEOVERRIDEREASONCODE

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

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	INOUT	The output parameter indicating the ID of the record added.
@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_ADD_GIFTFEEOVERRIDEREASONCODE
(
    @ID uniqueidentifier = null output,
    @CODE nvarchar(10),
    @DESCRIPTION nvarchar(50),
    @CHANGEAGENTID uniqueidentifier,
  @ISPAYMENTEDITDEFAULT bit = 0
)
as
    set nocount on

    if @ID is null
        set @ID = newid()

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

  if @ISPAYMENTEDITDEFAULT is null
    set @ISPAYMENTEDITDEFAULT = 0

    declare @CURRENTDATE datetime
    set @CURRENTDATE = getdate()

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

    insert into dbo.GIFTFEEOVERRIDEREASONCODE (ID, CODE, DESCRIPTION, ISPAYMENTEDITDEFAULT, DATEADDED, DATECHANGED, ADDEDBYID, CHANGEDBYID)
        values (@ID, @CODE, @DESCRIPTION, @ISPAYMENTEDITDEFAULT, @CURRENTDATE, @CURRENTDATE, @CHANGEAGENTID, @CHANGEAGENTID)

    end try
    begin catch
        exec dbo.USP_RAISE_ERROR
        return 1
    end catch