USP_DATAFORMTEMPLATE_EDIT_REVENUESCHEDULECREDITCARD

The save procedure used by the edit dataform template "RevenueScheduleCreditCard Edit Data Form".

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter indicating the ID of the record being edited.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@CREDITCARDTOKEN	uniqueidentifier	IN	Credit Card Token

Definition

Copy



                CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_REVENUESCHEDULECREDITCARD(
                    @ID uniqueidentifier,
                    @CHANGEAGENTID uniqueidentifier = null,
                    @CREDITCARDTOKEN uniqueidentifier
                )
                as

                set nocount on;

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

                declare @CURRENTDATE datetime
                set @CURRENTDATE = getdate()

                begin try    
                        update dbo.REVENUEPAYMENTMETHOD
                        set PAYMENTMETHODCODE = 2,
                        CHANGEDBYID = @CHANGEAGENTID,
                        DATECHANGED = @CURRENTDATE
                        where REVENUEID = @ID

                        update dbo.REVENUESCHEDULE
                        set CREDITCARDID = (select ID from dbo.CREDITCARD where CREDITCARDTOKEN = @CREDITCARDTOKEN),
                        CHANGEDBYID = @CHANGEAGENTID,
                        DATECHANGED = @CURRENTDATE
                        where ID = @ID
                end try
                begin catch
                    exec dbo.USP_RAISE_ERROR
                    return 1
                end catch

                return 0;