ConnectionDialog.xaml.cs

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Windows;
using System.Windows.Controls;
using System.Windows.Navigation;
using Microsoft.Win32;
using LINQPad.Extensibility.DataContext;
using System.Diagnostics;
using System.Collections;
using static Aerospike.Database.LINQPadDriver.ConnectionProperties;
using System.Globalization;
using System.Windows.Input;
using LINQPad.Extensibility.DataContext.UI;
using System.Windows.Media;
using Aerospike.Database.LINQPadDriver.Extensions;

namespace Aerospike.Database.LINQPadDriver
{
	public partial class ConnectionDialog : Window
	{
		readonly IConnectionInfo _cxInfo;
        readonly ConnectionProperties _connectionProps;

        public ConnectionDialog (IConnectionInfo cxInfo)
		{
			_cxInfo = cxInfo;

            // ConnectionProperties is your view-model.
            DataContext = new ConnectionProperties (cxInfo);
            _connectionProps = (ConnectionProperties)DataContext;

            InitializeComponent ();

            if(!string.IsNullOrEmpty(_connectionProps.TLSProtocols))
            {
                cbTLSOnlyLogin.IsEnabled = true;
                txtCertFile.IsEnabled = true;
                txtRejectCerts.IsEnabled = true;
                btnCertFile.IsEnabled = true;
            }

            {
                var nameFnd = false;

                this.comboPasswordNames.Items.Clear();
                foreach (var name in PasswordManagerNames)
                {
                    if (!this.comboPasswordNames.Items.Contains(name))
                        this.comboPasswordNames.Items.Add(name);
                    if (!this.comboCldPasswordNames.Items.Contains(name))
                        this.comboCldPasswordNames.Items.Add(name);
                    if (name == _connectionProps.PasswordManagerName)
                        nameFnd = true;
                }

                if(!string.IsNullOrEmpty(_connectionProps.PasswordManagerName))
                {
                    if(!nameFnd)
                        this.comboPasswordNames.Items.Add(_connectionProps.PasswordManagerName);
                    this.comboPasswordNames.SelectedItem = _connectionProps.PasswordManagerName;
                    if (!nameFnd)
                        this.comboCldPasswordNames.Items.Add(_connectionProps.PasswordManagerName);
                    this.comboCldPasswordNames.SelectedItem = _connectionProps.PasswordManagerName;
                }

                cbUsePassMgr_Click(this.cbUsePassMgr, new RoutedEventArgs());
                cbCldUsePassMgr_Click(this.cbCldUsePassMgr, new RoutedEventArgs());
            }

            defaultBolderBrush = this.txtCldhostName.BorderBrush;
            DBTypeCache.Save(this._connectionProps);
            DBTypeCache.Update(this._connectionProps.DBType, this, this._connectionProps);
            priorTab = _connectionProps.DBType;
        }

        void btnOK_Click (object sender, RoutedEventArgs e)
		{
            //Debugger.Launch ();
            DialogResult = true;
		}

        private void Hyperlink_RequestNavigate(object sender, RequestNavigateEventArgs e)
        {			
			try
			{
				Process.Start(new ProcessStartInfo(e.Uri.AbsoluteUri) { UseShellExecute = true });
				e.Handled = true;
			}
			catch { }
        }

        private void btnCertFile_Click(object sender, RoutedEventArgs e)
        {
            OpenFileDialog openFileDialog = new OpenFileDialog()
            {
                Filter = "Cert files (*.cer;*.crt;*.cert)|*.cer;*.crt;*.cert|All files (*.*)|*.*",
                Title = "Select Certificate File",
                CheckPathExists = true,
                CheckFileExists = true,
                AddExtension = true
            };

            if (string.IsNullOrEmpty(txtCertFile.Text))
			{				
				openFileDialog.DefaultExt = ".cer";
			}
			else
			{
				//openFileDialog.InitialDirectory = System.IO.Path.GetDirectoryName(openFileDialog.FileName);
				openFileDialog.FileName = txtCertFile.Text;
                openFileDialog.DefaultExt = System.IO.Path.GetExtension(txtCertFile.Text);                
            }
            if (openFileDialog.ShowDialog() == true)
                txtCertFile.Text = openFileDialog.FileName;
        }
        
