Exemple #1
0
        private void dateTimePicker1_DateChanged(object sender, EventArgs e)
        {
            string    a       = dateTimePicker1.Value.ToString("yyyy-MM-dd");
            TmpAndHmd paivita = new TmpAndHmd();

            SetTmpAndHmd2($"SELECT paivamaara, aika, lampotila, ilmankosteus FROM weather  WHERE paivamaara LIKE '{a}%' ");
            paivita.SetTmpAndHmd($"SELECT AVG (lampotila) AS lampotila, AVG (ilmankosteus) AS ilmankosteus FROM weather WHERE paivamaara LIKE '{a}%' ");
            lampotilaAvgFromDate.Text    = paivita.GetTmp() + "°C";
            ilmankosteusAvgFromDate.Text = paivita.GetHmd() + "%";
            foreach (var series in lampotilaChart.Series)
            {
                series.Points.Clear();
            }
            SetTmpAndHmdGraph($"SELECT * FROM weather  WHERE paivamaara LIKE '{a}%' ");
        }
Exemple #2
0
        private void Button1_Click_1(object sender, EventArgs e)
        {
            TmpAndHmd paivita = new TmpAndHmd();

            paivita.SetTmpAndHmd("SELECT lampotila, ilmankosteus FROM weather WHERE DATE(paivamaara) = CURDATE()");
            if (paivita.GetVar() == 0)
            {
                lampotila.Text    = paivita.GetTmp() + "°C";
                ilmankosteus.Text = paivita.GetHmd() + "%";
                paivita.SetTmpAndHmd("SELECT AVG (lampotila) AS lampotila, AVG (ilmankosteus) AS ilmankosteus FROM weather WHERE DATE(paivamaara) = CURDATE()");
                lampotilaAvg.Text    = paivita.GetTmp() + "°C";
                ilmankosteusAvg.Text = paivita.GetHmd() + "%";
            }

            else
            {
                MessageBox.Show("NoData");
            }
        }
Exemple #3
0
        private void Form1_Load(object sender, EventArgs e)
        {
            TmpAndHmd paivita = new TmpAndHmd();

            paivita.SetTmpAndHmd("SELECT lampotila, ilmankosteus FROM weather WHERE DATE(paivamaara) = CURDATE() ORDER BY idweather");// DESC LIMIT 1");
            if (paivita.GetVar() == 0)
            {
                lampotila.Text    = paivita.GetTmp() + "°C";
                ilmankosteus.Text = paivita.GetHmd() + "%";
                paivita.SetTmpAndHmd("SELECT AVG (lampotila) AS lampotila, AVG (ilmankosteus) AS ilmankosteus FROM weather WHERE DATE(paivamaara) = CURDATE()");
                lampotilaAvg.Text    = paivita.GetTmp() + "°C";
                ilmankosteusAvg.Text = paivita.GetHmd() + "%";
                paivita.SetTmpAndHmd($"SELECT AVG (lampotila) AS lampotila, AVG (ilmankosteus) AS ilmankosteus FROM weather WHERE DATE(paivamaara) = CURDATE()");
                lampotilaAvgFromDate.Text    = paivita.GetTmp() + "°C";
                ilmankosteusAvgFromDate.Text = paivita.GetHmd() + "%";
                SetTmpAndHmd2($"SELECT paivamaara, aika, lampotila, ilmankosteus FROM weather  WHERE DATE(paivamaara) = CURDATE()");
                SetTmpAndHmdGraph($"SELECT * FROM weather  WHERE  DATE(paivamaara) = CURDATE()");
            }
            else
            {
                MessageBox.Show("No Data.");
            }
        }