USP_DATAFORMTEMPLATE_EDIT_APPLICATIONRULES

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

Parameters

Parameter	Parameter Type	Mode	Description
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@ACCOUNTINGMETHODCODE	tinyint	IN	Accounting method
@PAYMENT	bit	IN	A payment
@CREDIT	bit	IN	A credit
@CHARGE	bit	IN	A charge

Definition

Copy



                CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_APPLICATIONRULES (
                    @CHANGEAGENTID uniqueidentifier = null,
                    @ACCOUNTINGMETHODCODE tinyint,
                    @PAYMENT bit,
                    @CREDIT bit,
                    @CHARGE bit
                )
                as

                    set nocount on;

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

                    declare @CURRENTDATE datetime
                    set @CURRENTDATE = getdate()

                    begin try
                        -- setting condition setting key based on accounting method code.

                        if @ACCOUNTINGMETHODCODE = 1
                            exec dbo.USP_CONDITIONSETTING_SETCONDITION 'OpenItem', @CHANGEAGENTID, @CURRENTDATE
                        else
                            exec dbo.USP_CONDITIONSETTING_DELETEBYNAME_WITHCHANGEAGENTID 'OpenItem', @CHANGEAGENTID

                        -- handle updating the data

                        update dbo.APPLICATIONRULES set
                            PAYMENT = @PAYMENT,
                            CREDIT = @CREDIT,
                            CHARGE = @CHARGE,
                            CHANGEDBYID = @CHANGEAGENTID,
                            DATECHANGED = @CURRENTDATE
                    end try
                    begin catch
                        exec dbo.USP_RAISE_ERROR
                        return 1
                    end catch

                return 0;