        private void cbAllDTNumeric_Checked(object sender, RoutedEventArgs e)
        {
            var cb = (CheckBox)sender;

            if(cb.IsChecked.HasValue && cb.IsChecked.Value)
            {
                cbUseUnixEpoch.IsEnabled = false;
                txtDateTimeFmt.IsEnabled = false;
                txtDateTimeOffsetFmt.IsEnabled = false;
                txtTimeSpanFmt.IsEnabled = false;
            }
            else
            {
                cbUseUnixEpoch.IsEnabled = true;
                txtDateTimeFmt.IsEnabled = true;
                txtDateTimeOffsetFmt.IsEnabled = true;
                txtTimeSpanFmt.IsEnabled = true;
            }
        }


        private void lbProtocols_Checked(object sender, RoutedEventArgs e)
        {
            var cb = (CheckBox)sender;
            var protocolItems = lbProtocols.ItemsSource.Cast<TLSProtocolItem>();
            var cbDisabled = protocolItems.First(c => c.Name == "Disabled");
            var cbDetect = protocolItems.First(cb=> cb.Name == "None");

            if ((string)cb.Tag == "Disabled")
            {
                if (cb.IsChecked.HasValue && cb.IsChecked.Value)
                {
                    foreach (var item in protocolItems)
                    {
                        if (item.Name != "Disabled")
                            item.IsChecked = false;
                    }
                    cbTLSOnlyLogin.IsEnabled = false;
                    txtCertFile.IsEnabled = false;
                    txtRejectCerts.IsEnabled = false;
                    btnCertFile.IsEnabled = false;
                }
            }
            else if ((string)cb.Tag == "None")
            {
                if (cb.IsChecked.HasValue)
                {
                    if (cb.IsChecked.Value)
                    {
                        foreach (var item in protocolItems)
                        {
                            if (item.Name != "None")
                                item.IsChecked = false;
                        }
                        cbTLSOnlyLogin.IsEnabled = true;
                        txtCertFile.IsEnabled = true;
                        txtRejectCerts.IsEnabled = true;
                        btnCertFile.IsEnabled = true;
                    }
                    else if (protocolItems.All(c => !c.IsChecked))
                    {
                        cbTLSOnlyLogin.IsEnabled = false;
                        txtCertFile.IsEnabled = false;
                        txtRejectCerts.IsEnabled = false;
                        btnCertFile.IsEnabled = false;
                        cbDisabled.IsChecked = true;
                    }
                }
            }
            else
            {
                foreach (var c in protocolItems)
                {
                    if (c.IsChecked)
                    {
                        cbDisabled.IsChecked = false;
                        cbDetect.IsChecked = false;
                        cbTLSOnlyLogin.IsEnabled = true;
                        txtCertFile.IsEnabled = true;
                        txtRejectCerts.IsEnabled = true;
                        btnCertFile.IsEnabled = true;
                    }
                    else if (protocolItems.All(c => !c.IsChecked))
                    {
                        cbTLSOnlyLogin.IsEnabled = false;
                        txtCertFile.IsEnabled = false;
                        txtRejectCerts.IsEnabled = false;
                        btnCertFile.IsEnabled = false;
                        cbDisabled.IsChecked = true;
                    }
                }                
            }

            
        }

        private void lbRecordViews_Checked(object sender, RoutedEventArgs e)
        {
            var rb = (RadioButton)sender;
            var recViewItems = lbRecordViews.ItemsSource.Cast<RecordViewItem>();
            
            foreach(var item in recViewItems)
            {
                if(item.Name == (string) rb.Tag)
                {
                    item.IsChecked = true;
                }
                else
                { item.IsChecked = false; }
            }      
        }

