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