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