        private void btnTestConnection_Click(object sender, RoutedEventArgs e)
        {
            var localHost = txtSeedNodes.Text;
            string messageBoxText = "Trying to Connect...";
            string caption = $"Testing Connection to \"{localHost}\"";
            MessageBoxButton button = MessageBoxButton.OK;
            MessageBoxImage icon = MessageBoxImage.Information;
            AerospikeConnection connection = null;

            var waitCursor = new WaitCursor();

            try
            {                
                try
                {
                    var testTask = System.Threading.Tasks.Task.Run(() =>
                    {
                        connection = new AerospikeConnection(_cxInfo);
                        connection.ObtainMetaDate(false);
                    });
                    testTask.Wait();

                    if (connection.DBPlatform == DBPlatforms.Cloud)
                    {
                        messageBoxText = $@"
Cloud Database Id ""{_cxInfo.DatabaseInfo.Database}"" Successfully Connected!";
                    }
                    else
                    {
                        messageBoxText = $@"
Cluster Name: ""{_cxInfo.DatabaseInfo.Database}""
DB Version: {_cxInfo.DatabaseInfo.DbVersion}
Nodes: {connection.Nodes.Length}
Namespaces: {connection.Namespaces.Count()}
Sets: {connection.Namespaces.Sum(n => n.Sets.Count())}
Bins: {connection.Namespaces.Sum(n => n.Bins.Count())}
Secondary Indexes: {connection.Namespaces.Sum(n => n.SIndexes.Count())}
UDFs: {connection.UDFModules.Count()}";
                    }
                }
                catch(Exception ex)
                {
                    icon = MessageBoxImage.Error;
                    messageBoxText = $@"
An Exception ""{ex.GetType().Name}"" occurred.
{ex.Message}
Source: ""{ex.Source}"" Help Link: ""{ex.HelpLink}"" HResult: ""{ex.HResult}"" TargetSite: ""{ex.TargetSite}""
";
                    if(ex.InnerException!= null)
                    {
                        messageBoxText += $@"
Inner Exception is ""{ex.InnerException.GetType().Name}"",
{ex.InnerException.Message}
Source: ""{ex.InnerException.Source}"" Help Link: ""{ex.InnerException.HelpLink}"" HResult: ""{ex.InnerException.HResult}"" TargetSite: ""{ex.InnerException.TargetSite}""
";
                    }
                    if (connection != null)
                    {
                        if (connection.DBPlatform != DBPlatforms.Cloud)
                        {
                            if (Helpers.IsPrivateAddress(connection.SeedHosts.FirstOrDefault().name))
                            {
                                if (connection.UseExternalIP)
                                {
                                    messageBoxText += $@"

Note: The DB seems to be on a private network
      and ""Public Address"" option is enabled! Should this be disabled?
";
                                }
                            }
                            else if (!connection.UseExternalIP)
                            {
                                messageBoxText += $@"

Note: If the DB has Public/NATted/Alternate Addresses,
      you may need to enable ""Public Address"" option!
";
                            }
                        }
                    }
                }
                
                waitCursor?.Dispose();
                waitCursor = null;
                MessageBox.Show(this, messageBoxText, caption, button, icon, MessageBoxResult.OK);
            }
            finally
            {                
                waitCursor?.Dispose();
            }
        }

        private void txtSampleRecs_TextChanged(object sender, TextChangedEventArgs e)
        {            
            static bool TryGetNbrRecs(string txtValue, out int nbrRecs)
            {                
                if(!string.IsNullOrEmpty(txtValue)
                    && int.TryParse(txtValue, out nbrRecs)) { return true; }

                nbrRecs = 0;
                return false;
            }

            var recViewItems = lbRecordViews?.ItemsSource.Cast<RecordViewItem>();

            if (recViewItems != null)
            {
                if (TryGetNbrRecs(txtSampleRecs.Text, out int nbrRecs)
                        && nbrRecs > 0)
                {
                    recViewItems.First(i => i.Name == "Record").IsEnabled = true;
                    txtSampleRecsPercent.IsEnabled = true;
                }
                else
                {
                    var item = recViewItems.First(i => i.Name == "Record");
                    item.IsEnabled = false;
                    if (item.IsChecked)
                    {
                        item.IsChecked = false;
                        recViewItems.First(i => i.Name == "Dynamic").IsChecked = true;
                    }

                    txtSampleRecsPercent.IsEnabled = false;
                }
            }
        }

