// Update is called once per frame
public int UpdateTimeTaken(float TimeTaken)
{
int statusCode = 0;
try
{
ExperimentalDesignDb expdb = new ExperimentalDesignDb();
Start();
TestSuiteDatabase tsd = new TestSuiteDatabase();
if (tsd.testUpdateTimeTaken(dbConnection, "SELECT COUNT(ID) FROM experimental_results where TimeTaken = 0 ;"))
{
expdb.Update(dbConnection, "UPDATE experimental_results SET TimeTaken='" + TimeTaken + "' WHERE ID IN (SELECT Max(ID) FROM experimental_results);");
statusCode = 200;
}
else
{
statusCode = 400;
}
}
catch (SqliteException sqlEx)
{
statusCode = 400;
Debug.LogError(sqlEx);
}
return(statusCode);
}
public float averagevalue(string yAxisValue, string InputAlgorithmValue, string MazeSizeValue, float Threshold, string SensorTypeValue)
{
ExperimentalDesignDb expdb = new ExperimentalDesignDb();
Start();
TestSuiteDatabase tsd = new TestSuiteDatabase();
tsd.TestSelectValuesfromDB(yAxisValue);
float range = expdb.averagevalue(dbConnection, yAxisValue, InputAlgorithmValue, MazeSizeValue, Threshold, SensorTypeValue);
return(range);
}
