private void fetchClick(object sender, RoutedEventArgs e) { string dbQuery = "SELECT * FROM " + sensorLocation + " WHERE '" + dayBefore + "' < time" + " and time < '" + dayAfter + "'"; try { JObject parseResults = JObject.Parse(NetworkClass.serverResponse(dbQuery)); JArray jsonArray = (JArray)parseResults.SelectToken("points"); JArray jsonArrayLabels = (JArray)parseResults.SelectToken("columns"); textBoxOut.Text = dbQuery; fetchGraph.RemoveGraph(); fetchGraph.AddData(ref jsonArray, ref jsonArrayLabels); fetchGraph.PlotGraph(); fetchGraph.SetStatistics(true); fetchTime.Text = "Fetch Time: " + DateTime.Now.ToString("yyyy-MM-dd h:mm:ss tt"); //h:mm:ss tt } catch (Exception) { MessageBox.Show("Fetch Error, Try Again"); textBoxOut.Text = dbQuery; } }
private void consoleKeyPressed(object sender, System.Windows.Input.KeyEventArgs e) { if (e.Key.ToString() == "Return") { if (consoleInBox.Text == "clr") { consoleOutBox.Text = ""; consoleInBox.Text = ""; } if (consoleInBox.Text != "") // Processing only non-empty strings { try { consoleOutBox.Text += ">" + consoleInBox.Text.ToUpper() + "\n"; JObject parseResults = JObject.Parse(NetworkClass.serverResponse(consoleInBox.Text)); JArray jsonArray = (JArray)parseResults.SelectToken("columns"); // Saving input for the history reference consoleHistory.Insert(moduloCounter % HISTORY_LIMIT, consoleInBox.Text); moduloCounter++; historyCounter = consoleHistory.Count; // This part of the code properly displays the data in the console window int rowCount = jsonArray.Count; for (int i = 0; i < jsonArray.Count; i++) { if (i == 0) { consoleOutBox.Text += jsonArray[i].ToString() + "\t\t\t"; } else { consoleOutBox.Text += jsonArray[i].ToString() + "\t\t\t"; } } jsonArray = (JArray)parseResults.SelectToken("points"); consoleOutBox.Text += "\n"; for (int i = 0; i < jsonArray.Count; i++) { for (int j = 0; j < rowCount; j++) { if (j == 0) { consoleOutBox.Text += PlottingClass.UnixTimeConverter(Convert.ToDouble(jsonArray[i][j].ToString())).ToString() + "\t\t\t"; } else { consoleOutBox.Text += jsonArray[i][j].ToString() + "\t\t\t"; } } consoleOutBox.Text += "\n"; } consoleOutBox.Text += "\n"; consoleInBox.Text = ""; } catch (Exception) { consoleOutBox.Text += "UNRECOGNIZED COMMAND\n\n"; // Saving input for the history reference consoleHistory.Insert(moduloCounter % HISTORY_LIMIT, consoleInBox.Text); moduloCounter++; historyCounter = consoleHistory.Count; consoleInBox.Text = ""; } } } }