private void Connect(object obj) { ConnectionSettingsContainer settings = obj as ConnectionSettingsContainer; if (settings != null) { AuthenticationType authentication = AuthenticationType.Windows; if (settings.IsSimple) { authentication = AuthenticationType.SQLServer; } Invoke(new eventInvoker(OnConnecting)); string message; if (ConnectionManager.Connect(settings.ServerName, settings.Username, settings.Password, authentication, out message)) { Invoke(new eventInvoker(OnConnected)); } else { Invoke(new failureEventInvoker(OnFailed), new object[1] { message }); } } else { Invoke(new failureEventInvoker(OnFailed), new object[1] { "Wrong connection parameters" }); } }
private void buttonConnect_Click(object sender, EventArgs e) { ConnectionSettingsContainer settings = new ConnectionSettingsContainer(comboBoxServerName.Text, textBoxLogin.Text, textBoxPassword.Text, isSimple); connectionThread = new Thread(Connect); connectionThread.Start(settings); }
private void StartConnection() { ConnectionSettingsContainer settings = new ConnectionSettingsContainer(comboBoxServerName.Text, textBoxLogin.Text, textBoxPassword.Text, isSimple); connectionThread = new Thread(Connect); connectionThread.Start(settings); }
private void StartConnection() { var serverName = comboBoxServerName.Text; Init(_settings.ConnectionStrings[serverName]); var settings = new ConnectionSettingsContainer(_settings.ConnectionStrings[serverName].Connection, textBoxLogin.Text, textBoxPassword.Text, _isSimple); ConnectionAction(settings, serverName); }
private void StartConnection() { string serverName; #if DemoDebug serverName = "91.213.233.139,1433\\MSSQLSERVER@CASDBTest"; #else serverName = comboBoxServerName.Text; #endif var settings = new ConnectionSettingsContainer(_settings.ConnectionStrings[serverName], textBoxLogin.Text, textBoxPassword.Text, _isSimple); Connect(settings); //connectionThread = new Thread(Connect); //connectionThread.Start(settings); }
private void ConnectionAction(ConnectionSettingsContainer settings, string serverName) { if (settings != null) { OnConnecting(); try { if (_isCAA) { GlobalObjects.CaaEnvironment.Connect(settings.ServerName, settings.Username, settings.Password, ""); } else { GlobalObjects.CasEnvironment.Connect(settings.ServerName, settings.Username, settings.Password, ""); } SaveJsonSetting(settings.Username, serverName); } catch (ConnectionFailureException ex) { if (ex.InnerException != null) { var sqlException = ex.InnerException as SqlException; if (sqlException != null) { MessageBox.Show(sqlException.Message, "Failed to connect server", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { MessageBox.Show("Server was not found or is not available", "Failed to connect server", MessageBoxButtons.OK, MessageBoxIcon.Error); } } else { MessageBox.Show("Server was not found or is not available", "Failed to connect server", MessageBoxButtons.OK, MessageBoxIcon.Error); } return; } catch (Exception ex) { MessageBox.Show(ex.Message, "Failed to connect server", MessageBoxButtons.OK, MessageBoxIcon.Error); SetEnabled(true, _isSimple); _connectionStatus = ConnectionState.Closed; buttonExit.Text = "Exit"; return; } //нажатие клавиши Enter buttonExit.Enabled = false; _loadForm.Show(); backgroundWorker.RunWorkerAsync(); } else { OnFailed("Wrong connection parameters"); //Invoke(new failureEventInvoker(OnFailed), new object[] { "Wrong connection parameters" }); } }
private void ConnectionAction(Object obj) { ConnectionSettingsContainer settings = obj as ConnectionSettingsContainer; if (settings != null) { AuthenticationType authentication = AuthenticationType.Windows; if (settings.IsSimple) { authentication = AuthenticationType.SqlServer; } OnConnecting(); string message; //if (settings.ServerName.Split('@').Length >= 2) //{ // string serverName = settings.ServerName.Split('@')[0]; // string baseName = settings.ServerName.Split('@')[1]; try { //GlobalObjects.CasEnvironment.Connect(serverName, settings.Username, settings.Password, baseName); GlobalObjects.CasEnvironment.Connect(settings.ServerName, settings.Username, settings.Password, ""); SaveJsonSetting(settings.Username); } catch (ConnectionFailureException ex) { if (ex.InnerException != null) { SqlException sqlException = ex.InnerException as SqlException; if (sqlException != null) { MessageBox.Show(sqlException.Message, "Failed to connect server", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { MessageBox.Show("Server was not found or is not available", "Failed to connect server", MessageBoxButtons.OK, MessageBoxIcon.Error); } } else { MessageBox.Show("Server was not found or is not available", "Failed to connect server", MessageBoxButtons.OK, MessageBoxIcon.Error); } return; } catch (Exception ex) { MessageBox.Show(ex.Message, "Failed to connect server", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } //нажатие клавиши Enter buttonExit.Enabled = false; _loadForm.Show(); backgroundWorker.RunWorkerAsync(); } else { OnFailed("Wrong connection parameters"); //Invoke(new failureEventInvoker(OnFailed), new object[] { "Wrong connection parameters" }); } }