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