        static private string[] PasswordManagerNames
        {
            get
            {
                try
                {
                    return (string[])typeof(LINQPad.Util).Assembly.GetType("LINQPad.PasswordManager")
                            .GetMethod("GetAllPasswordNames").Invoke(null, null);
                }
                catch (Exception ex)
                {
                    LINQPad.Extensions.Dump(ex, "Exception obtaining LINQPad.PasswordManager.GetAllPasswordNames");
                }
                return null;
            }
        }

        private void cbUsePassMgr_Click(object sender, RoutedEventArgs e)
        {
            //Debugger.Launch ();

            var cb = (CheckBox)sender;
           

            if (cb.IsChecked == true)
            {                
                this.spPassword.IsEnabled = false;
                this.spPassword.Visibility = Visibility.Hidden;
                this.spPasswordNames.IsEnabled = true;
                this.spPasswordNames.Visibility = Visibility.Visible;
            }
            else
            {
                this.spPassword.IsEnabled = true;
                this.spPassword.Visibility = Visibility.Visible;
                this.spPasswordNames.IsEnabled = false;
                this.spPasswordNames.Visibility = Visibility.Hidden;                
            }
        }

        private void cbShowPasswordChars_Checked(object sender, RoutedEventArgs e)
        {
            passwordBox.Visibility = Visibility.Collapsed;
            txtPassword.Visibility = Visibility.Visible;

            txtPassword.Focus();
        }

        private void cbShowPasswordChars_Unchecked(object sender, RoutedEventArgs e)
        {
            txtPassword.Visibility = Visibility.Collapsed;
            passwordBox.Visibility = Visibility.Visible;

            passwordBox.Focus();
        }

        private void cbCldUsePassMgr_Click(object sender, RoutedEventArgs e)
        {
            //Debugger.Launch ();

            var cb = (CheckBox)sender;


            if (cb.IsChecked == true)
            {
                this.spCldPassword.IsEnabled = false;
                this.spCldPassword.Visibility = Visibility.Hidden;
                this.spCldPasswordNames.IsEnabled = true;
                this.spCldPasswordNames.Visibility = Visibility.Visible;
            }
            else
            {
                this.spCldPassword.IsEnabled = true;
                this.spCldPassword.Visibility = Visibility.Visible;
                this.spCldPasswordNames.IsEnabled = false;
                this.spCldPasswordNames.Visibility = Visibility.Hidden;
            }

            var currentTab = (DBPlatforms)this.tcDBType.SelectedIndex;

            if (currentTab == DBPlatforms.Cloud)
            {
                if (CloudDisableBtns())
                {
                    this.btnOK.IsEnabled = false;
                    this.btnTest.IsEnabled = false;
                }
                else
                {
                    this.btnOK.IsEnabled = true;
                    this.btnTest.IsEnabled = true;
                }
            }
        }

        private void cbCldShowPasswordChars_Checked(object sender, RoutedEventArgs e)
        {
            CldpasswordBox.Visibility = Visibility.Collapsed;
            txtCldPassword.Visibility = Visibility.Visible;

            txtCldPassword.Focus();
        }

        private void cbCldShowPasswordChars_Unchecked(object sender, RoutedEventArgs e)
        {
            txtCldPassword.Visibility = Visibility.Collapsed;
            CldpasswordBox.Visibility = Visibility.Visible;

            CldpasswordBox.Focus();
        }

        bool CloudDisableBtns()
        {
            if(string.IsNullOrEmpty(this.txtCldhostName.Text)
                        || string.IsNullOrEmpty(this.txtAPIKey.Text)
                        || string.IsNullOrEmpty(this.txtCldNamespace.Text))
                return true;

            if(this.cbUsePassMgr.IsChecked ?? false)
            {
                if (this.comboCldPasswordNames.SelectedIndex <= 0)
                    return true;
                return false;
            }

            return string.IsNullOrEmpty(this.txtCldPassword.Text)
                            && string.IsNullOrEmpty(this.CldpasswordBox.Password);
        }

