using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.DataVisualization.Charting;
using System.Web.UI.WebControls;

public partial class _Default : Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        
 Chart1.ChartAreas[0].AxisY.Interval = 10;

        Chart1.ChartAreas[0].AxisY.LabelStyle.Format = "{0}°C"; 
        Chart1.ChartAreas[0].AxisX.LabelStyle.Format = "yyyy-MM-dd HH:mm";
        Chart1.ChartAreas[0].AxisX.LabelStyle.Angle = 30;
        if (DropDownList1.SelectedValue.ToString() == "-24")
        {
            Chart1.ChartAreas[0].AxisX.IntervalType = DateTimeIntervalType.Hours;
            Chart1.ChartAreas[0].AxisX.Interval = 1;

        }

      

        var dataview = (DataView)SqlDataSource2.Select(DataSourceSelectArguments.Empty);
        foreach (DataRowView dataviewrow in dataview)
        {
            lblpumpstarts.Text = "Pump Starts: " + dataviewrow["stopstarts"].ToString();
        }

        var dataview1 = (DataView)SqlDataSource3.Select(DataSourceSelectArguments.Empty);
        foreach (DataRowView dataviewrow1 in dataview1)
        {
            lblvalveopens.Text = "Valve Opens: " + dataviewrow1["valveopen"].ToString();

        }

        DateTime stoptime = DateTime.Now;
        DateTime starttime = DateTime.Now;
        int totalminutes = 0;
        string state = null;
        var dataview3 = (DataView)SqlDataSource4.Select(DataSourceSelectArguments.Empty);
        foreach (DataRowView dataviewrow3 in dataview3)
        {

            {
                if (dataviewrow3["Compressor_is"].ToString() != "0")
                {
                    starttime = Convert.ToDateTime(dataviewrow3["timestamp"]);
                    state = "started";
                    lbllastupdate.Text = "Last update:" + dataviewrow3["timestamp"].ToString();

                }
                else
                {

                    if (state != null)
                    {
                        stoptime = Convert.ToDateTime(dataviewrow3["timestamp"]);
                        TimeSpan runtime = stoptime.Subtract(starttime);
                        state = null;
                        totalminutes = totalminutes + Convert.ToInt32(runtime.TotalMinutes) ;
                        lbllastupdate.Text = "Last update: " + dataviewrow3["timestamp"].ToString();

                    }

                }
            }

        }

        //  Response.Write(totalminutes / 60);
        //    Response.Write(SqlDataSource4.SelectCommand.ToString());
        lblcomptime.Text = "Compressor time: " + totalminutes / 60 + " hours";
    }
}