private void loadChart3()
        {
            //chart 3
            string sqlQuery3 = (@"SELECT *
                                FROM
                                (
                                    SELECT[pitchno],
                                           [pitcher],
                                           [pitcherset]
                                    FROM[dbo].[pitchData]
                                    WHERE pitchtype = 'Fastball'
                                ) AS SourceTable PIVOT(COUNT([pitchno]) FOR [pitcherset] IN ([Stretch], [Windup])) AS PivotTable;");

            DataTable ChartData3 = SqlQueryExecute(sqlQuery3);


            DataView dv = new DataView(ChartData3);

            Chart3.DataSource = dv;
            Chart3.DataBind();

            foreach (Series cs in Chart3.Series)
            {
                Debug.WriteLine(cs.Name);
                cs.ChartType = SeriesChartType.StackedColumn;
            }

            //Setting width of line
            Chart3.Series[0].BorderWidth = 10;
        }
    protected void Page_Load(object sender, EventArgs e)
    {
        try
        {
            job1Result = ReadJobResult(url1);
            job2Result = ReadJobResult(url2);
            job3Result = ReadJobResult(url3);

            if (!this.IsPostBack)
            {
                DataBindProductDropDown();
                DataBindChart2();
            }

            if (job1Result.Count > 0)
            {
                Chart1.DataSource = job1Result;
                Chart1.Series["Series1"].XValueMember  = "Key";
                Chart1.Series["Series1"].YValueMembers = "Value";
                Chart1.DataBind();
            }

            if (job3Result.Count > 0)
            {
                Chart3.DataSource = job1Result;
                Chart3.Series["Series1"].XValueMember  = "Key";
                Chart3.Series["Series1"].YValueMembers = "Value";
                Chart3.DataBind();
            }
        }
        catch (Exception ex)
        { }
    }
        protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
        {
            //chart 3
            string pitchType = DropDownList1.SelectedValue.ToString();

            Debug.WriteLine(pitchType);

            string queryString = (@"SELECT *
                                FROM
                                (
                                    SELECT[pitchno],
                                           [pitcher],
                                           [pitcherset]
                                    FROM[dbo].[pitchData]
                                    WHERE pitchtype = @pitchType) AS SourceTable PIVOT(COUNT([pitchno]) FOR [pitcherset] IN ([Stretch], [Windup])) AS PivotTable;");

            //DataTable ChartData3 = SqlQueryExecute(sqlQuery3);
            DataTable ChartData3 = new DataTable();

            using (SqlConnection connection = new SqlConnection(connectionString))
            {
                connection.Open();
                using (SqlDataAdapter sqlQueryAdapter = new SqlDataAdapter(queryString, connection))
                {
                    sqlQueryAdapter.SelectCommand.Parameters.AddWithValue("@pitchType", pitchType);
                    sqlQueryAdapter.SelectCommand.CommandTimeout = 120;
                    DataSet dataSet = new DataSet();

                    sqlQueryAdapter.Fill(dataSet);
                    connection.Close();
                    ChartData3 = dataSet.Tables[0];
                }
            }

            DataView dv = new DataView(ChartData3);

            Chart3.DataSource = dv;
            Chart3.DataBind();

            foreach (Series cs in Chart3.Series)
            {
                Debug.WriteLine(cs.Name);
                cs.ChartType = SeriesChartType.StackedColumn;
            }

            //Setting width of line
            Chart3.Series[0].BorderWidth = 10;
        }
    private void LoadChartData1()
    {
        Chart3.ChartAreas[0].AxisX.MajorGrid.Enabled = false;
        Chart3.ChartAreas[0].AxisY.MajorGrid.Enabled = false;
        string query = "SELECT  Category,catcount from tbl_city_wise_graph ";

        SqlDataAdapter da    = new SqlDataAdapter(query, con);
        DataTable      table = new DataTable();

        da.Fill(table);

        DataView dv = table.DefaultView;

        Chart3.DataBind();
        Chart3.Series["Series1"].Points.DataBindXY(dv, "Category", dv, "catcount");
        getdata();
    }
        protected void Page_Load(object sender, EventArgs e)
        {
            //userID = Convert.ToInt32(Request.Cookies.Get(0).Value);
            //userID = 1012;//kc testing
            userID = Convert.ToInt32(Request.QueryString["userID"]);
            int count = Request.Cookies.Count;

            fifthInjury.Text = "test" + userID + "-" + count;
            Chart.Series["Series1"].YValueMembers  = "# of Activities";
            Chart.Series["Series1"].XValueMember   = "# of Weeks";
            Chart1.Series["Series1"].YValueMembers = "# of Activities";
            Chart1.Series["Series1"].XValueMember  = "# of Weeks";
            Chart2.Series["Series1"].YValueMembers = "# of Activities";
            Chart2.Series["Series1"].XValueMember  = "# of Weeks";
            Chart3.Series["Series1"].YValueMembers = "# of Activities";
            Chart3.Series["Series1"].XValueMember  = "# of Weeks";
            try
            {
                Chart.DataSource  = dbObject.GetActivityData(userID, 1, "strength");
                Chart1.DataSource = dbObject.GetActivityData(userID, 1, "cardio");
                Chart2.DataSource = dbObject.GetActivityData(userID, 1, "health");
                Chart3.DataSource = dbObject.GetActivityData(userID, 1, "sleep");
            }
            catch (NullReferenceException ex)
            {
                System.Diagnostics.Debug.WriteLine(ex.Message);
                Response.Redirect("Login.aspx");
            }
            Chart.DataBind();
            Chart1.DataBind();
            Chart2.DataBind();
            Chart3.DataBind();

            showInjuries();
            showWorkout();
            foreach (string name in HealthInputSessionVariables.Activity.Keys)
            {
                foreach (float value in HealthInputSessionVariables.Activity.Values)
                {
                    Label myLabel = new Label();
                    myLabel.ID   = "lbl" + name;
                    myLabel.Text = value.ToString();
                }
            }
        }
        void initpie()
        {
            SqlDataReader rdr = c.MaleFemaleReport(DropDownList3.SelectedItem.Text);

            if (rdr != null)
            {
                Chart3.DataSource = rdr;
                Chart3.Visible    = true;
                Label3.Text       = "";
                Chart3.DataBind();
            }
            else
            {
                Label3.Text = "There is No Enough Data ";

                Chart3.Visible = false;
            }
        }
Exemple #7
0
    private void LoadChartData1()
    {
        Chart3.ChartAreas[0].AxisX.MajorGrid.Enabled = false;
        Chart3.ChartAreas[0].AxisY.MajorGrid.Enabled = false;
        string query = "SELECT City_nm,Count from tbl_stat_datewise_cnt";

        SqlDataAdapter da    = new SqlDataAdapter(query, con);
        DataTable      table = new DataTable();

        da.Fill(table);
        DataView dv = table.DefaultView;

        Chart3.DataBind();
        Chart3.Series["Series1"].Points.DataBindXY(dv, "City_nm", dv, "Count");
        gv_data.DataMember = "tbl_stat_datewise_cnt";
        gv_data.DataSource = table;
        gv_data.DataBind();
    }
Exemple #8
0
    private void LoadChartData1()
    {
        Chart3.ChartAreas[0].AxisX.MajorGrid.Enabled = false;
        Chart3.ChartAreas[0].AxisY.MajorGrid.Enabled = false;
        string query = "SELECT  * from tbl_cat_comp_graph ";

        SqlDataAdapter da    = new SqlDataAdapter(query, con);
        DataTable      table = new DataTable();

        da.Fill(table);

        DataView dv = table.DefaultView;

        Chart3.DataBind();
        Chart3.Series["Sony"].Points.DataBindXY(dv, "Ddate", dv, "cat1");
        Chart3.Series["Canon"].Points.DataBindXY(dv, "Ddate", dv, "cat2");
        Chart3.Series["Nikon"].Points.DataBindXY(dv, "Ddate", dv, "cat3");
        getdata();
    }
 private void getUsersChart()
 {
     using (SqlConnection conn = new SqlConnection(connStr))
     {
         // Query to retrieve database data for the chart control
         SqlCommand cmd = new SqlCommand
                              ("SELECT COUNT(UserId) AS Users, MONTH(RegDate) AS Monthly FROM Users WHERE UserType = 2 Group BY MONTH(RegDate)", conn);
         conn.Open();
         SqlDataReader rdr = cmd.ExecuteReader();
         // Specify the column name that contains values for X-Axis
         Chart3.Series["Series3"].XValueMember = "Monthly";
         // Specify the column name that contains values for Y-Axis
         Chart3.Series["Series3"].YValueMembers = "Users";
         // Set the datasource
         Chart3.DataSource = rdr;
         // Finally call DataBind()
         Chart3.DataBind();
     }
 }
    private void LoadChartData1()
    {
        string from = ddl_frommonth.Text + "/" + ddl_fromdate.Text + "/" + ddl_fromyear.Text;
        string to   = ddl_tomonth.Text + "/" + ddl_todate.Text + "/" + ddl_toyear.Text;

        Chart3.ChartAreas[0].AxisX.MajorGrid.Enabled = false;
        Chart3.ChartAreas[0].AxisY.MajorGrid.Enabled = false;
        string query = "SELECT  Ddate,Vcount from tbl_show_all_graph where Ddate between '" + from + "' AND '" + to + "' order by Ddate ASC";

        SqlDataAdapter da    = new SqlDataAdapter(query, con);
        DataTable      table = new DataTable();

        da.Fill(table);

        DataView dv = table.DefaultView;

        Chart3.DataBind();
        Chart3.Series["Series1"].Points.DataBindXY(dv, "Ddate", dv, "VCount");
        getdata2();
    }
Exemple #11
0
    private void LoadChartData1()
    {
        string from = ddl_frommonth.Text + "/" + ddl_fromdate.Text + "/" + ddl_fromyear.Text;
        string to   = ddl_tomonth.Text + "/" + ddl_todate.Text + "/" + ddl_toyear.Text;

        Chart3.ChartAreas[0].AxisX.MajorGrid.Enabled = false;
        Chart3.ChartAreas[0].AxisY.MajorGrid.Enabled = false;
        string query = "SELECT  State,Vcount from tbl_state_wise_graph ";

        SqlDataAdapter da    = new SqlDataAdapter(query, con);
        DataTable      table = new DataTable();

        da.Fill(table);

        DataView dv = table.DefaultView;

        Chart3.DataBind();
        Chart3.Series["Series1"].Points.DataBindXY(dv, "State", dv, "Vcount");
        getdata();
    }
        public void View1_bind()
        {
            if (!DropDownList6.SelectedValue.Equals("-1"))
            {
                Label10.Text = string.Format(DropDownList6.SelectedItem.Text.ToString() + ": " + DropDownList6.SelectedValue.ToString());
                DataTable dt = StudentLogic.getUserVSBatch(Session["userID"].ToString(), Session["courseID"].ToString(), DropDownList6.SelectedValue);
                if (dt != null)
                {
                    GridView3.DataSource = dt;
                    GridView3.DataBind();

                    Chart3.DataSource = dt;
                    Chart3.Series["Series1"].XValueMember  = "Result Group";
                    Chart3.Series["Series1"].YValueMembers = "GPA";
                    Chart3.DataBind();
                }
                else
                {
                    Label10.Text = "No results available!";
                }
            }
        }
Exemple #13
0
        protected void cmdAceptar_Click1(object sender, EventArgs e)
        {
            if (ddlBuscar.SelectedValue == "1")
            {
                gvBusquedaP0.DataSourceID = "DSBUSQUEDA";
                gvBusquedaP0.DataBind();

                Chart3.DataSourceID = "DSBUSQUEDA";
                Chart3.DataBind();
                gvBusquedaP.Visible = false;
            }

            if (ddlBuscar.SelectedValue == "2")
            {
                gvBusquedaP0.DataSourceID = "DSBUSQUEDA1";
                gvBusquedaP0.DataBind();

                Chart3.DataSourceID = "DSBUSQUEDA1";
                Chart3.DataBind();
                gvBusquedaP.Visible = false;
            }
        }
Exemple #14
0
 protected void Page_Load(object sender, EventArgs e)
 {
     // istatikler için çartların sonuçlarının toplanması.
     Chart1.DataSource = getdata1();
     Chart1.DataBind();
     Repeater1.DataSource = getdata();
     Repeater1.DataBind();
     Chart1.ChartAreas[0].AxisX.Title = "gender";
     Chart1.ChartAreas[0].AxisY.Title = "picture2";
     Chart2.DataSource = getdata2();
     Chart2.DataBind();
     Chart2.ChartAreas[0].AxisX.Title = "gender";
     Chart2.ChartAreas[0].AxisY.Title = "picture1";
     basligiAl();
     Chart3.DataSource = getdata3();
     Chart3.DataBind();
     Chart3.ChartAreas[0].AxisX.Title = "age_group";
     Chart3.ChartAreas[0].AxisY.Title = "picture1";
     Chart4.DataSource = getdata4();
     Chart3.DataBind();
     Chart4.ChartAreas[0].AxisX.Title = "age_group";
     Chart4.ChartAreas[0].AxisY.Title = "picture2";
 }
Exemple #15
0
    protected void FillCharts()
    {
        DataTable dt = GetData("select * from dbo.top10_Origin");



        Chart1.Series[0].ChartType = SeriesChartType.Pie;
        Chart1.DataSource          = dt;
        Chart1.Series.First().XValueMember  = "Origin";
        Chart1.Series.First().YValueMembers = "Count";
        Chart1.DataBind();
        Chart1.ChartAreas["ChartArea1"].BackColor = System.Drawing.Color.Transparent;



        dt.Clear();
        dt = GetData("select * from dbo.flightCount");

        Chart2.Series[0].ChartType = SeriesChartType.Pie;
        Chart2.DataSource          = dt;
        Chart2.Series.First().XValueMember  = "Code";
        Chart2.Series.First().YValueMembers = "Flight Count";
        Chart2.DataBind();
        Chart2.ChartAreas["ChartArea1"].BackColor = System.Drawing.Color.Transparent;


        dt.Clear();
        dt = GetData("select * from dbo.avgDelay");

        Chart3.Series[0].ChartType = SeriesChartType.Column;
        Chart3.DataSource          = dt;
        Chart3.Series.First().XValueMember  = "Code";
        Chart3.Series.First().YValueMembers = "Average Delay";
        Chart3.DataBind();
        Chart3.ChartAreas["ChartArea1"].BackColor = System.Drawing.Color.Transparent;
    }
Exemple #16
0
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                cd = new SqlCommand("select image_url,ename from employee where eemail=@email", con);
                cd.Parameters.AddWithValue("@email", Session["email"].ToString());
                da = new SqlDataAdapter(cd);
                dt = new DataTable();
                da.Fill(dt);

                foreach (DataRow item in dt.Rows)
                {
                    userimage.ImageUrl = item[0].ToString();
                    username.Text      = item[1].ToString();
                }
                //da = new SqlDataAdapter("select * from Project_Master", con);

                //ds = new DataSet();

                //da.Fill(ds);

                ////Chart1.DataSource = ds;

                ////Chart1.DataBind();



                cd1             = new SqlCommand("getprojectnames", con);
                cd1.CommandType = CommandType.StoredProcedure;

                da1 = new SqlDataAdapter(cd1);
                dt1 = new DataTable();
                da1.Fill(dt1);

                DropDownList1.DataSource     = dt1;
                DropDownList1.DataTextField  = "pname";
                DropDownList1.DataValueField = "pid";
                DropDownList1.DataBind();

                DropDownList3.DataSource     = dt1;
                DropDownList3.DataTextField  = "pname";
                DropDownList3.DataValueField = "pid";
                DropDownList3.DataBind();
                DataTable custom1 = new DataTable();
                custom1.Columns.Add("projectname", typeof(System.String));
                custom1.Columns.Add("projectprg", typeof(System.Double));

                foreach (DataRow item in dt1.Rows)
                {
                    DataTable custom = new DataTable();
                    custom.Columns.Add("mid", typeof(System.Int16));
                    custom.Columns.Add("prg", typeof(System.Int16));

                    cd = new SqlCommand("select ModuleID  from ProjectModule where ProjectID=@pid", con);
                    cd.Parameters.AddWithValue("@pid", Convert.ToInt16(item[0]));
                    da = new SqlDataAdapter(cd);
                    DataTable mydt = new DataTable();
                    da.Fill(mydt);

                    foreach (DataRow item1 in mydt.Rows)
                    {
                        cd = new SqlCommand("getmoduleprogress", con);
                        cd.Parameters.AddWithValue("@mid", Convert.ToInt16(item1[0]));
                        cd.CommandType = CommandType.StoredProcedure;
                        da             = new SqlDataAdapter(cd);
                        DataTable mydt1 = new DataTable();
                        da.Fill(mydt1);
                        DataRow dr = custom.NewRow();
                        dr[0] = item1[0].ToString();
                        foreach (DataRow item2 in mydt1.Rows)
                        {
                            dr[1] = Convert.ToInt16(item2[0]);
                        }

                        custom.Rows.Add(dr);
                    }

                    double sum = 0;

                    foreach (DataRow item3 in custom.Rows)
                    {
                        int newsum = Convert.ToInt16(item3[1]);
                        sum = sum + newsum;
                    }


                    DataRow dr1 = custom1.NewRow();
                    dr1[0] = item[1].ToString();
                    dr1[1] = (sum / custom.Rows.Count);
                    custom1.Rows.Add(dr1);
                }


                Chart3.DataSource = custom1;
                Chart3.DataBind();



                ListItem li = new ListItem();
                li.Text  = "Select Project";
                li.Value = 0.ToString();
                DropDownList1.Items.Insert(0, li);



                ListItem li1 = new ListItem();
                li1.Text  = "Select Modul";
                li1.Value = 0.ToString();
                DropDownList2.Items.Insert(0, li1);


                ListItem li2 = new ListItem();
                li2.Text  = "Select Project";
                li2.Value = 0.ToString();
                DropDownList3.Items.Insert(0, li2);
            }
        }
