protected Guid createUser(string name, int allowedtime) { DBC.SQL sql = new DBC.SQL(); var id = testDrop.SelectedItem.Value; int testID = int.Parse(testDrop.SelectedItem.Value.ToString()); Guid gu = sql.createCandidate(name, testID, allowedtime); return gu; }
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(); }
protected List<test> GetTests() { DBC.SQL sql = new DBC.SQL(); DataTable DT = sql.GetTests(); List<test> list = new List<test>(); foreach (DataRow r in DT.Rows) { test testObject = new test(); testObject.name = r["Name"].ToString(); testObject.id = int.Parse(r["TestID"].ToString()); list.Add(testObject); } return list; }
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; }