Exemplo n.º 1
0
        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;
            }
        }
Exemplo n.º 2
0
        private void importClick(object sender, RoutedEventArgs e)
        {
            string        initialData = "";
            List <double> rawData     = new List <double>();
            PlottingClass importGraph = new PlottingClass(this);

            // Open dialog menu
            OpenFileDialog openFileDialog = new OpenFileDialog();

            openFileDialog.Filter = "WeatherSpot files (*.ws)|*.ws";

            // User successfully opened a file
            if (openFileDialog.ShowDialog() == true)
            {
                importGraph.RemoveGraph();
                initialData = File.ReadAllText(openFileDialog.FileName);
                string[] stringTokens = initialData.Split(';');

                for (int i = 0; i < stringTokens.Length; i++)
                {
                    initialData = stringTokens[i];
                    if (i % 5 == 0)
                    {
                        importGraph.AddX(Convert.ToDouble(initialData));
                    }
                    if (i % 5 == 1)
                    {
                        importGraph.AddY(Convert.ToDouble(initialData));
                    }
                    if (i % 5 == 2)
                    {
                        importGraph.AddYhum(Convert.ToDouble(initialData));
                    }
                    if (i % 5 == 3)
                    {
                        importGraph.AddYpress(Convert.ToDouble(initialData));
                    }
                    if (i % 5 == 4)
                    {
                        importGraph.AddYlight(Convert.ToDouble(initialData));
                    }
                }

                importGraph.PlotGraph();
                importGraph.SetStatistics(true);
                fetchTime.Text = "Data Imported";
            }
        }
Exemplo n.º 3
0
        private void importClick(object sender, RoutedEventArgs e)
        {
            string initialData = "";
            List<double> rawData = new List<double>();
            PlottingClass importGraph = new PlottingClass(this);

            // Open dialog menu
            OpenFileDialog openFileDialog = new OpenFileDialog();
            openFileDialog.Filter = "WeatherSpot files (*.ws)|*.ws";

            // User successfully opened a file
            if (openFileDialog.ShowDialog() == true)
            {
                importGraph.RemoveGraph();
                initialData =  File.ReadAllText(openFileDialog.FileName);
                string[] stringTokens = initialData.Split(';');

                for (int i = 0; i < stringTokens.Length; i++)
                {
                    initialData = stringTokens[i];
                    if (i % 5 == 0)
                    {
                        importGraph.AddX(Convert.ToDouble(initialData));
                    }
                    if (i % 5 == 1)
                    {
                        importGraph.AddY(Convert.ToDouble(initialData));
                    }
                    if (i % 5 == 2)
                    {
                        importGraph.AddYhum(Convert.ToDouble(initialData));
                    }
                    if (i % 5 == 3)
                    {
                        importGraph.AddYpress(Convert.ToDouble(initialData));
                    }
                    if (i % 5 == 4)
                    {
                        importGraph.AddYlight(Convert.ToDouble(initialData));
                    }
                }

                importGraph.PlotGraph();
                importGraph.SetStatistics(true);
                fetchTime.Text = "Data Imported";
            }
        }