Exemple #17
0
        public void bindchart()
        {
            cd1             = new SqlCommand("getprojectnames", con);
            cd1.CommandType = CommandType.StoredProcedure;

            da1 = new SqlDataAdapter(cd1);
            dt1 = new DataTable();
            da1.Fill(dt1);

            DataTable custom1 = new DataTable();

            custom1.Columns.Add("projectname", typeof(System.String));
            custom1.Columns.Add("projectprg", typeof(System.Double));

            foreach (DataRow item in dt1.Rows)
            {
                DataTable custom = new DataTable();
                custom.Columns.Add("mid", typeof(System.Int16));
                custom.Columns.Add("prg", typeof(System.Int16));

                cd = new SqlCommand("select ModuleID  from ProjectModule where ProjectID=@pid", con);
                cd.Parameters.AddWithValue("@pid", Convert.ToInt16(item[0]));
                da = new SqlDataAdapter(cd);
                DataTable mydt = new DataTable();
                da.Fill(mydt);

                foreach (DataRow item1 in mydt.Rows)
                {
                    cd = new SqlCommand("getmoduleprogress", con);
                    cd.Parameters.AddWithValue("@mid", Convert.ToInt16(item1[0]));
                    cd.CommandType = CommandType.StoredProcedure;
                    da             = new SqlDataAdapter(cd);
                    DataTable mydt1 = new DataTable();
                    da.Fill(mydt1);
                    DataRow dr = custom.NewRow();
                    dr[0] = item1[0].ToString();
                    foreach (DataRow item2 in mydt1.Rows)
                    {
                        dr[1] = Convert.ToInt16(item2[0]);
                    }

                    custom.Rows.Add(dr);
                }

                double sum = 0;

                foreach (DataRow item3 in custom.Rows)
                {
                    int newsum = Convert.ToInt16(item3[1]);
                    sum = sum + newsum;
                }


                DataRow dr1 = custom1.NewRow();
                dr1[0] = item[1].ToString();
                dr1[1] = (sum / custom.Rows.Count);
                custom1.Rows.Add(dr1);
            }

            Chart3.DataSource = custom1;
            Chart3.DataBind();
        }
