USP_BANKACCOUNTDEPOSITCREDITPAYMENT_ADD

Links a credit payment to a bank account deposit.
Parameters

Parameter	Parameter Type	Mode
@CREDITPAYMENTID	uniqueidentifier	IN
@DEPOSITID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN
Definition

Copy


            CREATE procedure dbo.USP_BANKACCOUNTDEPOSITCREDITPAYMENT_ADD
            (
                @CREDITPAYMENTID uniqueidentifier = null,
                @DEPOSITID uniqueidentifier = null,
                @CHANGEAGENTID uniqueidentifier
            )
            as
            begin
                if @CHANGEAGENTID is null
                    exec USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output

                declare @CHANGEDATE datetime = getdate()

                begin try
                    if exists(select 1 from dbo.BANKACCOUNTDEPOSITCREDITPAYMENT where ID = @CREDITPAYMENTID)
                        update dbo.BANKACCOUNTDEPOSITCREDITPAYMENT set
                            DEPOSITID = @DEPOSITID
                            ,CHANGEDBYID = @CHANGEAGENTID
                            ,DATECHANGED = @CHANGEDATE
                        where ID = @CREDITPAYMENTID;
                    else
                        insert into dbo.[BANKACCOUNTDEPOSITCREDITPAYMENT](
                            ID, 
                            DEPOSITID, 
                            ADDEDBYID, 
                            CHANGEDBYID, 
                            DATEADDED, 
                            DATECHANGED
                        )
                        values (
                            @CREDITPAYMENTID, 
                            @DEPOSITID, 
                            @CHANGEAGENTID, 
                            @CHANGEAGENTID, 
                            @CHANGEDATE, 
                            @CHANGEDATE
                        )

                    declare @CURRENTDATE datetime = getdate();
                    exec dbo.USP_BANKACCOUNTDEPOSIT_OVERWRITECREDITPAYMENTCREDITACCOUNTS @CREDITPAYMENTID, @DEPOSITID, @CHANGEAGENTID, @CURRENTDATE;
                end try

                begin catch
                    exec dbo.USP_RAISE_ERROR
                    return 1
                end catch

            end