public override void Refresh()
{
string cs = Utility.GetConnectionString(ENV, BU, Period, false);
string query = SQLQueries.SQL_LATEST_SSIS_MESSAGES.Replace("<RunID>", SsisRunID.ToString());
//if (_sortAsc == false)
// query += " order by LogId desc";
try
{
DataSet dsSSISLog = SqlDA.GetQueryDataSet(cs, query, false);
dgvSSISLog.DataSource = dsSSISLog.Tables[0];
dgvSSISLog.Refresh();
// Show last refresh in toolstripstatuslabel
toolStripStatusLabel1.Text = "Last Refreshed: " + DateTime.Now.ToString();
}
catch (Exception e)
{
throw e;
}
}
public TroublehsootingForm(Utility.ENV env, Utility.BU bu, Utility.PERIOD period, DateTime kalenderDatum, int ILRunID, Int64 ssisRunID)
{
InitializeComponent();
Init(env, bu, period, ILRunID, ssisRunID, kalenderDatum);
// Get Failure Details
string cs = Utility.GetConnectionString(ENV, BU, Period, false);
DataSet dsFailureDetails = SqlDA.GetQueryDataSet(cs, SQLQueries.SQL_RUN_FAILURES.Replace("<RunID>", ILRunID.ToString()), false);
dgvFailureDetails.DataSource = dsFailureDetails.Tables[0];
dgvFailureDetails.Refresh();
// Get SSIS Errors
DataSet dsFSSISErrors = SqlDA.GetQueryDataSet(cs, SQLQueries.SQL_SSIS_ERRORS.Replace("<RunID>", SsisRunID.ToString()), false);
dgvSSISErrors.DataSource = dsFSSISErrors.Tables[0];
dgvSSISErrors.Refresh();
}
