USP_DATAFORMTEMPLATE_EDIT_RE7INTEGRATIONFIELDS2

Parameters

Parameter	Parameter Type	Mode
@CHANGEAGENTID	uniqueidentifier	IN
@CURRENTAPPUSERID	uniqueidentifier	IN
@AVAILABLETORE7FIELDS	xml	IN
@AVAILABLEFROMRE7FIELDS	xml	IN
@AVAILABLEVIEWRE7FIELDS	xml	IN
@GIFTSOFTCREDITS	bit	IN
@GIFTCASH	bit	IN
@GIFTPLEDGE	bit	IN
@GIFTSTOCK	bit	IN
@GIFTINKIND	bit	IN
@GIFTWRITEOFF	bit	IN
@GIFTRECURRING	bit	IN
@GIFTPLANNED	bit	IN
@GIFTOTHER	bit	IN
Definition

Copy

                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_RE7INTEGRATIONFIELDS2 (
                        @CHANGEAGENTID uniqueidentifier = null,

                        @CURRENTAPPUSERID uniqueidentifier,
            @AVAILABLETORE7FIELDS xml,
            @AVAILABLEFROMRE7FIELDS xml,
            @AVAILABLEVIEWRE7FIELDS xml,
            @GIFTSOFTCREDITS bit,
            @GIFTCASH bit,
            @GIFTPLEDGE bit,
            @GIFTSTOCK bit,
            @GIFTINKIND bit,
            @GIFTWRITEOFF bit,
            @GIFTRECURRING bit,
            @GIFTPLANNED bit,
            @GIFTOTHER bit
                    ) as
                        set nocount on;

                        declare @CURRENTDATE datetime;
                        set @CURRENTDATE = getdate();

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

                        begin try
                            update dbo.RE7INTEGRATIONCONFIGURATION set
                                CHANGEDBYID = @CHANGEAGENTID,
                                DATECHANGED = @CURRENTDATE;

                declare @FROMRE7SELECTEDFIELDS xml =
                (    select
                        Tbl.Col.value('ID[1]', 'uniqueidentifier') as ID
                    From @AVAILABLEFROMRE7FIELDS.nodes('//ITEM') Tbl(Col)
                    where Tbl.Col.value('SELECTED[1]', 'bit') = 1
                    for xml path('ITEM'), root('RE7INTEGRATIONSELECTEDFIELDS')
                )

                declare @TORE7SELECTEDFIELDS xml =
                (    select
                        Tbl.Col.value('ID[1]', 'uniqueidentifier') as ID
                    From @AVAILABLETORE7FIELDS.nodes('//ITEM') Tbl(Col)
                    where Tbl.Col.value('SELECTED[1]', 'bit') = 1
                    for xml path('ITEM'), root('RE7INTEGRATIONSELECTEDFIELDS')
                )

                declare @VIEWRE7SELECTEDFIELDS xml =
                (    select
                        Tbl.Col.value('ID[1]', 'uniqueidentifier') as ID
                    From @AVAILABLEVIEWRE7FIELDS.nodes('//ITEM') Tbl(Col)
                    where Tbl.Col.value('SELECTED[1]', 'bit') = 1
                    for xml path('ITEM'), root('RE7INTEGRATIONSELECTEDFIELDS')
                )

                            exec dbo.USP_RE7INTEGRATION_GETSELECTEDFIELDS_UPDATEFROMXML 0, @FROMRE7SELECTEDFIELDS, @CHANGEAGENTID, @CURRENTDATE;
                            exec dbo.USP_RE7INTEGRATION_GETSELECTEDFIELDS_UPDATEFROMXML 1, @TORE7SELECTEDFIELDS, @CHANGEAGENTID, @CURRENTDATE;
                            exec dbo.USP_RE7INTEGRATION_GETSELECTEDFIELDS_UPDATEFROMXML 2, @VIEWRE7SELECTEDFIELDS, @CHANGEAGENTID, @CURRENTDATE;
                        end try
                        begin catch
                            exec dbo.USP_RAISE_ERROR
                            return 1
                        end catch

            update RE7INTEGRATIONGIVINGSUMMARYFILTERS
            set INCLUDESOFTCREDITS = @GIFTSOFTCREDITS,
                INCLUDECASH = @GIFTCASH,
                INCLUDEPLEDGE = @GIFTPLEDGE,
                INCLUDESTOCK = @GIFTSTOCK,
                INCLUDEGIFTINKIND = @GIFTINKIND,
                INCLUDEWRITEOFF = @GIFTWRITEOFF,
                INCLUDERECURRINGGIFT = @GIFTRECURRING,
                INCLUDEPLANNEDGIFT = @GIFTPLANNED,
                INCLUDEOTHER = @GIFTOTHER,
                DATECHANGED = @CURRENTDATE,
                CHANGEDBYID = @CHANGEAGENTID

                    return 0;