USP_DATAFORMTEMPLATE_EDIT_RE7INTEGRATIONCONFIGURATION

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

Parameter	Parameter Type	Mode	Description
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@RE7DBID	int	IN	The Raiser's Edge Database ID
@RE7DBDESCRIPTION	nvarchar(128)	IN	The Raiser's Edge Database
@RE7DBSERIALNUMBER	nvarchar(100)	IN	The Raiser's Edge database serial number
Definition

Copy


                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_RE7INTEGRATIONCONFIGURATION (
                        @CHANGEAGENTID uniqueidentifier = null,
                        @RE7DBID int,
                        @RE7DBDESCRIPTION nvarchar(128),
                        @RE7DBSERIALNUMBER nvarchar(100)
                    ) as
                        set nocount on;

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

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

                        declare @ID uniqueidentifier;

                        select
                            @ID = ID
                        from
                            dbo.RE7INTEGRATIONCONFIGURATION;

                        begin try
                            if @ID is null begin
                                insert into dbo.RE7INTEGRATIONCONFIGURATION (
                                    ID,
                                    RE7DBID,
                                    RE7DBDESCRIPTION,
                                    RE7DBSERIALNUMBER,
                                    DBSELECTIONLOCKED,
                                    ADDEDBYID,
                                    CHANGEDBYID,
                                    DATEADDED,
                                    DATECHANGED
                                ) values (
                                    newid(),
                                    @RE7DBID,
                                    @RE7DBDESCRIPTION,
                                    @RE7DBSERIALNUMBER,
                                    1,
                                    @CHANGEAGENTID,
                                    @CHANGEAGENTID,
                                    @CURRENTDATE,
                                    @CURRENTDATE
                                );
                            end
                            else begin
                                update dbo.RE7INTEGRATIONCONFIGURATION set
                                    RE7DBID = @RE7DBID,
                                    RE7DBDESCRIPTION = @RE7DBDESCRIPTION,       
                                    RE7DBSERIALNUMBER = @RE7DBSERIALNUMBER,       
                                    CHANGEDBYID = @CHANGEAGENTID,
                                    DATECHANGED = @CURRENTDATE
                                where ID = @ID;
                            end

                            exec dbo.USP_CONDITIONSETTING_SETCONDITION N'RE7Integration', @CHANGEAGENTID, @CURRENTDATE;
                        end try
                        begin catch
                            exec dbo.USP_RAISE_ERROR
                            return 1
                        end catch

                    return 0;