private void btnLoadSettings_Click(object sender, EventArgs e) { var settings = ObjectStateManager.Get <UserSettings>(); tbConnectionString1.Text = settings.ConnectionString1; tbConnectionString2.Text = settings.ConnectionString2; tbConnectionString3.Text = settings.ConnectionString3; tbDefaultDeploymentProfile.Text = settings.DefaultProfileName; }
private void btnStartPing_Click(object sender, EventArgs e) { if (pingSqlServerCancellationTokenSource == null) { var settings = ObjectStateManager.Get <UserSettings>(); int frequency = int.Parse(tbPingFrequency.Text); var pollInterval = 60 / frequency; _pingSqlServerLog = new StringBuilder(); pingSqlServerCancellationTokenSource = PingHelper.PingSqlServerTask(settings.ConnectionString3, TimeSpan.FromSeconds(pollInterval), _pingSqlServerLog); btnStartPing.Enabled = false; btnStopPing.Enabled = true; } }
public void SearchConditionsUpdated() { var settings = ObjectStateManager.Get <UserSettings>(); var condition = ObjectStateManager.Get <SearchConditions>(); condition.Search1 = View.Search1; condition.Search2 = View.Search2; condition.SearchValue = View.SearchValue; condition.ConnectionString = View.PreferredConnectionStringName == "AX" ? settings.ConnectionString2 : settings.ConnectionString1; ObjectStateManager.Set(condition); View.SearchQueryText = condition.GetQueryAsDisplayText(); }
public override void InitializeView() { var settings = ObjectStateManager.Get <UserSettings>(); var condition = ObjectStateManager.Get <SearchConditions>(); View.Search1 = condition.Search1; View.Search2 = condition.Search2; //tbSearch2.Text = condition.SearchOnlyInColumnNames; //tbSearch2.Text = condition.SearchOnlyInTableNames; condition.ConnectionString = settings.ConnectionString1; View.PreferredConnectionStringName = "AX"; View.Search2Enabled = !string.IsNullOrWhiteSpace(condition.Search2); View.SearchByValueEnabled = !string.IsNullOrWhiteSpace(condition.SearchValue); View.SearchQueryText = condition.GetQueryAsDisplayText(); }
private void btnSaveSettings_Click(object sender, EventArgs e) { var coll = ObjectStateManager.Get <ProfilesCollection>(); string defaultProfile = tbDefaultDeploymentProfile.Text; if (!string.IsNullOrWhiteSpace(defaultProfile) && !coll.Any(p => p.ProfileName == defaultProfile)) { defaultProfile = String.Empty; MessageBox.Show("Deployment profile [" + tbDefaultDeploymentProfile.Text + "] doesn't exist"); } var settings = new UserSettings { ConnectionString1 = tbConnectionString1.Text, ConnectionString2 = tbConnectionString2.Text, ConnectionString3 = tbConnectionString3.Text, DefaultProfileName = defaultProfile }; ObjectStateManager.Set(settings); }
private void backgroundWorker1_DoWork(object sender, DoWorkEventArgs e) { try { var cmdtext = tbPreviewDataQueryText.Text; var condition = ObjectStateManager.Get <SearchConditions>(); using (var conn = new SqlConnection(condition.ConnectionString)) { conn.Open(); SqlCommand cmd = new SqlCommand(cmdtext, conn); var adapter = new SqlDataAdapter(cmd); DataSet ds = new DataSet(); adapter.Fill(ds); e.Result = ds; } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void btnExecuteQuery_Click(object sender, EventArgs e) { try { var condition = ObjectStateManager.Get <SearchConditions>(); using (SqlConnection conn = new SqlConnection(condition.ConnectionString)) { conn.Open(); SqlCommand cmd = new SqlCommand(condition.GetQuery(), conn); var adapter = new SqlDataAdapter(cmd); DataSet ds = new DataSet(); adapter.Fill(ds); // dataTable_InformationSchema = ds.Tables[0]; dataGridView.DataSource = ds.Tables[0]; tabControl1.SelectedIndex = 2; } } catch (Exception ex) { MessageBox.Show(ex.Message); } }