USP_DATAFORMTEMPLATE_EDIT_RE7INTEGRATIONFIELDS

The save procedure used by the edit dataform template "RE7 Integration Fields Edit Form".

Parameters

Parameter	Parameter Type	Mode	Description
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@FROMRE7	bit	IN	Add data from The Raiser's Edge
@FROMRE7SELECTEDFIELDS	xml	IN	Fields
@TORE7	bit	IN	Add data to The Raiser's Edge
@TORE7SELECTEDFIELDS	xml	IN	Fields
@VIEWRE7SELECTEDFIELDS	xml	IN
@CURRENTAPPUSERID	uniqueidentifier	IN

Definition

Copy


                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_RE7INTEGRATIONFIELDS (
                        @CHANGEAGENTID uniqueidentifier = null,
                        @FROMRE7 bit,
                        @FROMRE7SELECTEDFIELDS xml,
                        @TORE7 bit,
                        @TORE7SELECTEDFIELDS xml,
                        @VIEWRE7SELECTEDFIELDS xml,
                        @CURRENTAPPUSERID uniqueidentifier
                    ) 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
                                FROMRE7 = @FROMRE7,
                                TORE7 = @TORE7,
                                CHANGEDBYID = @CHANGEAGENTID,
                                DATECHANGED = @CURRENTDATE;

                            set @FROMRE7SELECTEDFIELDS = replace(convert(nvarchar(max),@FROMRE7SELECTEDFIELDS),'FROMRE7SELECTEDFIELDS','RE7INTEGRATIONSELECTEDFIELDS');
                            set @TORE7SELECTEDFIELDS = replace(convert(nvarchar(max),@TORE7SELECTEDFIELDS),'TORE7SELECTEDFIELDS','RE7INTEGRATIONSELECTEDFIELDS');
                            set @VIEWRE7SELECTEDFIELDS = replace(convert(nvarchar(max),@VIEWRE7SELECTEDFIELDS),'VIEWRE7SELECTEDFIELDS','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

                    return 0;