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