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;
}
}
