USP_CREDITPAYMENT_UPDATESTATUS

Updates a credit payment's refund processed status.

Parameters

Parameter	Parameter Type	Mode
@CREDITPAYMENTID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN
@REFUNDPROCESSED	bit	IN
@STATUS	nvarchar(255)	IN
@APPUSERID	uniqueidentifier	IN

Definition

Copy



            CREATE procedure dbo.USP_CREDITPAYMENT_UPDATESTATUS (
                @CREDITPAYMENTID uniqueidentifier,
                @CHANGEAGENTID uniqueidentifier = null,
                @REFUNDPROCESSED bit = null,
                @STATUS nvarchar(255) = '',
                @APPUSERID uniqueidentifier = null
            )
            as
            begin
                if @CHANGEAGENTID is null  
                    exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;

                declare @DATECHANGED datetime = getdate()

                select
                    @REFUNDPROCESSED = case when @REFUNDPROCESSED is null then [REFUNDPROCESSED] else @REFUNDPROCESSED end,
                    @APPUSERID = case when @APPUSERID is null then [APPUSERID] else @APPUSERID end
                from dbo.[CREDITPAYMENT]
                where [ID] = @CREDITPAYMENTID

                begin try
                    update dbo.[CREDITPAYMENT] with (rowlock)
                    set
                        [REFUNDPROCESSED] = @REFUNDPROCESSED,
                        [STATUS] = @STATUS,
                        [APPUSERID] = @APPUSERID,
                        [DATECHANGED] = @DATECHANGED,
                        [CHANGEDBYID] = @CHANGEAGENTID
                    where [ID] = @CREDITPAYMENTID
                end try

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