private void Connect_Click(object sender, RoutedEventArgs e) { ConnectionName = ServerName.Text + "." + DatabaseName.SelectedValue; CurrentAuthentication = (SQLAuthenticationType)int.Parse(((ComboBoxItem)Authentication.SelectedItem).Tag.ToString()); if (CurrentAuthentication == SQLAuthenticationType.WindowsAuthentication) { ConnectionString = $"Data Source={ServerName.Text};Initial Catalog={DatabaseName.SelectedValue};Integrated Security=True;Connect Timeout=60;"; } else { ConnectionString = $"Data Source={ServerName.Text};Initial Catalog={DatabaseName.SelectedValue};Integrated Security=False;User Id={UserName.Text};Password={Password.Password};Connect Timeout=60;"; } ManageConnectionData.SaveConnection(_connectionType, new ConnectionData { Authentication = CurrentAuthentication, Password = (RememberPassword.IsChecked ?? true) ? Password.Password : "", RememberPassword = RememberPassword.IsChecked, DatabaseName = DatabaseName.SelectedValue?.ToString(), ServerName = ServerName.Text, UserName = UserName.Text, }); DialogResult = true; }
public ConnectWindow(string connectionType) { _connectionType = connectionType; InitializeComponent(); var data = ManageConnectionData.ReadConnection(_connectionType); if (data != null) { ServerName.Text = data.ServerName ?? DefaultServer; UserName.Text = data.UserName; if (data.Authentication != 0) { Authentication.SelectedIndex = ((int)data.Authentication) - 1; } Password.Password = data.Password; RememberPassword.IsChecked = data.RememberPassword ?? true; DatabaseName.SelectedValue = DatabaseName.Text = data.DatabaseName; } else { ServerName.Text = DefaultServer; //System.Environment.MachineName; } }