Exemple #18
0
 protected void btnSetChoice_Click(object sender, EventArgs e)
 {
     Chart1.DataBind();
     Chart2.DataBind();
     Chart3.DataBind();
 }
Exemple #19
0
    protected void ddlChart_SelectedIndexChanged(object sender, EventArgs e)
    {
        try
        {
            if (ddlChart.SelectedValue == "Chart1")
            {
                Chart1.Visible = true;
                DataTable _dt = _objChartMasterManager.LeaveChart().Tables[0];
                Chart1.DataSource = _dt;
                Chart1.Series[0].YValueMembers       = "LeaveAllowed";
                Chart1.Series[0].IsValueShownAsLabel = true;
                Chart1.Series[1].YValueMembers       = "LeaveTypeId";

                Chart1.Series[0].XValueMember = "LeaveTypeId";
                Chart1.ChartAreas["ChartArea1"].AxisY.Interval = 2;
                Chart1.DataBind();
            }
            else if (ddlChart.SelectedValue == "Chart2")
            {
                Chart2.Visible = true;
                DataTable _dt2 = _objChartMasterManager.DesignationChart().Tables[0];
                Chart2.DataSource = _dt2;
                Chart2.Series[0].YValueMembers = "EmployeeId";
                Chart2.Series[0].XValueMember  = "Designation";
                Chart2.ChartAreas["ChartArea2"].AxisY.Interval = 1;
                Chart2.DataBind();
            }
            else if (ddlChart.SelectedValue == "Chart3")
            {
                Chart3.Visible = true;
                DataTable _dt3 = _objChartMasterManager.DepartmentChart().Tables[0];
                Chart3.DataSource = _dt3;
                Chart3.Series[0].YValueMembers = "EmployeeId";
                Chart3.Series[0].XValueMember  = "Department";
                Chart3.ChartAreas["ChartArea3"].AxisY.Interval = 1;
                Chart3.DataBind();
            }
            else if (ddlChart.SelectedValue == "Chart4")
            {
                //Chart4.Visible = true;
                //DataTable _dt4 = _objChartMasterManager.YearlyJoinChart().Tables[0];
                //Chart4.DataSource = _dt4;
                //Chart4.Series[0].YValueMembers = "EmployeeId";
                //Chart4.Series[0].IsValueShownAsLabel = true;
                //Chart4.Series[0].XValueMember = "JoiningDate";
                //Chart4.ChartAreas["ChartArea4"].AxisY.Interval = 1;
                //Chart4.DataBind();


                Chart4.Visible = true;
                DataTable _dt4 = _objChartMasterManager.YearlyJoinChart().Tables[0];
                Chart4.DataSource = _dt4;
                Chart4.Series[0].YValueMembers = "EmployeeId";
                // Chart4.Series[0].IsValueShownAsLabel = true;
                Chart4.Legends.IsUniqueName("ABC...............");
                Chart4.Series[0].XValueMember = "JoiningDate";
                Chart4.ChartAreas["ChartArea4"].AxisY.Interval = 2;
                Chart4.DataBind();
            }
        }
        catch (Exception ex)
        {
            lblMsg.Text = "" + ex.Message.ToString();
        }
    }
