protected void failedTasks()
{
DBC.SQL sql = new DBC.SQL();
DBC.Query.Parallels query = new DBC.Query.Parallels();
DataTable dt = sql.SQLReaderDataTable(query.failedTasks(), "pleskConnectionString");
failedTaskView.DataSource = dt;
failedTaskView.DataBind();
}
public List<Objects.SCOM.AlertRepeat> GetAlertRepeat()
{
DBC.SQL conn = new DBC.SQL();
DBC.Query.SCOMSQL query = new DBC.Query.SCOMSQL();
DataTable dt = conn.SQLReaderDataTable(query.RepeatCount(), "scomConnectionString");
DataSet set = new DataSet();
set.Tables.Add(dt);
List<Objects.SCOM.AlertRepeat> list = new List<Objects.SCOM.AlertRepeat>();
foreach (DataTable table in set.Tables)
{
foreach (DataRow row in table.Rows)
{
Objects.SCOM.AlertRepeat alert = new Objects.SCOM.AlertRepeat();
alert.RepeatCount = int.Parse(row[0].ToString());
alert.AlertStringName = row[1].ToString();
list.Add(alert);
}
}
return list;
}