USP_DATAFORMTEMPLATE_EDIT_RE7WEBINTEGRATIONCREDENTIALS

                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_RE7WEBINTEGRATIONCREDENTIALS (
                        @CHANGEAGENTID uniqueidentifier = null,
                        @CURRENTAPPUSERID uniqueidentifier,
                        @RE7USERNAME nvarchar(128),
                        @RE7PASSWORD nvarchar(128),
                        @RE7WINDOWSAUTHENTICATION bit
                    ) 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.RE7INTEGRATIONCREDENTIALS
                        where
                            RE7INTEGRATIONCREDENTIALS.ID = @CURRENTAPPUSERID;

                        begin try
                            -- Open the symmetric key for encryption
                            exec dbo.USP_GET_KEY_ACCESS;

                            declare @RE7PASSWORDENCRYPTED nvarchar(180);
                            set @RE7PASSWORDENCRYPTED = EncryptByKey(Key_GUID('sym_BBInfinity'),@RE7PASSWORD)

                            if @ID is null begin                            
                                insert into dbo.RE7INTEGRATIONCREDENTIALS (
                                    ID,
                                    RE7USERNAME,
                                    RE7PASSWORD,
                                    RE7WINDOWSAUTHENTICATION,
                                    ADDEDBYID,
                                    CHANGEDBYID,
                                    DATEADDED,
                                    DATECHANGED
                                ) values (
                                    @CURRENTAPPUSERID,
                                    case @RE7WINDOWSAUTHENTICATION
                                        when 1 then ''
                                        when 0 then @RE7USERNAME
                                    end,
                                    case @RE7WINDOWSAUTHENTICATION
                                        when 1 then ''
                                        when 0 then @RE7PASSWORDENCRYPTED
                                    end,
                                    @RE7WINDOWSAUTHENTICATION,
                                    @CHANGEAGENTID,
                                    @CHANGEAGENTID,
                                    @CURRENTDATE,
                                    @CURRENTDATE
                                );
                            end
                            else begin
                                update dbo.RE7INTEGRATIONCREDENTIALS set
                                    RE7USERNAME = case @RE7WINDOWSAUTHENTICATION
                                        when 1 then ''
                                        when 0 then @RE7USERNAME
                                    end,
                                    RE7PASSWORD = case @RE7WINDOWSAUTHENTICATION
                                        when 1 then ''
                                        when 0 then @RE7PASSWORDENCRYPTED
                                    end,                    
                                    RE7WINDOWSAUTHENTICATION = @RE7WINDOWSAUTHENTICATION,
                                    CHANGEDBYID = @CHANGEAGENTID,
                                    DATECHANGED = @CURRENTDATE
                                where ID = @CURRENTAPPUSERID;
                            end

                            update
                                dbo.RE7INTEGRATIONCONFIGURATION
                            set
                                DBSELECTIONLOCKED = 1,
                                CHANGEDBYID = @CHANGEAGENTID,
                                DATECHANGED = @CURRENTDATE;

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

                            -- Make sure we close the symmetric key
                            close symmetric key sym_BBInfinity;

                            return 1;
                        end catch

                    return 0;