USP_RECORDOPERATION_CREDITCARDREFUNDTOGGLEENABLED

Executes the "Credit Card Refund: Toggle Enabled" record operation.

Parameters

Parameter	Parameter Type	Mode	Description
@ID	nvarchar(1)	IN	Input parameter indicating the ID of the record being updated.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the update.

Definition

Copy



                    create procedure dbo.USP_RECORDOPERATION_CREDITCARDREFUNDTOGGLEENABLED
                    (
                        @ID nvarchar(1),
                        @CHANGEAGENTID uniqueidentifier
                    )
                    as 
                    begin
                        if @CHANGEAGENTID is null
                            exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output

                        declare @CHANGEDATE datetime
                        set @CHANGEDATE = getdate()

                        declare @REFUNDSENABLED bit
                        set @REFUNDSENABLED = ~ dbo.UFN_CREDITCARDREFUNDS_AREREFUNDSENABLED() -- ~ is the negation operator


                        update dbo.CREDITCARDREFUNDCONFIGURATION set
                            REFUNDSENABLED = @REFUNDSENABLED,
                            DATECHANGED = @CHANGEDATE,
                            CHANGEDBYID = @CHANGEAGENTID

                        if @@ROWCOUNT = 0
                            insert into dbo.CREDITCARDREFUNDCONFIGURATION (REFUNDSENABLED, DATEADDED, DATECHANGED, ADDEDBYID, CHANGEDBYID)
                            values (@REFUNDSENABLED, @CHANGEDATE, @CHANGEDATE, @CHANGEAGENTID, @CHANGEAGENTID)

                        return 0;                        
                    end