Exemple #20
0
        protected void Button3_Click(object sender, EventArgs e)
        {
            Label1.Visible = false;
            Label2.Visible = false;
            Label3.Visible = false;
            CrystalReportViewer1.SelectionFormula = "";
            CrystalReportViewer1.RefreshReport();
            int num  = allretdata1();
            int num1 = allretdata2();
            int num2 = allnadiret();
            int num3 = allaerotechret();
            int num4 = allconfigret();


            double[] yValues = { num, num1, num2, num3, num4 };
            string[] xValues = { "AIROD", "AIROD AEROSPACE", "NADI", "TECHPOWER", "INAYAH" };
            Chart1.Series["Default"].Points.DataBindXY(xValues, yValues);
            Chart1.Series["Default"].Points[0].Color = Color.Blue;
            Chart1.Series["Default"].Points[1].Color = Color.Red;
            Chart1.Series["Default"].ChartType       = System.Web.UI.DataVisualization.Charting.SeriesChartType.Pie;
            Chart1.Legends.Add("AIROD");
            Chart1.Legends.Add("AIROD AEROSPACE" + num1);
            Chart1.Series["Default"].IsVisibleInLegend = true;
            Chart1.Series["Default"].Points[0].Label   = "#PERCENT" + "   AIROD";
            Chart1.Series["Default"].Points[1].Label   = "#PERCENT" + "   AIROD AEROSPACE";
            Chart1.Series["Default"].Points[2].Label   = "#PERCENT" + "   NADI";
            Chart1.Series["Default"].Points[3].Label   = "#PERCENT" + "   TECHPOWER";
            Chart1.Series["Default"].Points[4].Label   = "#PERCENT" + "   INAYAH";

            Chart1.Series["Default"]["PieLabelStyle"]            = "Disabled";
            Chart1.ChartAreas["ChartArea1"].Area3DStyle.Enable3D = true;
            Chart1.Visible = true;
            Chart1.Enabled = true;
            int meet  = allretmeet1();
            int meet1 = allretmeet2();

            Chart3.Legends.Clear();
            Chart3.DataBind();

            double[] yyValues = { meet, meet1 };
            string[] xxValues = { "MEET HOURS", "NOT MEET HOURS" };
            Chart3.Series["Default1"].Points.DataBindXY(xxValues, yyValues);
            Chart3.Series["Default1"].Points[0].Color = Color.Green;
            Chart3.Series["Default1"].Points[1].Color = Color.Yellow;
            Chart3.Series["Default1"].ChartType       = System.Web.UI.DataVisualization.Charting.SeriesChartType.Pie;
            Chart3.Legends.Add("MEET HOURS" + meet);
            Chart3.Legends.Add("NOT MEET HOURS" + meet1);
            Chart3.Series["Default1"].Points[0].Label            = "#PERCENT" + "   MEET HOURS";
            Chart3.Series["Default1"].Points[1].Label            = "#PERCENT" + "   NOT MEET HOURS";
            Chart3.Series["Default1"]["PieLabelStyle"]           = "Disabled";
            Chart3.Series["Default1"].IsVisibleInLegend          = true;
            Chart3.ChartAreas["ChartArea2"].Area3DStyle.Enable3D = true;
            Chart3.Visible = true;
            Chart3.Enabled = true;



            int Type1 = allTyperet();
            int Type2 = allTyperet1();
            int Type3 = allTyperet2();

            Chart4.Legends.Clear();
            Chart4.Series["Default3"]["PieLabelStyle"] = "Disabled";
            double[] tValues = { Type1, Type2, Type3 };
            string[] pValues = { "Priority", "Normal", "Urgent" };
            Chart4.Series["Default3"].Points.DataBindXY(pValues, tValues);
            Chart4.Series["Default3"].Points[0].Color = Color.Green;
            Chart4.Series["Default3"].Points[1].Color = Color.Yellow;
            Chart4.Series["Default3"].Points[2].Color = Color.Black;
            Chart4.Series["Default3"].ChartType       = System.Web.UI.DataVisualization.Charting.SeriesChartType.Pie;
            Chart4.Legends.Add("Priority");
            Chart4.Legends.Add("Normal");
            Chart4.Legends.Add("Urgent");
            Chart4.Series["Default3"].Points[0].Label = "#PERCENT" + " PRIORITY";
            Chart4.Series["Default3"].Points[1].Label = "#PERCENT" + " NORMAL";
            Chart4.Series["Default3"].Points[2].Label = "#PERCENT" + " URGENT";

            Chart4.Series["Default3"]["PieLabelStyle"]           = "Disabled";
            Chart4.Series["Default3"].IsVisibleInLegend          = true;
            Chart4.ChartAreas["ChartArea3"].Area3DStyle.Enable3D = true;
            Chart4.Visible = true;
            Chart4.Enabled = true;
        }
        protected void Page_Load(object sender, EventArgs e)
        {
            Chart.Series["Series1"].YValueMembers  = "# of Activities";
            Chart.Series["Series1"].XValueMember   = "# of Weeks";
            Chart1.Series["Series1"].YValueMembers = "# of Activities";
            Chart1.Series["Series1"].XValueMember  = "# of Weeks";
            Chart2.Series["Series1"].YValueMembers = "# of Activities";
            Chart2.Series["Series1"].XValueMember  = "# of Weeks";
            Chart3.Series["Series1"].YValueMembers = "# of Activities";
            Chart3.Series["Series1"].XValueMember  = "# of Weeks";
            try
            {
                Chart.DataSource  = dbObject.GetActivityData(((SessionData)Session["User_Data"])._loginID, 1, "strength");
                Chart1.DataSource = dbObject.GetActivityData(((SessionData)Session["User_Data"])._loginID, 1, "cardio");
                Chart2.DataSource = dbObject.GetActivityData(((SessionData)Session["User_Data"])._loginID, 1, "health");
                Chart3.DataSource = dbObject.GetActivityData(((SessionData)Session["User_Data"])._loginID, 1, "sleep");
            }
            catch (NullReferenceException ex)
            {
                System.Diagnostics.Debug.WriteLine(ex.Message);
                Response.Redirect("Login.aspx");
            }
            Chart.DataBind();
            Chart1.DataBind();
            Chart2.DataBind();
            Chart3.DataBind();

            showInjuries();
            showWorkout();



            if (!IsPostBack)
            {
                dictInjury.Add("Head", 0);
                dictInjury.Add("Right Shoulder", 0);
                dictInjury.Add("Right Elbow", 0);
                dictInjury.Add("Right Hand", 0);
                dictInjury.Add("Right Knee", 0);
                dictInjury.Add("Right Foot", 0);
                dictInjury.Add("Abdomen", 0);
                dictInjury.Add("Left Shoulder", 0);
                dictInjury.Add("Left Elbow", 0);
                dictInjury.Add("Left Knee", 0);
                dictInjury.Add("Left Foot", 0);
                dictInjury.Add("Neck", 0);
                dictInjury.Add("Left Shoulder Blade", 0);
                dictInjury.Add("Left Forearm", 0);
                dictInjury.Add("Lumbar", 0);
                dictInjury.Add("Thoracic", 0);
                dictInjury.Add("Left Heel", 0);
                dictInjury.Add("Right Heel", 0);
                dictInjury.Add("Right Shoulder Blade", 0);
                dictInjury.Add("Right Forearm", 0);
                dictInjury.Add("Left Hand", 0);
            }

            foreach (string name in HealthInputSessionVariables.Activity.Keys)
            {
                foreach (float value in HealthInputSessionVariables.Activity.Values)
                {
                    Label myLabel = new Label();
                    myLabel.ID   = "lbl" + name;
                    myLabel.Text = value.ToString();
                }
            }
        }
        private void buildLineChart(string Diploma, string StudentYear)
        {
            String        myConnect = ConfigurationManager.ConnectionStrings["EADPConnectionString2"].ToString();
            SqlConnection myConn    = new SqlConnection(myConnect);

            DataSet ds = new DataSet();

            SqlDataAdapter da;

            DateTime now = DateTime.Now;


            String strSQL = "SELECT COUNT(i.adminno) NoOfStudents, DATENAME(month, TripEnd) AS [Month] FROM [interview] i ";

            strSQL += "INNER JOIN trip t on i.tripid = t.tripid ";
            strSQL += "INNER JOIN register r on i.AdminNo = r.AdminNo ";
            strSQL += "INNER JOIN Student s on r.adminNo = s.adminno ";

            if (!Diploma.Equals("All"))
            {
                strSQL += "WHERE Diploma = @paraDiploma and studentchoice = 'accepted' and (GETDATE() > TripEnd) ";
                da      = new SqlDataAdapter(strSQL.ToString(), myConn);

                if (!StudentYear.Equals("All"))
                {
                    if (now.Month > 4)
                    {
                        int studentyr = int.Parse(StudentYear);
                        studentyr--;
                        strSQL += "AND ((year(getdate()) - 2000) - convert(int, SUBSTRING(i.AdminNo, 1, 2))) = @paraStudentYear Group By [TripEnd] ";
                        //check
                        da = new SqlDataAdapter(strSQL.ToString(), myConn);
                        da.SelectCommand.Parameters.AddWithValue("@paraStudentYear", studentyr);
                    }
                    else
                    {
                        strSQL += "AND ((year(getdate()) - 2000) - convert(int, SUBSTRING(i.AdminNo, 1, 2))) = @paraStudentYear Group By [TripEnd] ";
                        //check
                        da = new SqlDataAdapter(strSQL.ToString(), myConn);
                        da.SelectCommand.Parameters.AddWithValue("@paraStudentYear", StudentYear);
                    }
                }
                else
                {
                    strSQL += "where studentchoice = 'accepted' and (GETDATE() > TripEnd) ";
                    strSQL += "Group By DATENAME(month, TripEnd) ";
                    da      = new SqlDataAdapter(strSQL.ToString(), myConn);
                }
                da.SelectCommand.Parameters.AddWithValue("@paraDiploma", Diploma);
            }

            else if (!StudentYear.Equals("All"))
            {
                if (now.Month > 4)
                {
                    int studentyr = int.Parse(StudentYear);
                    studentyr--;
                    strSQL += "WHERE ((year(getdate()) - 2000) - convert(int, SUBSTRING(i.AdminNo, 1, 2))) = @paraStudentYear Group By [TripEnd] ";
                    //check
                    da = new SqlDataAdapter(strSQL.ToString(), myConn);
                    da.SelectCommand.Parameters.AddWithValue("@paraStudentYear", studentyr);
                }
                else
                {
                    strSQL += "WHERE ((year(getdate()) - 2000) - convert(int, SUBSTRING(i.AdminNo, 1, 2))) = @paraStudentYear Group By [TripEnd] ";
                    //check
                    da = new SqlDataAdapter(strSQL.ToString(), myConn);
                    da.SelectCommand.Parameters.AddWithValue("@paraStudentYear", StudentYear);
                }
            }

            else
            {
                strSQL += "Group By DATENAME(month, TripEnd) ";
                da      = new SqlDataAdapter(strSQL.ToString(), myConn);
            }
            da.Fill(ds, "tripTable");

            Chart3.DataSource = ds;
            Chart3.DataBind();
            string imgPathing2 = HttpContext.Current.Request.PhysicalApplicationPath + tmpChartName3;

            Chart3.SaveImage(imgPathing2);
        }
        private void BindGrid(string table)
        {
            DataTable dt = new DataTable();

            using (SqlConnection con = new SqlConnection(constr))
            {
                using (SqlCommand cmd = new SqlCommand("SELECT top 5 * FROM " + table))
                {
                    using (SqlDataAdapter sda = new SqlDataAdapter())
                    {
                        DataTable dtCloned = new DataTable();
                        cmd.Connection    = con;
                        sda.SelectCommand = cmd;
                        sda.Fill(dt);

                        ViewState["dt"] = dt;
                    }
                }
                if (table == "Hosts")
                {
                    Hosts.DataSource = dt;
                    Hosts.DataBind();

                    string[] x = new string[dt.Rows.Count];
                    int[]    y = new int[dt.Rows.Count];
                    for (int i = 0; i < dt.Rows.Count; i++)
                    {
                        x[i] = dt.Rows[i][0].ToString();
                        y[i] = i;
                    }
                    Chart2.Series[0].Points.DataBindXY(x, y);
                    Chart2.Series[0].ChartType = SeriesChartType.Pie;
                    Chart2.ChartAreas["ChartArea1"].Area3DStyle.Enable3D = true;
                    //Chart2.Legends[0].Enabled = true;
                    Chart2.DataSource = dt;
                    Chart2.DataBind();

                    Chart1.Series[0].Points.DataBindXY(x, y);
                    Chart1.Series[0].ChartType = SeriesChartType.Pyramid;
                    Chart1.ChartAreas["ChartArea1"].Area3DStyle.Enable3D = true;
                    //Chart1.Legends[0].Enabled = true;
                    Chart1.DataSource = dt;
                    Chart1.DataBind();

                    Chart3.Series[0].Points.DataBindXY(x, y);
                    Chart3.Series[0].ChartType = SeriesChartType.Column;
                    Chart3.ChartAreas["ChartArea1"].Area3DStyle.Enable3D = true;
                    //Chart3.Legends[0].Enabled = true;
                    Chart3.DataSource = dt;
                    Chart3.DataBind();

                    Chart4.Series[0].Points.DataBindXY(x, y);
                    Chart4.Series[0].ChartType = SeriesChartType.Doughnut;
                    Chart4.ChartAreas["ChartArea1"].Area3DStyle.Enable3D = true;
                    //Chart4.Legends[0].Enabled = true;
                    Chart4.DataSource = dt;
                    Chart4.DataBind();
                }
                else if (table == "Applications")
                {
                    Applications.DataSource = dt;
                    Applications.DataBind();
                }
                else if (table == "Storage")
                {
                    Storage.DataSource = dt;
                    Storage.DataBind();
                }
                else if (table == "Databases")
                {
                    Databases.DataSource = dt;
                    Databases.DataBind();
                }
            }
        }
