protected void GenerateUpdateScript(bool executeScript)
{
string query = GenerateUpdateQuery();
if (query.Length > 0)
{
if (executeScript)
{
string cs = Utility.GetConnectionString(ENV, BU, Period);
try
{
int rc = SqlDA.ExecuteSQLCommand(cs, query);
if (rc >= 1)
{
MessageBox.Show("Calendar updated!");
}
else
{
MessageBox.Show("Failed to update calendar");
}
RefreshData(); // Refresh form data
}
catch (Exception ex)
{
ShowMessage(ex.Message);
}
}
else
{
QueryOutputForm queryForm = new QueryOutputForm(query.ToString());
queryForm.Show();
}
}
else
{
MessageBox.Show("Nothing to update!");
}
}
protected void AbortRun()
{
if (ENV == Utility.ENV.LOCAL)
{
if (SsisRunID > 0)
{
try
{
string envMessage = BU.ToString() + " - " + ENV.ToString() + " - " + Period.ToString();
if (MessageBox.Show("Abort run " + envMessage + " ?", "Abort Run", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
string cs = Utility.GetConnectionString(ENV, BU, Period);
string abortRunQuery = SQLQueries.SQL_ABORT_RUN.Replace("<RunID>", this.SsisRunID.ToString());
int rc = SqlDA.ExecuteSQLCommand(cs, abortRunQuery);
string message = "Run Aborted, " + envMessage;
_toolStripStatusLabel.Text = DateTime.Now.ToString() + ": " + message;
MessageBox.Show(message);
this.Close();
}
}
catch (Exception ex)
{
ShowMessage(ex.Message);
}
}
else
{
_toolStripStatusLabel.Text = DateTime.Now.ToString() + ": No valid SSIS Run ID available";
}
}
else
{
_toolStripStatusLabel.Text = DateTime.Now.ToString() + ": Function only available on local machine";
}
}
