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