        readonly Brush defaultBolderBrush = null;

        void CloudCheckRequiredFlds()
        {
            var currentTab = (DBPlatforms)this.tcDBType.SelectedIndex;

            if (currentTab == DBPlatforms.Cloud)
            {
                if (CloudDisableBtns())
                {
                    if (string.IsNullOrEmpty(this.txtCldhostName.Text))
                    {
                        this.txtCldhostName.BorderBrush = System.Windows.Media.Brushes.Red;
                    }
                    else
                    {
                        this.txtCldhostName.BorderBrush = defaultBolderBrush;
                    }

                    if (string.IsNullOrEmpty(this.txtAPIKey.Text))
                    {
                        this.txtAPIKey.BorderBrush = System.Windows.Media.Brushes.Red;
                    }
                    else
                    {
                        this.txtAPIKey.BorderBrush = defaultBolderBrush;
                    }

                    if (string.IsNullOrEmpty(this.txtCldNamespace.Text))
                    {
                        this.txtCldNamespace.BorderBrush = System.Windows.Media.Brushes.Red;
                    }
                    else
                    {
                        this.txtCldNamespace.BorderBrush = defaultBolderBrush;
                    }

                    if (this.cbUsePassMgr.IsChecked ?? false)
                    {
                        if (this.comboCldPasswordNames.SelectedIndex <= 0)
                        {
                            this.comboCldPasswordNames.BorderBrush = System.Windows.Media.Brushes.Red;
                        }
                        else
                        {
                            this.comboCldPasswordNames.BorderBrush = defaultBolderBrush;
                        }
                    }
                    else
                    {
                        if (string.IsNullOrEmpty(this.txtCldPassword.Text))
                        {
                            this.txtCldPassword.BorderBrush = System.Windows.Media.Brushes.Red;
                        }
                        else
                        {
                            this.txtCldPassword.BorderBrush = defaultBolderBrush;
                        }

                        if (string.IsNullOrEmpty(this.CldpasswordBox.Password))
                        {
                            this.CldpasswordBox.BorderBrush = System.Windows.Media.Brushes.Red;
                        }
                        else
                        {
                            this.CldpasswordBox.BorderBrush = defaultBolderBrush;
                        }
                    }

                    this.btnOK.IsEnabled = false;
                    this.btnTest.IsEnabled = false;
                }
                else
                {
                    this.txtCldhostName.BorderBrush = defaultBolderBrush;
                    this.txtAPIKey.BorderBrush = defaultBolderBrush;
                    this.comboCldPasswordNames.BorderBrush = defaultBolderBrush;
                    this.txtCldPassword.BorderBrush = defaultBolderBrush;
                    this.CldpasswordBox.BorderBrush = defaultBolderBrush;
                    this.txtCldNamespace.BorderBrush = defaultBolderBrush;

                    this.btnOK.IsEnabled = true;
                    this.btnTest.IsEnabled = true;
                }
            }
        }

        DBPlatforms priorTab = DBPlatforms.None;
        
        private void tcDBType_SelectionChanged(object sender, SelectionChangedEventArgs e)
        {
            if (priorTab == DBPlatforms.None) return;

            var tab = (TabControl)sender;            
            var newType = (DBPlatforms)tab.SelectedIndex;

            if (priorTab != newType)
            {                
                DBTypeCache.Save(priorTab, this);                
                DBTypeCache.Update(newType, this, this._connectionProps);
                priorTab = newType;

                if (newType == DBPlatforms.Native)
                {
                    this.cbNetworkCompression.Visibility = Visibility.Visible;
                    this.txtSleepRetries.IsEnabled = true;
                    
                    this.btnOK.IsEnabled = true;
                    this.btnTest.IsEnabled = true;
                }
                else
                {                    
                    this.cbNetworkCompression.Visibility = Visibility.Collapsed;
                    this.txtSleepRetries.IsEnabled = false;
                    
                    CloudCheckRequiredFlds();
                }
            }
        }

        private void txtCloudField_TextChanged(object sender, TextChangedEventArgs e)
        {
            CloudCheckRequiredFlds();
        }