Exemple #24
0
        private void LOAD_DASHBOARD()
        {
            DataTable DT = new DataTable();

            DT = DASH.Select_Asset_By_Location();
            Chart1.DataSource = DT;
            Chart1.Series["Series1"].XValueMember     = "DashDesc";
            Chart1.Series["Series1"].YValueMembers    = "cnt";
            Chart1.Series["Series1"]["PieLabelStyle"] = "outside";
            Chart1.DataBind();
            Chart1.Style.Add("width", "100%");
            lblC1Total.Text = "Total Assets: " + String.Format("{0:#,##0}", DT.Compute("Sum(cnt)", ""));
            DataTable DT2 = new DataTable();

            DT2 = DASH.Select_Asset_By_Area();
            Chart2.DataSource = DT2;
            Chart2.Series["Series1"].XValueMember     = "DashDesc";
            Chart2.Series["Series1"].YValueMembers    = "cnt";
            Chart2.Series["Series1"]["PieLabelStyle"] = "outside";
            Chart2.DataBind();
            Chart2.Style.Add("width", "100%");
            lblC2Total.Text = "Total Assets: " + String.Format("{0:#,##0}", DT2.Compute("Sum(cnt)", ""));
            DataTable DT3 = new DataTable();

            DT3 = DASH.Select_Stock_Level();
            Chart3.DataSource = DT3;
            Chart3.Series["Series1"].XValueMember     = "CATEGORY";
            Chart3.Series["Series1"].YValueMembers    = "CNT";
            Chart3.Series["Series1"]["PieLabelStyle"] = "outside";
            Chart3.DataBind();
            Chart3.Style.Add("width", "100%");
            //lblC3Total.Text = "Total Assets: " + String.Format("{0:#,##0}", DT3.Compute("Sum(CNT)", ""));
            DataTable DT4 = new DataTable();

            DT4 = DASH.Select_Budget_Actual();
            ViewState["xBudget"] = DT4;
            Chart4.DataSource    = DT4;
            Chart4.Series["Budget"].XValueMember  = "NAME";
            Chart4.Series["Budget"].YValueMembers = "BUDGET";
            Chart4.Series["Actual"].XValueMember  = "NAME";
            Chart4.Series["Actual"].YValueMembers = "ACTUAL";
            Chart4.DataBind();
            Chart4.Style.Add("width", "100%");
            grdView.DataSource = DT4;
            grdView.DataBind();
            DataTable DT5 = new DataTable();

            DT5 = DASH.Get_Critical();
            ViewState["xCritical"] = DT5;
            grdCritical.DataSource = DT5;
            grdCritical.DataBind();
            lblCritical.Text = DT5.Rows.Count.ToString();
            DataTable DT6 = new DataTable();

            DT6 = DASH.Get_Overstocked();
            ViewState["xOverstocked"] = DT6;
            grdOverstocked.DataSource = DT6;
            grdOverstocked.DataBind();
            lblOverstocked.Text = DT6.Rows.Count.ToString();
            DataTable DT7 = new DataTable();

            DT7 = DASH.Get_Asset_By_Location();
            ViewState["xByLocation"] = DT7;
            grdByLocation.DataSource = DT7;
            grdByLocation.DataBind();
            lblByLocation.Text   = DT7.Rows.Count.ToString();
            lblStockSummary.Text = DT7.Compute("Sum(CNT)", "").ToString();
            //COUNTS
            DataTable DT10 = new DataTable();

            DT10           = DASH.Get_OpenPO_Count();
            lblOpenPo.Text = DT10.Rows[0][0].ToString();
            DataTable DT11 = new DataTable();

            DT11 = DASH.Get_POReceiving_Count();
            lblPOReceiving.Text = DT11.Rows[0][0].ToString();
            DataTable DT12 = new DataTable();

            DT12 = DASH.Get_FATMApproval_Count();
            lblFATMApproval.Text = DT12.Rows[0][0].ToString();
            DataTable DT13 = new DataTable();

            DT13 = DASH.Get_InTransit_Count();
            lblInTransit.Text = DT13.Rows[0][0].ToString();
        }
