USP_RE7INTEGRATION_UPDATECONFIGURATION

Update the RE7 integration configuration values.
Parameters

Parameter	Parameter Type	Mode
@CHANGEAGENTID	uniqueidentifier	IN
@RE7DBID	int	IN
@RE7DBDESCRIPTION	nvarchar(128)	IN
@RE7DBSERIALNUMBER	nvarchar(100)	IN
@DBSELECTIONLOCKED	bit	IN
Definition

Copy


                    CREATE procedure dbo.USP_RE7INTEGRATION_UPDATECONFIGURATION (
                        @CHANGEAGENTID uniqueidentifier = null,
                        @RE7DBID int,
                        @RE7DBDESCRIPTION nvarchar(128),
                        @RE7DBSERIALNUMBER nvarchar(100),
                        @DBSELECTIONLOCKED bit = 1
                    ) 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,
                                    @DBSELECTIONLOCKED,
                                    @CHANGEAGENTID,
                                    @CHANGEAGENTID,
                                    @CURRENTDATE,
                                    @CURRENTDATE
                                );
                            end
                            else begin
                                update dbo.RE7INTEGRATIONCONFIGURATION set
                                    RE7DBID = @RE7DBID,
                                    RE7DBDESCRIPTION = @RE7DBDESCRIPTION,       
                                    RE7DBSERIALNUMBER = @RE7DBSERIALNUMBER,       
                                    DBSELECTIONLOCKED = @DBSELECTIONLOCKED,       
                                    CHANGEDBYID = @CHANGEAGENTID,
                                    DATECHANGED = @CURRENTDATE
                                where ID = @ID;
                            end
                        end try
                        begin catch
                            exec dbo.USP_RAISE_ERROR
                            return 1
                        end catch

                    return 0;