// 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 int UpdatePointsScored(float PointsScored)
{
int statusCode = 0;
try
{
ExperimentalDesignDb expdb = new ExperimentalDesignDb();
Start();
expdb.Update(dbConnection, "UPDATE experimental_results SET PointsScored='" + PointsScored + "' WHERE ID IN (SELECT Max(ID) FROM experimental_results);");
statusCode = 200;
}
catch (SqliteException sqlEx)
{
statusCode = 400;
Debug.LogError(sqlEx);
}
return(statusCode);
}
public int UpdateMaze(int[,] updatedMaze)
{
int statusCode = 0;
Dictionary <string, string> value = new Dictionary <string, string>();
try
{
string str = "'";
for (int i = 0; i <= updatedMaze.GetUpperBound(0); i++)
{
str += "";
for (int j = 0; j <= updatedMaze.GetUpperBound(1); j++)
{
str += updatedMaze[i, j];
if (j != updatedMaze.GetUpperBound(1))
{
str += ",";
}
}
str += "";
if (i != updatedMaze.GetUpperBound(0))
{
str += ";";
}
}
str += "'";
ExperimentalDesignDb expdb = new ExperimentalDesignDb();
Start();
expdb.Update(dbConnection, "UPDATE experimental_results SET PathCovered=" + str + " WHERE ID IN (SELECT Max(ID) FROM experimental_results);");
statusCode = 200;
}
catch (SqliteException sqlEx)
{
Debug.LogError(sqlEx);
statusCode = 400;
}
return(statusCode);
}