private void DeployButton_Click(object sender, EventArgs e)
{
var servers = new Dictionary <string, string>()
{
{ "Development", "dev-ifsql" },
{ "Testing", "tst-sql" },
{ "Pilot", "tst-sql" },
{ "Production", "inbasqlclus001" }
};
SPTextBox.Text = "Preparing to deploy...";
SPTextBox.Text += "\r\nDeploying to:\r\n";
foreach (var environment in GetEnvironments())
{
foreach (var site in GetSites())
{
var server = servers[environment];
SPTextBox.Text += "\r\n" + environment + " (" + server + ") " + site;
Deploy(server, site + "_App", SPSQL.ToString());
SPTextBox.SelectionStart = SPTextBox.TextLength;
SPTextBox.ScrollToCaret();
SPTextBox.Refresh();
}
}
if (SPTextBox.Tag != null && string.IsNullOrEmpty(SPTextBox.Tag.ToString()))
{
SPTextBox.Text += "\r\nDeployment successful";
}
SPTextBox.Text += "\r\nDeployment complete.";
SPTextBox.Tag = string.Empty;
}
private void RenderVMState()
{
if (_vm != null)
{
IPTextBox.Invoke((Action) delegate { IPTextBox.Text = _vm.InstructionPointer.ToString("X"); });
SPTextBox.Invoke((Action) delegate { SPTextBox.Text = _vm.StackPointer.ToString("X"); });
if (_vm.StackPointer > 0)
{
var topOfStackVal = _vm.Memory[_vm.StackPointer - 1];
if (_lastStackPointer != _vm.StackPointer || _lastTopOfStackVal != topOfStackVal)
{
_lastStackPointer = _vm.StackPointer;
_lastTopOfStackVal = topOfStackVal;
var stackList = new string[_vm.StackPointer];
for (var i = 0; i < _vm.StackPointer; i++)
{
stackList[i] = _vm.Memory[i + 1].ToString("X");
}
StackListBox.Invoke((Action) delegate { StackListBox.DataSource = stackList; });
}
}
}
}
private void checkBox1_CheckedChanged(object sender, EventArgs e)
{
this.Cursor = Cursors.WaitCursor;
var cond = AllProceduresCheckbox.Checked;
SPTextBox.Enabled = cond;
SPTextBox.Text = "Generating script...";
SPTextBox.Refresh();
SPList.Text = string.Empty;
SPList.Enabled = !cond;
EnvironmentsGroup.Enabled = cond;
SitesGroup.Enabled = cond;
BrowseButton.Enabled = cond;
if (!AllProceduresCheckbox.Checked)
{
SPSQL.Clear();
procedures.Clear();
SPTextBox.Enabled = false;
SPTextBox.Text = string.Empty;
this.Cursor = Cursors.Default;
return;
}
var connectionString = @"Server=" + server + ";Initial Catalog=" + database + ";Integrated Security=SSPI";
procedures.Clear();
using (var conn = new SqlConnection(connectionString))
{
try
{
conn.Open();
var sql = @"
SELECT ROUTINE_NAME, ROUTINE_DEFINITION
FROM information_schema.routines
WHERE routine_type = 'PROCEDURE' AND ROUTINE_NAME LIKE 'fe_%'
ORDER BY ROUTINE_NAME ASC;";
using (var cmd = new SqlCommand(sql, conn))
{
using (var result = cmd.ExecuteReader())
{
if (result.HasRows)
{
while (result.Read())
{
procedures.Add(result["ROUTINE_NAME"].ToString());
}
}
result.Close();
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
conn.Close();
}
}
SPSQL = BuildSPSQL();
SPTextBox.Text = SPSQL.ToString();
this.Cursor = Cursors.Default;
}
