USP_DATAFORMTEMPLATE_EDIT_PDACCOUNTCODEMAPDEVELOPMENTGIFTFEE

The save procedure used by the edit dataform template "Map Development Gift Fees Edit 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.
@REVENUETYPES	xml	IN	Revenue types
@APPLICATIONTYPES	xml	IN	Application types
@PAYMENTMETHODS	xml	IN	Payment methods
@DEBITGLACCOUNTID	uniqueidentifier	IN	Account
@DEBITPDACCOUNTSEGMENTVALUEID	uniqueidentifier	IN	Account code
@CREDITGLACCOUNTID	uniqueidentifier	IN	Account
@CREDITPDACCOUNTSEGMENTVALUEID	uniqueidentifier	IN	Account code
@PDACCOUNTSYSTEMID	uniqueidentifier	IN

Definition

Copy


                CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_PDACCOUNTCODEMAPDEVELOPMENTGIFTFEE
                (
                    @ID uniqueidentifier,
                    @CHANGEAGENTID uniqueidentifier = null,
                    @REVENUETYPES xml,
                    @APPLICATIONTYPES xml,
                    @PAYMENTMETHODS xml,
                    @DEBITGLACCOUNTID uniqueidentifier,
                    @DEBITPDACCOUNTSEGMENTVALUEID uniqueidentifier,
                    @CREDITGLACCOUNTID uniqueidentifier,
                    @CREDITPDACCOUNTSEGMENTVALUEID uniqueidentifier, 
                    @PDACCOUNTSYSTEMID uniqueidentifier
                )
                as

                    set nocount on;

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

                    declare @CURRENTDATE datetime
                    declare @PaymentMethodsTable table (NameID int)

                    set @CURRENTDATE = getdate()

                    begin try
                    insert into @PaymentMethodsTable (NameID)
                    select NameID from dbo.UFN_PDACCOUNTCODEMAPPING_PAYMENTMETHODS_FROMITEMLISTXML(@PAYMENTMETHODS)

                    -- handle updating the data
                    update dbo.PDACCOUNTCODEMAPPING set
                        REVENUETYPE = (select sum(distinct NAMEID) from dbo.UFN_PDACCOUNTCODEMAPPING_REVENUETYPES_FROMITEMLISTXML(@REVENUETYPES)),
                        APPLICATIONTYPE = (select sum(distinct NAMEID) from dbo.UFN_PDACCOUNTCODEMAPPING_APPLICATIONTYPES_FROMITEMLISTXML(@APPLICATIONTYPES)),
                        PAYMENTMETHOD = (select sum(distinct NAMEID) from @PaymentMethodsTable),
                        DEBITGLACCOUNTID = @DEBITGLACCOUNTID,
                        DEBITPDACCOUNTSEGMENTVALUEID = @DEBITPDACCOUNTSEGMENTVALUEID,
                        CREDITGLACCOUNTID = @CREDITGLACCOUNTID,
                        CREDITPDACCOUNTSEGMENTVALUEID = @CREDITPDACCOUNTSEGMENTVALUEID,
                        CHANGEDBYID = @CHANGEAGENTID,
                        DATECHANGED = @CURRENTDATE,
                        PDACCOUNTSYSTEMID = @PDACCOUNTSYSTEMID
                    where ID = @ID

                    end try
                    begin catch
                    rollback
                        exec dbo.USP_RAISE_ERROR
                        return 1
                    end catch

                return 0;