        private void CldpasswordBox_PasswordChanged(object sender, RoutedEventArgs e)
        {
            CloudCheckRequiredFlds();
        }

        private void comboCldPasswordNames_SelectionChanged(object sender, SelectionChangedEventArgs e)
        {
            CloudCheckRequiredFlds();
        }

        private void btnKeyFile_Click(object sender, RoutedEventArgs e)
        {
            var openFileDialog = new OpenFileDialog()
            {
                Filter = "API Key files (*.csv)|*.csv|All files (*.*)|*.*",
                Title = "Select API Key Exported CSV File",
                CheckPathExists = true,
                CheckFileExists = true,
                AddExtension = true
            };

            openFileDialog.DefaultExt = ".csv";
            
            if (openFileDialog.ShowDialog() == true)
            {
                try
                {
                    var fileLine = System.IO.File.ReadAllText(openFileDialog.FileName);
                    var splitLine = fileLine.Split(new char[] { ',', ';' },
                                                    StringSplitOptions.TrimEntries
                                                    | StringSplitOptions.RemoveEmptyEntries);
                    if(splitLine.Length >= 2)
                    { 
                        this._cxInfo.DatabaseInfo.UserName = splitLine[splitLine.Length - 2].Trim(' ', '"');
                        this._cxInfo.DatabaseInfo.Password = splitLine.Last().Trim(' ', '"');
                    }
                    else
                    {
                        txtAPIKey.Text = "<API Key File Selected is not valid>";
                    }
                }
                catch 
                {
                    txtAPIKey.Text = "<API Key File Selection Exception>";
                }
            }
        }
    }

    public class NumericValidationRule : ValidationRule
    {
        public int Min { get; set; } = 0;
        public int Max { get; set; } = int.MaxValue;
        public bool HasPercent { get; set; } = false;
        public bool AllowEmpty { get; set; } = false;

        public override ValidationResult Validate(object value, CultureInfo cultureInfo)
        {
            int nValue;

            if(value  is null) 
            {
                if (AllowEmpty)
                {
                    return new ValidationResult(true, null);
                }
                else
                {
                    return new ValidationResult(false, "Required Field");
                }
            }

            try
            {
                var strValue = ((string)value).Trim(' ');

                if (HasPercent)
                    strValue = strValue.TrimEnd(' ', '%');

                if (strValue.Length > 0)
                {
                    nValue = int.Parse(strValue);
                }
                else if (AllowEmpty)
                {
                    return new ValidationResult(true, null);
                }
                else
                {
                    return new ValidationResult(false, "Required Field");
                }
            }
            catch
            {
                return new ValidationResult(false, "Illegal characters for a Numeric Value");
            }

            if ((nValue < Min) || (nValue > Max))
            {
                if(Min == int.MinValue)
                    return new ValidationResult(false,
                                    $"Please enter a Number <= {Max}.");
                else if(Max == int.MaxValue)
                    return new ValidationResult(false,
                                    $"Please enter a Number >= {Min}.");

                return new ValidationResult(false,
                                    $"Please enter a Numeric Range [{Min} - {Max}].");
            }
            return new ValidationResult(true, null);
        }
    }

    public sealed class WaitCursor : IDisposable
    {
        private readonly Cursor previousCursor;

        public WaitCursor()
        {
            previousCursor = Mouse.OverrideCursor;

            Mouse.OverrideCursor = Cursors.Wait;
        }

        #region IDisposable Members

        public void Dispose()
        {
            Mouse.OverrideCursor = previousCursor;
        }

        #endregion
    }

    public static class PasswordHelper
    {
        public static readonly DependencyProperty PasswordProperty =
            DependencyProperty.RegisterAttached("Password",
            typeof(string), typeof(PasswordHelper),
            new FrameworkPropertyMetadata(string.Empty, OnPasswordPropertyChanged));

        public static readonly DependencyProperty AttachProperty =
            DependencyProperty.RegisterAttached("Attach",
            typeof(bool), typeof(PasswordHelper), new PropertyMetadata(false, Attach));

