public static List <UploadSprintDataObject> SelectTempSprint(bool dbconOpened)
{
openIfNeeded(dbconOpened);
dbcmd.CommandText = "SELECT * FROM " + tableSprint + " ORDER BY uniqueID";
LogB.SQL(dbcmd.CommandText.ToString());
dbcmd.ExecuteNonQuery();
SqliteDataReader reader = dbcmd.ExecuteReader();
List <UploadSprintDataObject> l = new List <UploadSprintDataObject>();
while (reader.Read())
{
UploadSprintDataObject o = new UploadSprintDataObject(
Convert.ToInt32(reader[0]), //uniqueID
Convert.ToInt32(reader[1]), //personID
reader[2].ToString(), //sprintPositions
UploadSprintDataObject.SplitTimesStringToList(reader[3].ToString()), //splitTimes
Convert.ToDouble(Util.ChangeDecimalSeparator(reader[4].ToString())), //k
Convert.ToDouble(Util.ChangeDecimalSeparator(reader[5].ToString())), //vmax
Convert.ToDouble(Util.ChangeDecimalSeparator(reader[6].ToString())), //amax
Convert.ToDouble(Util.ChangeDecimalSeparator(reader[7].ToString())), //fmax
Convert.ToDouble(Util.ChangeDecimalSeparator(reader[8].ToString())) //pmax
);
l.Add(o);
}
reader.Close();
closeIfNeeded(dbconOpened);
return(l);
}
public static void InsertTempSprint(bool dbconOpened, UploadSprintDataObject o)
{
openIfNeeded(dbconOpened);
dbcmd.CommandText = "INSERT INTO " + tableSprint +
" (uniqueID, personID, sprintPositions, splitTimes, " +
" k, vmax, amax, fmax, pmax) VALUES (" +
o.ToSQLInsertString();
LogB.SQL(dbcmd.CommandText.ToString());
dbcmd.ExecuteNonQuery();
closeIfNeeded(dbconOpened);
}
/*
* Unused, now using the above methods
*
* public EncoderExercise GetEncoderExercise(int exerciseId)
* {
* EncoderExercise ex = new EncoderExercise();
*
* // Create a request using a URL that can receive a post.
* WebRequest request = WebRequest.Create (serverUrl + "/getEncoderExercise");
*
* // 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:
*
* // Creates the json object
* JsonObject json = new JsonObject();
* json.Add("exerciseId", exerciseId);
*
* // Converts it to a String
* String js = json.ToString();
*
* // Writes the json object into the request dataStream
* Stream dataStream;
* try {
* dataStream = request.GetRequestStream ();
* } catch {
* this.ResultMessage =
* string.Format(Catalog.GetString("You are not connected to the Internet\nor {0} server is down."),
* serverUrl);
* return ex;
* }
*
* dataStream.Write (Encoding.UTF8.GetBytes(js), 0, js.Length);
*
* dataStream.Close ();
*
* HttpWebResponse response;
* try {
* response = (HttpWebResponse) request.GetResponse();
* } catch {
* this.ResultMessage =
* string.Format(Catalog.GetString("You are not connected to the Internet\nor {0} server is down."),
* serverUrl);
* return ex;
* }
*
* string responseFromServer;
* using (var sr = new StreamReader(response.GetResponseStream()))
* {
* responseFromServer = sr.ReadToEnd();
* }
*
* LogB.Information("GetEncoderExercise: " + responseFromServer);
*
* if(responseFromServer == "")
* LogB.Information(" Empty "); //never happens
* else if(responseFromServer == "[]")
* LogB.Information(" Empty2 "); //when rfid is not on server
* else {
* ex = encoderExerciseDeserialize(responseFromServer);
* }
*
* return ex;
* }
* private EncoderExercise encoderExerciseDeserialize(string str)
* {
* JsonValue jsonEx = JsonValue.Parse(str);
*
* Int32 id = jsonEx ["id"];
* string name = jsonEx ["name"];
* Int32 stationId = jsonEx ["stationId"];
* int percentBodyMassDisplaced = jsonEx ["percentBodyMassDisplaced"];
*
* return new EncoderExercise(id, name, percentBodyMassDisplaced,
* "", "", 0); //ressitance, description, speed1RM
* }
*/
public bool UploadSprintData(UploadSprintDataObject o)
{
LogB.Information("calling upload sprint");
// Create a request using a URL that can receive a post.
if (!createWebRequest(requestType.GENERIC, "/uploadSprintData"))
{
return(false);
}
/*
* LogB.Information("UploadSprintData doubles:");
* foreach(double d in splitTimesL)
* LogB.Information(d.ToString());
*/
// 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("personId", o.personId);
json.Add("distances", o.sprintPositions);
json.Add("t1", o.splitTimesL[1]);
//splitTimesL starts with a 0 that is not passed
if (o.splitTimesL.Count >= 3)
{
json.Add("t2", o.splitTimesL[2] - o.splitTimesL[1]); //return lap (partial time) and not split (accumulated time)
}
else
{
json.Add("t2", "");
}
if (o.splitTimesL.Count >= 4)
{
json.Add("t3", o.splitTimesL[3] - o.splitTimesL[2]);
}
else
{
json.Add("t3", "");
}
if (o.splitTimesL.Count >= 5)
{
json.Add("t4", o.splitTimesL[4] - o.splitTimesL[3]);
}
else
{
json.Add("t4", "");
}
json.Add("k", o.k);
json.Add("vmax", o.vmax);
json.Add("amax", o.amax);
json.Add("fmax", o.fmax);
json.Add("pmax", o.pmax);
// Converts it to a String
String js = json.ToString();
// Writes the json object into the request dataStream
Stream dataStream;
if (!getWebRequestStream(request, out dataStream, Catalog.GetString("Could not upload sprint data.")))
{
return(false);
}
dataStream.Write(Encoding.UTF8.GetBytes(js), 0, js.Length);
dataStream.Close();
// Get the response.
WebResponse response;
if (!getWebResponse(request, out response, Catalog.GetString("Could not upload sprint data.")))
{
return(false);
}
// Display the status (will be 202, CREATED)
Console.WriteLine(((HttpWebResponse)response).StatusDescription);
// Clean up the streams.
dataStream.Close();
response.Close();
this.ResultMessage = "Sprint data sent.";
return(true);
}
