USP_DATAFORMTEMPLATE_EDIT_RE7WEBINTEGRATIONCONFIGURATION

Parameters

Parameter	Parameter Type	Mode
@CHANGEAGENTID	uniqueidentifier	IN
@RE7DBID	int	IN
@RE7DBDESCRIPTION	nvarchar(128)	IN
@RE7DBSERIALNUMBER	nvarchar(100)	IN
@RE7WEBSERVER	UDT_WEBADDRESS	IN
@CUSTOMCREDENTIALS	bit	IN
@RE7WEBSERVER_USERID	nvarchar(100)	IN
@RE7WEBSERVER_PASSWORD	nvarchar(100)	IN
Definition

Copy

                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_RE7WEBINTEGRATIONCONFIGURATION (
                        @CHANGEAGENTID uniqueidentifier = null,
                        @RE7DBID int,
                        @RE7DBDESCRIPTION nvarchar(128),
                        @RE7DBSERIALNUMBER nvarchar(100),
            @RE7WEBSERVER dbo.UDT_WEBADDRESS,
            @CUSTOMCREDENTIALS bit,
            @RE7WEBSERVER_USERID nvarchar(100),
            @RE7WEBSERVER_PASSWORD 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
              exec dbo.USP_GET_KEY_ACCESS;

                            if @ID is null begin
                                insert into dbo.RE7INTEGRATIONCONFIGURATION (
                                    ID,
                                    RE7DBID,
                                    RE7DBDESCRIPTION,
                                    RE7DBSERIALNUMBER,
                                    DBSELECTIONLOCKED,
                  RE7WEBSERVER,
                  CUSTOMCREDENTIALS,
                  RE7WEBSERVER_USERID,
                  RE7WEBSERVER_PASSWORD,
                                    ADDEDBYID,
                                    CHANGEDBYID,
                                    DATEADDED,
                                    DATECHANGED
                                ) values (
                                    newid(),
                                    @RE7DBID,
                                    @RE7DBDESCRIPTION,
                                    @RE7DBSERIALNUMBER,
                                    1,
                  @RE7WEBSERVER,
                  @CUSTOMCREDENTIALS,
                  @RE7WEBSERVER_USERID,
                  EncryptByKey(key_GUID('sym_BBInfinity'), @RE7WEBSERVER_PASSWORD),
                                    @CHANGEAGENTID,
                                    @CHANGEAGENTID,
                                    @CURRENTDATE,
                                    @CURRENTDATE
                                );
                            end
                            else begin
                                update dbo.RE7INTEGRATIONCONFIGURATION set
                                    RE7DBID = @RE7DBID,
                                    RE7DBDESCRIPTION = @RE7DBDESCRIPTION,       
                                    RE7DBSERIALNUMBER = @RE7DBSERIALNUMBER,     
                  RE7WEBSERVER = @RE7WEBSERVER,
                  CUSTOMCREDENTIALS = @CUSTOMCREDENTIALS,
                  RE7WEBSERVER_USERID = @RE7WEBSERVER_USERID,
                  RE7WEBSERVER_PASSWORD = EncryptByKey(key_GUID('sym_BBInfinity'), @RE7WEBSERVER_PASSWORD),
                                    CHANGEDBYID = @CHANGEAGENTID,
                                    DATECHANGED = @CURRENTDATE
                                where ID = @ID;
                            end

              close symmetric key sym_BBInfinity;
                        end try
                        begin catch
                            exec dbo.USP_RAISE_ERROR
                            return 1
                        end catch

                    return 0;