public static List <ExhibitionTest> SelectTempExhibitionTest(bool dbconOpened)
{
openIfNeeded(dbconOpened);
dbcmd.CommandText = "SELECT * FROM " + tableExhibitionTest + " ORDER BY personID";
LogB.SQL(dbcmd.CommandText.ToString());
dbcmd.ExecuteNonQuery();
SqliteDataReader reader = dbcmd.ExecuteReader();
List <ExhibitionTest> l = new List <ExhibitionTest>();
while (reader.Read())
{
ExhibitionTest et = new ExhibitionTest(
Convert.ToInt32(reader[0]), //schoolID
Convert.ToInt32(reader[1]), //groupID
Convert.ToInt32(reader[2]), //personID
(ExhibitionTest.testTypes)Enum.Parse(
typeof(ExhibitionTest.testTypes), reader[3].ToString()), //testType
Convert.ToDouble(Util.ChangeDecimalSeparator(reader[4].ToString())) //result
);
l.Add(et);
}
reader.Close();
closeIfNeeded(dbconOpened);
return(l);
}
//table created with:
//CREATE TABLE exhibitionTest(dt TIMESTAMP DEFAULT CURRENT_TIMESTAMP, schoolID INT NOT NULL, groupID INT NOT NULL, personID INT NOT NULL, testType CHAR(10), result DOUBLE);
public bool UploadExhibitionTest(ExhibitionTest et)
{
// Create a request using a URL that can receive a post.
if (!createWebRequest(requestType.GENERIC, "/uploadExhibitionTestData"))
{
return(false);
}
// Set the Method property of the request to POST.
request.Method = "POST";
// Set the ContentType property of the WebRequest.
request.ContentType = "application/json; Charset=UTF-8"; //but this is not enough, see this line:
//exerciseName = Util.RemoveAccents(exerciseName);
// Creates the json object
JsonObject json = new JsonObject();
json.Add("schoolID", et.schoolID);
json.Add("groupID", et.groupID);
json.Add("personID", et.personID);
json.Add("testType", et.testType.ToString());
json.Add("result", et.resultToJson);
// Converts it to a String
String js = json.ToString();
// Writes the json object into the request dataStream
Stream dataStream;
if (!getWebRequestStream(request, out dataStream, "Could not upload exhibition test data (A)."))
{
return(false);
}
dataStream.Write(Encoding.UTF8.GetBytes(js), 0, js.Length);
dataStream.Close();
// Get the response.
WebResponse response;
if (!getWebResponse(request, out response, "Could not upload exhibition test data (B)."))
{
return(false);
}
// Display the status (will be 202, CREATED)
Console.WriteLine(((HttpWebResponse)response).StatusDescription);
// Clean up the streams.
dataStream.Close();
response.Close();
this.ResultMessage = "Exhibition test data sent.";
return(true);
}
/*
* EXHIBITION //right now does not upload to server when connection returns
*/
public static void UploadExhibitionTest(ExhibitionTest et)
{
Json js = new Json();
if (!js.UploadExhibitionTest(et))
{
LogB.Error(js.ResultMessage);
SqliteJson.InsertTempExhibitionTest(false, et); //insert only if could'nt be uploaded
}
}
public static void InsertTempExhibitionTest(bool dbconOpened, ExhibitionTest et)
{
openIfNeeded(dbconOpened);
dbcmd.CommandText = "INSERT INTO " + tableExhibitionTest +
" (schoolID, groupID, personID, testType, result) VALUES (" +
et.ToSQLTempInsertString() + ")";
LogB.SQL(dbcmd.CommandText.ToString());
dbcmd.ExecuteNonQuery();
closeIfNeeded(dbconOpened);
}
public static void DeleteTempExhibitionTest(bool dbconOpened, ExhibitionTest et, SqliteCommand mycmd)
{
openIfNeeded(dbconOpened);
mycmd.CommandText = "Delete FROM " + tableExhibitionTest + " WHERE " +
"schoolID = " + et.schoolID + " AND " +
"groupID = " + et.groupID + " AND " +
"personID = " + et.personID + " AND " +
"testType = \"" + et.testType.ToString() + "\" AND " +
"result = " + et.resultToJson;
//LogB.SQL(mycmd.CommandText.ToString());
mycmd.ExecuteNonQuery();
closeIfNeeded(dbconOpened);
}
public static void DeleteTempExhibitionTest(bool dbconOpened, ExhibitionTest et)
{
DeleteTempExhibitionTest(dbconOpened, et, dbcmd);
}
