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