Exemple #25
0
        protected void Button8_Click(object sender, EventArgs e)
        {
            Label1.Visible = false;
            Label2.Visible = false;
            Label3.Visible = false;
            int num  = retdata1();
            int num1 = retdata2();
            int num2 = nadiret();
            int num3 = aerotechret();
            int num4 = configret();


            double[] yValues = { num, num1, num2, num3, num4 };
            string[] xValues = { "AIROD", "AIROD AEROSPACE", "NADI", "TECHPOWER", "INAYAH" };
            Chart1.Series["Default"].Points.DataBindXY(xValues, yValues);
            Chart1.Series["Default"].Points[0].Color = Color.Blue;
            Chart1.Series["Default"].Points[1].Color = Color.Red;
            Chart1.Series["Default"].ChartType       = System.Web.UI.DataVisualization.Charting.SeriesChartType.Pie;
            Chart1.Legends.Add("AIROD");
            Chart1.Legends.Add("AIROD AEROSPACE" + num1);
            Chart1.Series["Default"].IsVisibleInLegend = true;
            Chart1.Series["Default"].Points[0].Label   = "#PERCENT" + "   AIROD";
            Chart1.Series["Default"].Points[1].Label   = "#PERCENT" + "   AIROD AEROSPACE";
            Chart1.Series["Default"].Points[2].Label   = "#PERCENT" + "   NADI";
            Chart1.Series["Default"].Points[3].Label   = "#PERCENT" + "   TECHPOWER";
            Chart1.Series["Default"].Points[4].Label   = "#PERCENT" + "   INAYAH";

            Chart1.Series["Default"]["PieLabelStyle"]            = "Disabled";
            Chart1.ChartAreas["ChartArea1"].Area3DStyle.Enable3D = true;
            Chart1.Visible = true;
            Chart1.Enabled = true;
            int meet  = retmeet1();
            int meet1 = retmeet2();

            Chart3.Legends.Clear();
            Chart3.DataBind();

            double[] yyValues = { meet, meet1 };
            string[] xxValues = { "MEET HOURS", "NOT MEET HOURS" };
            Chart3.Series["Default1"].Points.DataBindXY(xxValues, yyValues);
            Chart3.Series["Default1"].Points[0].Color = Color.Green;
            Chart3.Series["Default1"].Points[1].Color = Color.Yellow;
            Chart3.Series["Default1"].ChartType       = System.Web.UI.DataVisualization.Charting.SeriesChartType.Pie;
            Chart3.Legends.Add("MEET HOURS" + meet);
            Chart3.Legends.Add("NOT MEET HOURS" + meet1);
            Chart3.Series["Default1"].Points[0].Label            = "#PERCENT" + "   MEET HOURS";
            Chart3.Series["Default1"].Points[1].Label            = "#PERCENT" + "   NOT MEET HOURS";
            Chart3.Series["Default1"]["PieLabelStyle"]           = "Disabled";
            Chart3.Series["Default1"].IsVisibleInLegend          = true;
            Chart3.ChartAreas["ChartArea2"].Area3DStyle.Enable3D = true;
            Chart3.Visible = true;
            Chart3.Enabled = true;



            int Type1 = Typeret();
            int Type2 = Typeret1();
            int Type3 = Typeret2();

            Chart4.Legends.Clear();
            Chart4.Series["Default3"]["PieLabelStyle"] = "Disabled";
            double[] tValues = { Type1, Type2, Type3 };
            string[] pValues = { "Priority", "Normal", "Urgent" };
            Chart4.Series["Default3"].Points.DataBindXY(pValues, tValues);
            Chart4.Series["Default3"].Points[0].Color = Color.Green;
            Chart4.Series["Default3"].Points[1].Color = Color.Yellow;
            Chart4.Series["Default3"].Points[2].Color = Color.Black;
            Chart4.Series["Default3"].ChartType       = System.Web.UI.DataVisualization.Charting.SeriesChartType.Pie;
            Chart4.Legends.Add("Priority");
            Chart4.Legends.Add("Normal");
            Chart4.Legends.Add("Urgent");
            Chart4.Series["Default3"].Points[0].Label = "#PERCENT" + " PRIORITY";
            Chart4.Series["Default3"].Points[1].Label = "#PERCENT" + " NORMAL";
            Chart4.Series["Default3"].Points[2].Label = "#PERCENT" + " URGENT";

            Chart4.Series["Default3"]["PieLabelStyle"]           = "Disabled";
            Chart4.Series["Default3"].IsVisibleInLegend          = true;
            Chart4.ChartAreas["ChartArea3"].Area3DStyle.Enable3D = true;
            Chart4.Visible = true;
            Chart4.Enabled = true;
            if (((TextBox1.Text != "") && (TextBox2.Text != "")))
            {
                CrystalReportViewer1.SelectionFormula = "{tbl_srvmast1.Com_Type}='" + DropDownList1.SelectedItem.Text + "'" + "AND{tbl_srvmast1.Rec_Date}>=CDate('" + TextBox1.Text + "')" + "AND {tbl_srvmast1.Rec_Date}<=CDate('" + TextBox2.Text + "')" + "AND {tbl_srvmast1.Act_Email}='" + DropDownList5.SelectedItem.Text + "'" + "AND{tbl_srvmast1.Req_Status}='" + DropDownList2.SelectedItem.Text + "'";
                CrystalReportViewer1.RefreshReport();
            }
            else
            if (((TextBox3.Text != "") && (TextBox4.Text != "")))
            {
                CrystalReportViewer1.SelectionFormula = "{tbl_srvmast1.Com_Type}='" + DropDownList1.SelectedItem.Text + "'" + "AND{tbl_srvmast1.Rec_Date}>=CDate('" + TextBox3.Text + "')" + "AND {tbl_srvmast1.Rec_Date}<=CDate('" + TextBox4.Text + "')" + "AND {tbl_srvmast1.Act_Email}='" + DropDownList5.SelectedItem.Text + "'" + "AND{tbl_srvmast1.Req_Status}='" + DropDownList2.SelectedItem.Text + "'";
                CrystalReportViewer1.RefreshReport();
            }
        }
        protected void btest_Click(object sender, EventArgs e)
        {
            MySqlConnection conexion = new MySqlConnection(con);

            conexion.Open();
            Boolean      band  = false;
            MySqlCommand query = conexion.CreateCommand();

            query.CommandText = "SELECT * FROM bitacoraencabezado";
            MySqlDataReader red   = query.ExecuteReader();
            Boolean         band2 = false;
            Boolean         band3 = false;
            Boolean         band4 = false;



            while (red.Read())
            {
                if (ddllista.SelectedIndex == 1)
                {
                    if (string.Compare(txfecha1.Text, red["fecha"].ToString()) != 0 && string.Compare(txfecha2.Text, red["fecha"].ToString()) != 0)
                    {
                        band = true;
                    }
                }
                else
                {
                    if (ddllista.SelectedIndex == 2)
                    {
                        if (string.Compare(txfecha1.Text, red["fecha"].ToString()) != 0 && string.Compare(txfecha2.Text, red["fecha"].ToString()) != 0)
                        {
                            band2 = true;
                        }
                    }
                    else
                    {
                        if (ddllista.SelectedIndex == 3)
                        {
                            if (string.Compare(txfecha1.Text, red["fecha"].ToString()) != 0 && string.Compare(txfecha2.Text, red["fecha"].ToString()) != 0)
                            {
                                band3 = true;
                            }
                        }
                        else
                        {
                            if (ddllista.SelectedIndex == 4)
                            {
                                if (string.Compare(txfecha1.Text, red["fecha"].ToString()) != 0 && string.Compare(txfecha2.Text, red["fecha"].ToString()) != 0)
                                {
                                    band4 = true;
                                }
                            }
                            else
                            {
                                if (ddllista.SelectedIndex == 0)
                                {
                                    Response.Write("<script language=javascript>alert('No has seleccionado ninguna opción de consulta')</script>");
                                    break;
                                }
                            }
                        }
                    }
                }
            }
            if (band)
            {
                MySqlConnection conex = new MySqlConnection(con);
                conex.Open();
                MySqlCommand quer = conex.CreateCommand();
                quer.CommandText = "SELECT hs,hr,tiemporuta, fecha FROM bitacoraencabezado where fecha BETWEEN '" + txfecha1.Text + "' and '" + txfecha2.Text + "'";
                MySqlDataReader re = quer.ExecuteReader();
                Chart1.Visible = true;
                string aux1, aux2;
                int    sum = 0, cont = 0;
                double totalh;
                while (re.Read())
                {
                    aux1 = re["hs"].ToString();
                    aux2 = re["hr"].ToString();
                    String[] shs  = aux1.Split(':');
                    String[] shr  = aux2.Split(':');
                    int      dmin = (Convert.ToInt32(shr[1]) - Convert.ToInt32(shs[1]));
                    if (dmin < 0)
                    {
                        dmin = dmin + 60;
                    }
                    int dhor = ((Convert.ToInt32(shr[0]) - Convert.ToInt32(shs[0])) * 60);
                    int dh   = dmin + dhor;
                    sum  = sum + dh;
                    cont = cont + 1;

                    Chart1.DataSource = re;
                    Chart1.Series["X"].XValueMember  = "";
                    Chart1.Series["Y"].YValueMembers = "tiemporuta";
                    Chart1.DataBind();
                }
                conex.Close();
                totalh = sum / cont;
            }

            if (band2)
            {
                MySqlConnection conex = new MySqlConnection(con);
                conex.Open();
                MySqlCommand quer = conex.CreateCommand();
                quer.CommandText = "SELECT kmInic,KmFin,kmrec FROM bitacoraencabezado where fecha BETWEEN '" + txfecha1.Text + "' and '" + txfecha2.Text + "'";
                MySqlDataReader re = quer.ExecuteReader();
                Chart2.Visible = true;
                List <int> por = new List <int>();
                while (re.Read())
                {
                    Double kmi = Convert.ToDouble(re["kmInic"].ToString());
                    Double kmf = Convert.ToDouble(re["kmFin"].ToString());
                    //double kmin = double.Parse(kmi);
                    //double kmfin = double.Parse(kmf);
                    por.Add((Convert.ToInt32(re["kmrec"].ToString())));
                    Double tot   = kmf - kmi;
                    String total = Convert.ToString(tot);
                    Chart2.DataSource = re;
                    Chart2.Series["X"].XValueMember  = "";
                    Chart2.Series["Y"].YValueMembers = "kmrec";
                    Chart2.DataBind();
                }

                conex.Close();
                int x = por.Count;
                int sum = 0, totalp;
                foreach (int li in por)
                {
                    sum = sum + li;
                }
                totalp = sum / x;
            }
            else
            {
            }

            if (band3)
            {
                MySqlConnection conex = new MySqlConnection(con);
                conex.Open();
                MySqlCommand quer = conex.CreateCommand();
                quer.CommandText = "SELECT noRem from bitacoraencabezado where fecha BETWEEN '" + txfecha1.Text + "' and '" + txfecha2.Text + "'";
                MySqlDataReader re = quer.ExecuteReader();
                Chart3.Visible = true;
                while (re.Read())
                {
                    Chart3.DataSource = re;
                    Chart3.Series["X"].XValueMember  = "";
                    Chart3.Series["Y"].YValueMembers = "noRem";
                    Chart3.DataBind();
                }
                quer.CommandText = "SELECT count(noRem) from bitacoraencabezado ";
            }
            else
            {
            }

            if (band4)
            {
            }
            else
            {
            }
            conexion.Close();
        }