        private static readonly DependencyProperty IsUpdatingProperty =
           DependencyProperty.RegisterAttached("IsUpdating", typeof(bool),
           typeof(PasswordHelper));


        public static void SetAttach(DependencyObject dp, bool value)
        {
            dp.SetValue(AttachProperty, value);
        }

        public static bool GetAttach(DependencyObject dp)
        {
            return (bool)dp.GetValue(AttachProperty);
        }

        public static string GetPassword(DependencyObject dp)
        {
            return (string)dp.GetValue(PasswordProperty);
        }

        public static void SetPassword(DependencyObject dp, string value)
        {
            dp.SetValue(PasswordProperty, value);
        }
        
        private static bool GetIsUpdating(DependencyObject dp)
        {
            return (bool)dp.GetValue(IsUpdatingProperty);
        }

        private static void SetIsUpdating(DependencyObject dp, bool value)
        {
            dp.SetValue(IsUpdatingProperty, value);
        }

        private static void OnPasswordPropertyChanged(DependencyObject sender,
            DependencyPropertyChangedEventArgs e)
        {
            PasswordBox passwordBox = sender as PasswordBox;
            passwordBox.PasswordChanged -= PasswordChanged;

            if (!(bool)GetIsUpdating(passwordBox))
            {
                passwordBox.Password = (string)e.NewValue;
            }
            passwordBox.PasswordChanged += PasswordChanged;
        }

        private static void Attach(DependencyObject sender,
            DependencyPropertyChangedEventArgs e)
        {           
            if(sender is PasswordBox passwordBox)
            {
                if ((bool)e.OldValue)
                {
                    passwordBox.PasswordChanged -= PasswordChanged;
                }

                if ((bool)e.NewValue)
                {
                    passwordBox.PasswordChanged += PasswordChanged;
                }
            }
        }

        private static void PasswordChanged(object sender, RoutedEventArgs e)
        {
            PasswordBox passwordBox = sender as PasswordBox;
            SetIsUpdating(passwordBox, true);
            SetPassword(passwordBox, passwordBox.Password);
            SetIsUpdating(passwordBox, false);            
        }
    }

    public class DBTypeCache
    {
        static readonly List<DBTypeCache> cache = new();

        public DBPlatforms DBType { get; }
        public string Host { get; private set; }
        public string Port { get; private set; }
        public string UserName { get; private set; }
        public string Password { get; private set; }
        public bool ShowPassword { get; private set; }
        public bool? UsePasswordManager { get; private set; }
        public string PasswordManagerName { get; private set; }
        public string TLSCertName { get; private set; }
        
        private DBTypeCache(DBPlatforms dbType)
        {
            this.DBType = dbType;
        }

        static DBTypeCache DBTypeCacheNative()
            => new DBTypeCache(DBPlatforms.Native)
            {
                Host = "localhost",
                Port = "3000",
                UserName = null,
                Password = null,
                UsePasswordManager = false,
                PasswordManagerName = null,
                ShowPassword = false,
                TLSCertName = null
            };
        static DBTypeCache DBTypeCacheCloud()
            => new DBTypeCache(DBPlatforms.Cloud)
            {
                Host = null,
                Port = "4000",
                UserName = null,
                Password = null,
                UsePasswordManager = false,
                PasswordManagerName = null,               
                ShowPassword = false,
                TLSCertName = null
            };

