private List<MatrixTestResult> GetPerformanceMatrixResults(GetPerformanceResultsFilter filter)
{
List<MatrixTestResult> matrixResults = new List<MatrixTestResult>();
System.Data.Odbc.OdbcConnection conn = createSQLConnection();
try
{
string mySelectQuery;
switch (filter)
{
case GetPerformanceResultsFilter.MonoTouch:
mySelectQuery = "SELECT * FROM `PerformanceMatrixTestResults` WHERE `isMonoTouch` = 1 ORDER BY `DBDeviceId` ASC";
break;
case GetPerformanceResultsFilter.ObjectiveC:
mySelectQuery = "SELECT * FROM `PerformanceMatrixTestResults` WHERE `isMonoTouch` = 0 ORDER BY `DBDeviceId` ASC";
break;
default:
mySelectQuery = "SELECT * FROM `PerformanceMatrixTestResults` ORDER BY `PerformanceMatrixTestResults`.`DBDeviceId` ASC";
break;
}
System.Data.Odbc.OdbcCommand myCommand = new System.Data.Odbc.OdbcCommand(mySelectQuery, conn);
conn.Open();
System.Data.Odbc.OdbcDataReader myReader = myCommand.ExecuteReader();
try
{
while (myReader.Read())
{
matrixResults.Add(new MatrixTestResult()
{
DatabaseId = (int)myReader["id"],
DeviceDatabaseId = (int)myReader["DBDeviceId"],
CSTestResult = (float)myReader["CSTestResult"],
CTestResult = (float)myReader["CTestResult"],
BLASTestResult = (float)myReader["BLASTestResult"],
IsMonoTouch = Convert.ToBoolean(myReader["isMonoTouch"])
});
}
}
finally
{
myReader.Close();
}
}
finally
{
conn.Close();
}
return matrixResults;
}
private List<PerformanceCubeResult> GetPerformanceCubeResults(GetPerformanceResultsFilter filter)
{
List<PerformanceCubeResult> cubeResults = new List<PerformanceCubeResult>();
System.Data.Odbc.OdbcConnection conn = createSQLConnection();
try
{
//
string mySelectQuery;
switch (filter)
{
case GetPerformanceResultsFilter.MonoTouch:
mySelectQuery = "SELECT * FROM `PerformanceGLCubeResults` WHERE `isMonoTouch` = 1 ORDER BY `DBDeviceId` ASC";
break;
case GetPerformanceResultsFilter.ObjectiveC:
mySelectQuery = "SELECT * FROM `PerformanceGLCubeResults` WHERE `isMonoTouch` = 0 ORDER BY `DBDeviceId` ASC";
break;
default:
mySelectQuery = "SELECT * FROM `PerformanceGLCubeResults` ORDER BY `PerformanceGLCubeResults`.`DBDeviceId` ASC";
break;
}
System.Data.Odbc.OdbcCommand myCommand = new System.Data.Odbc.OdbcCommand(mySelectQuery, conn);
conn.Open();
System.Data.Odbc.OdbcDataReader myReader = myCommand.ExecuteReader();
try
{
while (myReader.Read())
{
cubeResults.Add(new PerformanceCubeResult()
{
DatabaseId = (int)myReader["id"],
DeviceDatabaseId = (int)myReader["DBDeviceId"],
NumberOfTriangles = (int)myReader["NumberTriangles"],
FramesPerSecond = (double)myReader["FramesPerSecond"],
IsMonoTouch = Convert.ToBoolean(myReader["isMonoTouch"])
});
}
}
finally
{
myReader.Close();
}
}
finally
{
conn.Close();
}
return cubeResults;
}