        internal static bool Update(DBPlatforms dbType, ConnectionDialog dialog, ConnectionProperties props)
        {
            bool result = false;

            var fndDBType = cache.FirstOrDefault(c => c.DBType == dbType);

            if (fndDBType is null)
            {
                switch (dbType)
                {
                    case DBPlatforms.Native:
                        fndDBType = DBTypeCacheNative();
                        break;
                    case DBPlatforms.Cloud:
                        fndDBType = DBTypeCacheCloud();
                        break;
                }
                result = true;
                cache.Add(fndDBType);
            }

            switch(fndDBType.DBType)
            { 
                case DBPlatforms.Native:
                    dialog.txtSeedNodes.Text = fndDBType.Host;
                    dialog.txtPort.Text = fndDBType.Port;
                    dialog.comboPasswordNames.SelectedItem = fndDBType.PasswordManagerName;
                    dialog.cbUsePassMgr.IsChecked = fndDBType.UsePasswordManager;
                    dialog.txtUserName.Text = fndDBType.UserName;
                    dialog.txtPassword.Text = fndDBType.Password;
                    dialog.cbShowPasswordChars.IsChecked = fndDBType.ShowPassword;
                    dialog.txtTLSCertName.Text = fndDBType.TLSCertName;
                    break;
                case DBPlatforms.Cloud:
                    dialog.txtCldhostName.Text = fndDBType.Host;
                    dialog.txtCldPort.Text = fndDBType.Port;
                    dialog.comboCldPasswordNames.SelectedItem = fndDBType.PasswordManagerName;
                    dialog.cbCldUsePassMgr.IsChecked = fndDBType.UsePasswordManager;
                    dialog.txtAPIKey.Text = fndDBType.UserName;
                    dialog.txtCldPassword.Text = fndDBType.Password;
                    dialog.cbCldShowPasswordChars.IsChecked = fndDBType.ShowPassword;
                    break;
            }

            props.ConnectionInfo.DatabaseInfo.Server = fndDBType.Host;
            if(!string.IsNullOrEmpty(fndDBType.Port))
                props.Port = int.Parse(fndDBType.Port);
            props.ConnectionInfo.DatabaseInfo.UserName = fndDBType.UserName;
            props.ConnectionInfo.DatabaseInfo.Password = fndDBType.Password;
            props.UsePasswordManager = fndDBType.UsePasswordManager ?? false;
            props.PasswordManagerName = fndDBType.PasswordManagerName;
            props.TLSCertName = fndDBType.TLSCertName;
            
            return result;
        }

        public static bool Save(DBPlatforms dbType, ConnectionDialog dialog)
        {
            bool result = false;

            var fndDBType = cache.FirstOrDefault(c => c.DBType == dbType);

            if (fndDBType is null)
            {
                fndDBType = new DBTypeCache(dbType);
                result = true;
                cache.Add(fndDBType);
            }

            switch (fndDBType.DBType)
            {
                case DBPlatforms.Native:
                    fndDBType.Host = dialog.txtSeedNodes.Text;
                    fndDBType.Port = dialog.txtPort.Text;
                    fndDBType.PasswordManagerName = (string) dialog.comboPasswordNames.SelectedItem;
                    fndDBType.UsePasswordManager = dialog.cbUsePassMgr.IsChecked;
                    fndDBType.UserName = dialog.txtUserName.Text;
                    fndDBType.Password = dialog.txtPassword.Text;
                    fndDBType.ShowPassword = dialog.cbShowPasswordChars.IsChecked ?? false;
                    break;
                case DBPlatforms.Cloud:
                    fndDBType.Host = dialog.txtCldhostName.Text;
                    fndDBType.Port = dialog.txtCldPort.Text;
                    fndDBType.PasswordManagerName = (string) dialog.comboCldPasswordNames.SelectedItem;
                    fndDBType.UsePasswordManager = dialog.cbCldUsePassMgr.IsChecked;
                    fndDBType.UserName = dialog.txtAPIKey.Text;
                    fndDBType.Password = dialog.txtCldPassword.Text;
                    fndDBType.ShowPassword = dialog.cbCldShowPasswordChars.IsChecked ?? false;                     
                    break;
            }

            return result;
        }

        internal static void Save(ConnectionProperties props)
        {
            var cacheType = new DBTypeCache(props.DBType)
            {
                Host = props.ConnectionInfo.DatabaseInfo.Server,
                Port = props.Port.ToString(),
                UserName = props.ConnectionInfo.DatabaseInfo.UserName,
                Password = props.ConnectionInfo.DatabaseInfo.Password,
                UsePasswordManager = props.UsePasswordManager,
                PasswordManagerName = props.PasswordManagerName,
                TLSCertName = props.TLSCertName                
            };

            cache.Add(cacheType);
        }
    }

}