private void LoadChartData2() { Chart2.ChartAreas[0].AxisX.MajorGrid.Enabled = false; Chart2.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; Chart2.DataBind(); Chart2.Series["Series1"].Points.DataBindXY(dv, "City_nm", dv, "Count"); gv_data.DataMember = "tbl_stat_datewise_cnt"; gv_data.DataSource = table; gv_data.DataBind(); }
protected void medchart_SelectedIndexChanged(object sender, EventArgs e) { //SqlConnection con = new SqlConnection(WebConfigurationManager.ConnectionStrings["medDb"].ConnectionString); //con.Open(); //SqlCommand command = new SqlCommand("Select Sales.Purchase_Date, SUM() from MedicineMaster", con); //SqlDataReader reader = command.ExecuteReader(); if (medchart.SelectedValue != "Month" && medchart.SelectedValue != "Select") { SqlConnection con = new SqlConnection(WebConfigurationManager.ConnectionStrings["medDb"].ConnectionString); con.Open(); SqlCommand command = new SqlCommand("Select Sales.Purchase_Date,SUM(SalesInfo.Quantity) as whatis from Sales,SalesInfo where SalesInfo.Sales_ID = Sales.Sales_ID AND SalesInfo.Med_ID=@id and Sales.Purchase_Date > @temp group by Sales.Purchase_Date ", con); command.Parameters.AddWithValue("@temp", DateTime.Now.AddDays(-30)); command.Parameters.AddWithValue("@id", medchart.SelectedValue); SqlDataReader reader = command.ExecuteReader(); if(!reader.Read()) { er.Text = "No Value Found For the MedID"; } reader.Close(); SqlDataReader reader2 = command.ExecuteReader(); Chart2.DataSource = reader2; Chart2.Series["Series1"].XValueMember = "Purchase_Date"; Chart2.Series["Series1"].YValueMembers = "whatis"; Chart2.ChartAreas[0].AxisX.LabelStyle.Format = "MM-dd"; Chart2.DataBind(); reader2.Close(); } else if(medchart.SelectedValue != "Select") { SqlConnection con = new SqlConnection(WebConfigurationManager.ConnectionStrings["medDb"].ConnectionString); con.Open(); SqlCommand command = new SqlCommand("Select Sales.Purchase_Date,SUM(SalesInfo.Quantity) as whatis from Sales,SalesInfo where SalesInfo.Sales_ID = Sales.Sales_ID and Sales.Purchase_Date > @temp group by Sales.Purchase_Date ", con); command.Parameters.AddWithValue("@temp", DateTime.Now.AddDays(-30)); SqlDataReader reader = command.ExecuteReader(); Chart2.DataSource = reader; Chart2.Series["Series1"].XValueMember = "Purchase_Date"; Chart2.Series["Series1"].YValueMembers = "whatis"; Chart2.ChartAreas[0].AxisX.LabelStyle.Format = "MM-dd"; Chart2.DataBind(); reader.Close(); } }
protected void DropDownList2_SelectedIndexChanged(object sender, EventArgs e) { switch (DropDownList1.SelectedIndex) { case 0: Chart2.Series[0].ChartType = System.Web.UI.DataVisualization.Charting.SeriesChartType.Bar; break; case 1: Chart2.Series[0].ChartType = System.Web.UI.DataVisualization.Charting.SeriesChartType.Pie; break; case 2: Chart2.Series[0].ChartType = System.Web.UI.DataVisualization.Charting.SeriesChartType.Area; break; default: Chart2.Series[0].ChartType = System.Web.UI.DataVisualization.Charting.SeriesChartType.Column; break; } switch (DropDownList2.SelectedIndex) { case 0: SqlDataSource2.SelectCommand = $"SELECT [ZipCode], count([id]) as count FROM [Donation] WHERE Veg = 'True' GROUP BY [ZipCode]"; break; case 1: SqlDataSource2.SelectCommand = $"SELECT [ZipCode], count([id]) as count FROM [Donation] WHERE Cooked = 'True' GROUP BY [ZipCode]"; break; case 2: SqlDataSource2.SelectCommand = $"SELECT [ZipCode], sum([Weight]) as count FROM [Donation] GROUP BY [ZipCode]"; break; case 3: SqlDataSource2.SelectCommand = $"SELECT [ZipCode], count([id]) as count FROM [Donation] WHERE Price IS NOT NULL GROUP BY [ZipCode]"; break; default: break; } Chart2.DataBind(); }
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(); } } }
private void FillData_BarChart() { DataTable dt = CM_Main.GetData("COLUMNCHART1"); if (dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { Chart2.DataSource = dt; Chart2.Series["Series1"].XValueMember = "FULL_NAME"; Chart2.Series["Series1"].YValueMembers = "NUMBEROFJOBS"; Chart2.DataBind(); Chart2.Series["Series1"].ChartType = SeriesChartType.Column; // Chart2.Series["Series1"]["DrawingStyle"] = "Emboss"; // Chart2.ChartAreas["ChartArea2"].Area3DStyle.Enable3D = true; // Chart2.ChartAreas["ChartArea2"].AxisX.Interval = 1; // Chart2.Series["Series1"].Points[i].Color = Color.FromArgb(48, 54, 65); Chart2.ChartAreas["ChartArea2"].AxisX.MajorGrid.Enabled = false; Chart2.ChartAreas["ChartArea2"].AxisY.MajorGrid.Enabled = false; Chart2.ChartAreas["ChartArea2"].AxisX.LineWidth = 0; Chart2.ChartAreas["ChartArea2"].AxisY.LineWidth = 0; Chart2.ChartAreas["ChartArea2"].AxisX.LabelStyle.Enabled = false; Chart2.ChartAreas["ChartArea2"].AxisY.LabelStyle.Enabled = false; Chart2.ChartAreas["ChartArea2"].AxisY.MajorTickMark.Enabled = false; Chart2.ChartAreas["ChartArea2"].AxisY.MinorTickMark.Enabled = false; Chart2.ChartAreas["ChartArea2"].AxisX.MajorTickMark.Enabled = false; Chart2.ChartAreas["ChartArea2"].AxisX.MinorTickMark.Enabled = false; Chart2.Series["Series1"].IsValueShownAsLabel = false; } Chart2.Series["Series1"].ToolTip = "#VALX : #VALY";//new } }
private void LoadChartData() { Chart2.ChartAreas[0].AxisX.MajorGrid.Enabled = false; Chart2.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; Chart2.DataBind(); Chart2.Series["Sony"].Points.DataBindXY(dv, "Ddate", dv, "cat1"); Chart2.Series["Canon"].Points.DataBindXY(dv, "Ddate", dv, "cat2"); Chart2.Series["Nikon"].Points.DataBindXY(dv, "Ddate", dv, "cat3"); getdata(); }
private void getRevenueChart() { using (SqlConnection conn = new SqlConnection(connStr)) { SqlCommand cmd2 = new SqlCommand ("SELECT SUM(Payment.TotalPayed) AS Revenue, MONTH(Payment.DateOfPurchase) AS Monthly FROM Payment Group BY MONTH(Payment.DateOfPurchase)", conn); conn.Open(); SqlDataReader rdr2 = cmd2.ExecuteReader(); // Specify the column name that contains values for X-Axis Chart2.Series["Series2"].XValueMember = "Monthly"; // Specify the column name that contains values for Y-Axis Chart2.Series["Series2"].YValueMembers = "Revenue"; // Set the datasource Chart2.DataSource = rdr2; // Finally call DataBind() Chart2.DataBind(); } }
public void DataBindChart2() { if (job2Result != null && job2Result.Count > 0) { Dictionary <string, float> selected = new Dictionary <string, float>(); job2Result.Where(t => t.Key.Split('-')[0].Equals(DropDownList1.SelectedValue)) .OrderBy(t => t.Value) .ToList() .ForEach(t => { selected.Add(t.Key.Split('-')[1], t.Value); }); Chart2.DataSource = selected; Chart2.Series["Series1"].XValueMember = "Key"; Chart2.Series["Series1"].YValueMembers = "Value"; Chart2.DataBind(); } }
private void _setGraphFual(DataSet iDsSet) { DundasCharts.DundasChartBase(Chart2, ChartImageType.Flash, 300, 300 , BorderSkinStyle.None, Color.FromArgb(181, 64, 1), 0 , Color.FromArgb(247, 243, 247) , Color.FromArgb(0xFF, 0xFF, 0xFE), Color.FromArgb(0x20, 0x80, 0xD0), ChartDashStyle.Solid , -1 , Dundas.Charting.WebControl.ChartHatchStyle.None, Dundas.Charting.WebControl.GradientType.None, Dundas.Charting.WebControl.AntiAliasing.Graphics); Series series1 = DundasCharts.CreateSeries(Chart2, "Series1", "Default", "", null, SeriesChartType.Funnel, 0, Color.FromArgb(0x5A, 0x7D, 0xDE), Color.FromArgb(0x4A, 0x58, 0x7E), Color.FromArgb(64, 0, 0, 0), 1, 9, Color.FromArgb(64, 64, 64)); Chart2.Series["Series1"].Type = SeriesChartType.Funnel; // Set funnel Y values style Chart2.Series["Series1"]["FunnelStyle"] = "YIsHeight"; // Set funnel data point labels style Chart2.Series["Series1"]["FunnelLabelStyle"] = "Outside"; // Place labels on the left side Chart2.Series["Series1"]["FunnelOutsideLabelPlacement"] = "Left"; // Set gap between points Chart2.Series["Series1"]["FunnelPointGap"] = "2"; // Set minimum point height Chart2.Series["Series1"]["FunnelMinPointHeight"] = "1"; // Set 3D mode Chart2.ChartAreas["Default"].Area3DStyle.Enable3D = true; // Set 3D angle Chart2.Series["Series1"]["Funnel3DRotationAngle"] = "7"; // Set 3D drawing style Chart2.Series["Series1"]["Funnel3DDrawingStyle"] = "CircularBase"; Chart2.DataSource = iDsSet; Chart2.Series[series1.Name].ValueMembersY = "PRICE"; Chart2.Series[series1.Name].ValueMemberX = "CODE"; Chart2.DataBind(); }
private void LoadChartData2() { string from = ddl_frommonth.Text + "/" + ddl_fromdate.Text + "/" + ddl_fromyear.Text; string to = ddl_tomonth.Text + "/" + ddl_todate.Text + "/" + ddl_toyear.Text; Chart2.ChartAreas[0].AxisX.MajorGrid.Enabled = false; Chart2.ChartAreas[0].AxisY.MajorGrid.Enabled = false; string query = "SELECT Ddate,Vcount from tbl_show_all_graph where Ddate between '" + from + "' AND '" + to + "'"; SqlDataAdapter da = new SqlDataAdapter(query, con); DataTable table = new DataTable(); da.Fill(table); DataView dv = table.DefaultView; Chart2.DataBind(); Chart2.Series["Series1"].Points.DataBindXY(dv, "Ddate", dv, "VCount"); getdata(); }
protected void Page_Load(object sender, EventArgs e) { DataTable dt1 = CreateDataTable("旷课", ""); Chart1.DataSource = dt1; Chart1.Series[0].YValueMembers = "number"; Chart1.Series[0].XValueMember = "department"; Chart1.DataBind(); DataTable dt2 = CreateDataTable("迟到", ""); Chart2.DataSource = dt2; Chart2.Series[0].YValueMembers = "number"; Chart2.Series[0].XValueMember = "department"; Chart2.DataBind(); }
public void loadchart2() { try { SqlConnectionStringBuilder builder = new SqlConnectionStringBuilder(); builder.ConnectionString = ConfigurationManager.AppSettings["connsr"]; using (SqlConnection connection = new SqlConnection(builder.ConnectionString)) { connection.Open(); StringBuilder sb = new StringBuilder(); //sb.Append("SELECT TOP 1 label, confidence, ConnectionDeviceGenerationId, EnqueuedTime, inserttime FROM visionkitinputs order by EnqueuedTime desc"); sb.Append("select max(EnqueuedTime) as EnqueuedTime, Avg(confidence) as confidence "); sb.Append("from visionkitinputs "); sb.Append("where EnqueuedTime between dateadd(dd,-1,getUTCdate()) and getUTCdate() "); sb.Append("group by DATEPART(hour, EnqueuedTime) "); sb.Append("order by EnqueuedTime desc"); String sql = sb.ToString(); using (SqlCommand command = new SqlCommand(sql, connection)) { using (SqlDataReader reader = command.ExecuteReader()) { Chart2.DataSource = reader; Chart2.Series[0].YValueMembers = "confidence"; Chart2.Series[0].XValueMember = "EnqueuedTime"; Chart2.DataBind(); } } } } catch (Exception ex) { errortxt.Text = "Error: " + ex.Message.ToString() + System.Environment.NewLine; errortxt.Text += "Error: " + ex.StackTrace.ToString() + System.Environment.NewLine; //throw ex; } }
protected void DropDownList2_SelectedIndexChanged(object sender, EventArgs e) { if (!DropDownList2.SelectedValue.Equals("-1")) { GridView6.Visible = true; GridView5.Visible = true; Chart2.Visible = true; Label4.Text = DropDownList2.SelectedItem.Text + "Overall Results"; GridView5.DataBind(); GridView6.DataBind(); Chart2.DataBind(); } else { GridView6.Visible = false; GridView5.Visible = false; Chart2.Visible = false; Label4.Text = "No Semester Selected!"; } }
protected void Button1_Click(object sender, EventArgs e) { Chart1.DataSource = sv.DemLuot(int.Parse(DropDownList1.SelectedValue)); Chart1.Legends.Add("average_marks").Title = "Biểu đồ lượt thuê xe"; Chart1.ChartAreas["ChartArea1"].AxisY.Title = " Số Lượt Thuê"; Chart1.ChartAreas["ChartArea1"].AxisX.Title = "Xe"; Chart1.Series["SoLuot"].XValueMember = "Xe"; Chart1.Series["SoLuot"].YValueMembers = "SoLuot"; Chart1.DataBind(); Chart2.DataSource = sv.ThongKeTienTam(int.Parse(DropDownList1.SelectedValue)); Chart2.Legends.Add("average_marks").Title = "Biểu đồ doanh thu xe"; Chart2.ChartAreas["ChartArea1"].AxisY.Title = "Tiền doanh thu"; Chart2.ChartAreas["ChartArea1"].AxisX.Title = "Xe"; Chart2.Series["VND"].XValueMember = "BangSo"; Chart2.Series["VND"].YValueMembers = "ThanhTien"; Chart2.DataBind(); Literal1.Text = "Doanh Thu trong tháng : " + sv.ThongKeTienThang(int.Parse(DropDownList1.SelectedValue)) + " VND";; }
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"; }
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; }
protected void ListarGrafico() { string IDE_OBJETIVO = string.Empty; if (ddlObejtivos.SelectedIndex == 0) { IDE_OBJETIVO = string.Empty; } else { IDE_OBJETIVO = ddlObejtivos.SelectedValue.ToString(); } BL_RRHH_DESEMPENIO_OBJETIVOS obj = new BL_RRHH_DESEMPENIO_OBJETIVOS(); DataTable dtResultado = new DataTable(); dtResultado.Clear(); dtResultado = obj.uspSEL_RRHH_DESEMPENIO_GRAFICO(lblPersonal.Text, Convert.ToInt32(Session["ANIO"]), IDE_OBJETIVO); DataTable dt = dtResultado; /* * 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]["OBJ"].ToString(); * y[i] = Convert.ToInt32(dt.Rows[i]["AVANCE"]); * } * Chart1.Series["Series1"].Points.DataBindXY(x, y); * * Chart1.Series[0].ChartType = SeriesChartType.Column; * Chart1.Series["Series1"].Label = "#PERCENT"; * Chart1.Series[0].LegendText = "#VALX"; * Chart1.ChartAreas["ChartArea1"].Area3DStyle.Enable3D = true; * Chart1.Legends["Series1"].Enabled = true; * * * string[] x2 = new string[dt.Rows.Count]; * int[] y2 = new int[dt.Rows.Count]; * string[] l2 = new string[dt.Rows.Count]; * for (int i = 0; i < dt.Rows.Count; i++) * { * x2[i] = dt.Rows[i]["obj2"].ToString(); * y2[i] = Convert.ToInt32(dt.Rows[i]["TOTAL_TRANSCURRIDOS"]); * l2[i] = dt.Rows[i]["LEYENDA_TRANSCURRIDOS"].ToString(); * * } * Chart2.Series[0].Points.DataBindXY(x2, y2); * Chart2.Series[0].ToolTip = l2.ToString(); * Chart2.Series[0].IsValueShownAsLabel = true; * Chart2.Series[0].ChartType = SeriesChartType.Column; */ //Chart1.ResetAutoValues(); Chart1.Series[0].Points.Clear(); Chart1.Series["Series1"].Points.Clear(); Chart1.ResetAutoValues(); Chart1.DataSource = dtResultado; Chart1.DataBind(); Chart1.Series[0].IsValueShownAsLabel = true; //Chart1.Series["Series1"].Label = "#PERCENT"; Chart2.DataSource = dtResultado; Chart2.DataBind(); Chart2.Series[0].IsValueShownAsLabel = true; Chart2.Series[1].IsValueShownAsLabel = true; Chart2.Series[0].LegendText = "Días transcurridos"; Chart2.Series[1].LegendText = "Total de días"; }
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 buildBarChart(string country, string type, DateTime dateStart, DateTime dateEnd) { String myConnect = ConfigurationManager.ConnectionStrings["EADPConnectionString2"].ToString(); SqlConnection myConn = new SqlConnection(myConnect); DataSet ds = new DataSet(); String strSQL = "SELECT location, avg(cost) as cost FROM [dbo].[Trip] "; if (!country.Equals("All")) { strSQL += "where location = @paraCountry "; strSQL += "and status != 'Cancelled' "; } if (!type.Equals("All") && (!country.Equals("All"))) { strSQL += "and triptype = @paratype "; strSQL += "and status != 'Cancelled' "; } else if (!type.Equals("All") && (country.Equals("All"))) { strSQL += "where triptype = @paratype "; strSQL += "and status != 'Cancelled' "; } if ((!dateStart.Equals("") || (!dateEnd.Equals(""))) && (country.Equals("All")) && (type.Equals("All"))) { strSQL += "where TRIPSTART BETWEEN @paradateStart and @paradateEnd "; strSQL += "and status != 'Cancelled' "; } else if ((!dateStart.Equals("") || (!dateEnd.Equals(""))) && (!country.Equals("All")) && (type.Equals("All"))) { strSQL += "and TRIPSTART BETWEEN @paradateStart and @paradateEnd "; strSQL += "and status != 'Cancelled' "; } else if ((!dateStart.Equals("") || (!dateEnd.Equals(""))) && (country.Equals("All")) && (!type.Equals("All"))) { strSQL += "and TRIPSTART BETWEEN @paradateStart and @paradateEnd "; strSQL += "and status != 'Cancelled' "; } else if ((!dateStart.Equals("") || (!dateEnd.Equals(""))) && (!country.Equals("All")) && (!type.Equals("All"))) { strSQL += "and TRIPSTART BETWEEN @paradateStart and @paradateEnd "; strSQL += "and status != 'Cancelled' "; } strSQL += "group by location"; SqlDataAdapter da = new SqlDataAdapter(strSQL.ToString(), myConn); if (!country.Equals("All")) { da.SelectCommand.Parameters.AddWithValue("@paraCountry", country); } if (!type.Equals("All")) { da.SelectCommand.Parameters.AddWithValue("@paratype", type); } if (!dateStart.Equals("")) { da.SelectCommand.Parameters.AddWithValue("@paradateStart", dateStart); } if (!dateEnd.Equals("")) { da.SelectCommand.Parameters.AddWithValue("@paradateEnd", dateEnd); } da.Fill(ds, "tripTable"); Chart2.DataSource = ds; Chart2.DataBind(); string imgPathing2 = HttpContext.Current.Request.PhysicalApplicationPath + tmpChartName2; Chart2.SaveImage(imgPathing2); }
private void _setGraph(DataSet dsPie, DataSet dsLine) { // Line GRAPH DundasCharts.DundasChartBase(Chart2, ChartImageType.Flash, 550, 300 , BorderSkinStyle.Emboss, Color.FromArgb(181, 64, 1), 2 , Color.FromArgb(0xFF, 0xFF, 0xFE) , Color.FromArgb(0xFF, 0xFF, 0xFE), Color.FromArgb(0x20, 0x80, 0xD0), ChartDashStyle.Solid , -1 , ChartHatchStyle.None, GradientType.TopBottom, AntiAliasing.None); Series[] oasrType = new Series[dsLine.Tables[0].Rows.Count]; int intLP = 0; foreach (DataRow row in dsLine.Tables[0].Rows) { oasrType[intLP] = DundasCharts.CreateSeries(Chart2, "Series" + intLP.ToString(), Chart2.ChartAreas[0].Name, row["GBN_NM"].ToString(), null, SeriesChartType.Line, 3, GetChartColor(intLP), GetChartColor(intLP), Color.FromArgb(64, 0, 0, 0), 1, 9, Color.FromArgb(64, 64, 64)); for (int colIndex = 1; colIndex < dsLine.Tables[0].Columns.Count; colIndex++) { string columnName = dsLine.Tables[0].Columns[colIndex].ColumnName; double YVal = double.Parse(row[columnName].ToString()); Chart2.Series[oasrType[intLP].Name].Points.AddXY(columnName, YVal); } intLP += 1; } DundasAnimations.DundasChartBase(Chart2, AnimationTheme.None, -1, -1, false, 1); for (int i = 0; i < oasrType.Length; i++) { if (i == 0) { DundasAnimations.GrowingAnimation(Chart2, oasrType[i], 0.5, 1.0, true); } else { DundasAnimations.GrowingAnimation(Chart2, oasrType[i], i + 0.1, 1.0, true); } oasrType[i].MarkerStyle = GetMarkerStyle(i); oasrType[i].MarkerColor = GetChartColor(i); oasrType[i].MarkerBorderColor = GetChartColor(i); } Chart2.ChartAreas[0].AxisY.LabelStyle.Format = "#,###"; Chart2.DataSource = dsLine.Tables[0].DefaultView; Chart2.DataBind(); // PIE GRAPH DundasCharts.DundasChartBase(Chart1, ChartImageType.Flash, 250, 300 , BorderSkinStyle.Emboss, Color.FromArgb(181, 64, 1), 2 , Color.FromArgb(0xFF, 0xFF, 0xFE) , Color.FromArgb(0xFF, 0xFF, 0xFE), Color.FromArgb(0x20, 0x80, 0xD0), ChartDashStyle.Solid , -1 , ChartHatchStyle.None, GradientType.TopBottom, AntiAliasing.None); Series serPie = DundasCharts.CreateSeries(Chart1, "Series1", "Default", "고객상태별점유율", null, SeriesChartType.Pie, 1, Color.FromArgb(0x5A, 0x7D, 0xDE), Color.FromArgb(0x4A, 0x58, 0x7E), Color.FromArgb(64, 0, 0, 0), 1, 9, Color.FromArgb(64, 64, 64)); Chart1.Series[serPie.Name].ValueMemberX = "GBN_NM"; Chart1.Series[serPie.Name].ValueMembersY = "FNL_QNT"; serPie.FontColor = Color.White; Chart1.DataSource = dsPie; Chart1.DataBind(); }
protected void btnBargraph_Click(object sender, EventArgs e) { if (ddlFocusgroup.Text == "All" && ddlCatagory.Text == "All") { Chart2.DataSourceID = "ShowAll"; } else if (ddlFocusgroup.Text == "All") { Chart2.DataSourceID = "SqlDataAllforFocusGroup"; } else if (ddlCatagory.Text == "All") { Chart2.DataSourceID = "SqlDataAllforCatagory"; } else { Chart2.DataSourceID = "SqlDSDummary"; } Chart2.DataBind(); Chart2.Visible = true; GridView2.Columns[0].Visible = true; btnBargraph.Enabled = false; btnDetaildDispplay.Visible = true; /*SqlConnection conn = new SqlConnection(); * conn.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["ConnectionString"].ToString(); * SqlCommand cmd = new SqlCommand(); * cmd.Connection = conn; * * cmd.CommandText = * "SELECT AVG(Responses.Response) AS 'Average' FROM Responses INNER JOIN Question ON Responses.ID = Question.ID WHERE Question.Focus_Group='" + * ddlFocusgroup.Text +"'" + * "AND Question.Catagory ='"+ ddlCatagory.Text+"'"; * * * conn.Open(); * SqlDataReader rdr=cmd.ExecuteReader(); * * List<int> average = new List<int>(); * * while(rdr.Read()) * { * * average.Add(Convert.ToInt32(rdr["Average"])); * } * conn.Close(); * * Session["Average"] = average; * Response.Redirect("DetailedDisplay.aspx"); * * conn.Close();*/ //Session["Focus_Group"] = ddlFocusgroup.Text; //Session["Catagory"] = ddlCatagory.Text; //Response.Redirect("BarChart.aspx"); }
protected void EmployeeViewButton_Click(object sender, EventArgs e) { int pid = getpersonalid(EnameTextBox.Text); string empid = getemployeeid(pid); //load attendance record loadattendance(EmpFromDate.Text, EmpToDate.Text); DataTable dt = new DataTable(); dt.Columns.Add("Date"); dt.Columns.Add("PunchInTime"); dt.Columns.Add("PunchOutTime"); dt.Columns.Add("Status"); int fullday = 0; int halfday = 0; int absent = 0; foreach (var attendance in attendances) { if (attendance.EmployeeId.Equals(empid)) { DataRow row = dt.NewRow(); row["Date"] = attendance.PunchInDate.ToShortDateString(); row["PunchInTime"] = attendance.PunchInTime; row["PunchOutTime"] = attendance.PunchOutTime; if (attendance.WorkingHours == 8.0) { fullday++; row["Status"] = "Present(Full Day)"; } else if (attendance.WorkingHours == 4.0) { halfday++; row["Status"] = "Present(Half Day)"; } else if (attendance.WorkingHours == 0.0) { absent++; row["Status"] = "Absent"; } dt.Rows.Add(row); } } GridView1.DataSource = dt; GridView1.DataBind(); //bind data with chart DataTable dt1 = new DataTable(); dt1.Columns.Add("Status"); dt1.Columns.Add("Days"); List <string> status = new List <string>(); status.Add("Present(Full Day)"); status.Add("Present(Half Day)"); status.Add("Absent"); List <int> days = new List <int>(); days.Add(fullday); days.Add(halfday); days.Add(absent); for (int i = 0; i < 3; i++) { DataRow row = dt1.NewRow(); row["Status"] = status[i]; row["Days"] = days[i]; dt1.Rows.Add(row); } Chart2.DataSource = dt1; Chart2.DataBind(); PrintButton.Visible = true; }
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(); }
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(); } }
protected void Button1_Click(object sender, EventArgs e) { GridView1.Visible = false; Button1.Visible = false; string apid = Request.QueryString["apid"].ToString(); DataTable dt = cs.select("select * from rating where apid='" + apid + "' and status!='fraud' "); for (int i = 0; i < dt.Rows.Count; i++) { string review = dt.Rows[i]["comment"].ToString(); string[] tmp = review.Split(' '); int ngcount = review.Count(); int ccv = 0; int negcunt = 0; int poscount = 0; int posv = 0; DataTable ng = cs.select("select * from negativedataset"); if (ng.Rows.Count > 0) { int h = tmp.Length; for (int j = 0; j < tmp.Length; j++) { int flag = 0; string cc = tmp[j].ToLower(); string negwrd = ""; for (int f = 0; f < cc.Length; f++) { if (cc[f] >= 'a' && cc[f] <= 'z') { negwrd += cc[f]; } } for (int n = 0; n < ng.Rows.Count; n++) { string neg = ng.Rows[n]["negativewords"].ToString().ToLower(); if (neg == negwrd) { negcunt = negcunt + 1; } ccv = negcunt; //Label1.Text = ccv.ToString(); } } } DataTable vb = cs.select("select * from positivewords"); //int h = tmp.Length; for (int j = 0; j < tmp.Length; j++) { string cc = tmp[j].ToLower(); string postwrd = ""; for (int f = 0; f < cc.Length; f++) { if (cc[f] >= 'a' && cc[f] <= 'z') { postwrd += cc[f]; } } for (int n = 0; n < vb.Rows.Count; n++) { string pos = vb.Rows[n]["positivewords"].ToString().ToLower(); if (pos == postwrd) { poscount = poscount + 1; } posv = poscount; //Label1.Text = posv.ToString(); } } if (ccv > posv) { //Label1.Text = "negative"; int rid = Convert.ToInt32(dt.Rows[i]["rid"]); int a = cs.insert("update rating set status='negative' where rid='" + rid + "' "); } else if (ccv < posv) { //Label1.Text = "positive"; int rid = Convert.ToInt32(dt.Rows[i]["rid"]); int a = cs.insert("update rating set status='positive' where rid='" + rid + "' "); } else { //Label1.Text = "neutral"; int rid = Convert.ToInt32(dt.Rows[i]["rid"]); int a = cs.insert("update rating set status='neutral' where rid='" + rid + "' "); } } DataTable fd = cs.select("select distinct status, count(status) as negative from rating where apid='" + apid + "' and status='negative' group by status union select distinct status, count(status) as positive from rating where apid='" + apid + "' and status = 'positive' group by status union select distinct status, count(status) as neutral from rating where apid='" + apid + "' and status = 'neutral' group by status"); Chart2.DataSource = fd; Chart2.Series[0].ChartType = SeriesChartType.RangeColumn; //Chart2.Legends[0].Enabled = true; Chart2.Series[0].XValueMember = "status"; Chart2.Series[0].YValueMembers = "negative"; Chart2.DataBind(); }
private void CargarGrafico(string strTipoGrafico, DataTable dtDatos, DataTable dtParam) { DataTable dt = new DataTable(); DataRow row; UsersTreatments.StrCon = axVarSes.Lee <string>("strCon"); UsersTreatments.UserId = Convert.ToInt32(axVarSes.Lee <string>("strPersonId")); UsersTreatments.BodyPartId = Convert.ToInt32(axVarSes.Lee <string>("strBodyPartId")); UsersTreatments.InjuryId = Convert.ToInt32(axVarSes.Lee <string>("strInjuryId")); UsersTreatments.WaveId = Convert.ToInt32(axVarSes.Lee <string>("strWaveId")); UsersTreatments.TreatmentId = Convert.ToInt32(axVarSes.Lee <string>("strTreatmentId")); int i, j; Chart2.Visible = true; gvDatos2.Visible = true; gvDatos2.DataSource = UsersTreatments.SeeInjuryProgress(); gvDatos2.DataBind(); try { for (i = 1; i <= Convert.ToInt16(dtParam.Rows[0][5]); i++) { dt.Columns.Add("Valor" + i); } dt.Columns.Add("Descripcion"); for (i = 0; i < gvDatos2.Rows.Count; i++) { row = dt.NewRow(); //for (j = 1; j <= Convert.ToInt16(dtParam.Rows[0][5]); j++) //{ row["Valor" + 1] = gvDatos2.Rows[i].Cells[4].Text; // j+3 //} row["Descripcion"] = Server.HtmlDecode(gvDatos2.Rows[i].Cells[5].Text); dt.Rows.Add(row); } Chart2.DataSource = dt; // Adicionar las series Chart2.Series.Clear(); for (i = 1; i <= Convert.ToInt16(dtParam.Rows[0][5]); i++) { Chart2.Series.Add("Series" + i); } for (i = 1; i <= Convert.ToInt16(dtParam.Rows[0][5]); i++) { Chart2.Series["Series" + i].YValueMembers = "Valor" + i; Chart2.Series["Series" + i].XValueMember = "Descripcion"; } // Definir intervalo del eje X Chart2.ChartAreas[0].AxisX.Interval = 1; Chart2.ChartAreas[0].AxisX.IntervalAutoMode = IntervalAutoMode.VariableCount; // Definir título y pie Chart2.Titles.Clear(); Chart2.Titles.Add(dtParam.Rows[0][0].ToString()); Chart2.Titles[0].Font = new Font("Arial", 18, FontStyle.Bold); Chart2.Titles[0].ShadowOffset = 0; // true Chart2.Titles[0].ShadowColor = Color.Black; Chart2.Titles.Add(axVarSes.Lee <string>("StrInjury")); Chart2.Titles[1].Alignment = ContentAlignment.BottomCenter; Chart2.Titles[1].Font = new Font("Arial", 10, FontStyle.Bold); Chart2.Titles.Add(dtParam.Rows[0]["fecha"].ToString()); Chart2.Titles[2].Alignment = ContentAlignment.BottomCenter; Chart2.Titles[2].Font = new Font("Arial", 10, FontStyle.Bold); switch (strTipoGrafico) { case "1": for (i = 1; i <= Convert.ToInt16(dtParam.Rows[0][5]); i++) { Chart2.Series["Series" + i].ChartType = SeriesChartType.Line; Chart2.Series["Series" + i].BorderWidth = 3; Chart2.Series["Series" + i].IsValueShownAsLabel = true; Chart2.Series["Series" + i].IsVisibleInLegend = true; Chart2.Series["Series" + i]["DrawingStyle"] = "Cylinder"; } break; case "2": for (i = 1; i <= Convert.ToInt16(dtParam.Rows[0][5]); i++) { Chart2.Series["Series" + i].ChartType = SeriesChartType.Bar; Chart2.Series["Series" + i]["DrawingStyle"] = "Cylinder"; } break; case "3": for (i = 1; i <= Convert.ToInt16(dtParam.Rows[0][5]); i++) { Chart2.Series["Series" + i].ChartType = SeriesChartType.Line; } break; case "4": for (i = 1; i <= Convert.ToInt16(dtParam.Rows[0][5]); i++) { Chart2.Series["Series" + i].ChartType = SeriesChartType.Area; } break; case "5": for (i = 1; i <= Convert.ToInt16(dtParam.Rows[0][5]); i++) { Chart2.Series["Series" + i].ChartType = SeriesChartType.FastLine; } break; case "6": for (i = 1; i <= Convert.ToInt16(dtParam.Rows[0][5]); i++) { Chart2.Series["Series" + i].ChartType = SeriesChartType.Point; } break; case "7": for (i = 1; i <= Convert.ToInt16(dtParam.Rows[0][5]); i++) { Chart2.Series["Series" + i].ChartType = SeriesChartType.Doughnut; Chart2.Series[0]["PieLabelStyle"] = "Outside"; } break; default: for (i = 1; i <= Convert.ToInt16(dtParam.Rows[0][5]); i++) { Chart2.Series["Series" + i].ChartType = SeriesChartType.Point; } break; } Chart2.ChartAreas["ChartArea1"].AxisX.Title = dtParam.Rows[0][4].ToString(); Chart2.ChartAreas["ChartArea1"].AxisX.TitleFont = new Font("Arial", 12, FontStyle.Bold); Chart2.ChartAreas["ChartArea1"].AxisX.MinorGrid.Enabled = false; Chart2.ChartAreas["ChartArea1"].AxisX.MajorGrid.Enabled = false; Chart2.ChartAreas["ChartArea1"].AxisX.MinorTickMark.Enabled = false; Chart2.ChartAreas["ChartArea1"].AxisX.MajorTickMark.Enabled = false; Chart2.ChartAreas["ChartArea1"].BackColor = Color.AliceBlue; Chart2.ChartAreas["ChartArea1"].BackSecondaryColor = Color.White; Chart2.ChartAreas["ChartArea1"].BackGradientStyle = GradientStyle.TopBottom; Chart2.ChartAreas["ChartArea1"].AxisY.Title = dtParam.Rows[0][3].ToString(); Chart2.ChartAreas["ChartArea1"].AxisY.TitleFont = new Font("Arial", 12, FontStyle.Bold); Chart2.Legends["ChartLegends1"].Docking = Docking.Bottom; Chart2.Legends["ChartLegends1"].Alignment = StringAlignment.Center; Chart2.BorderSkin.SkinStyle = BorderSkinStyle.Emboss; //for (i = 1; i <= Convert.ToInt16(dtParam.Rows[0][5]); i++) //{ Chart2.Series["Series" + 1].IsVisibleInLegend = true; Chart2.Series["Series" + 1].LegendText = gvDatos2.Columns[4].HeaderText; //i+3 //} Chart2.DataBind(); } catch (Exception e) { Chart2.Visible = false; throw; } }
private void DataBindChart() { DataSet d = r.getAllModuleByTerm("Jan-2014"); DataTable ds = new DataTable(); ds.Columns.Add("quiz"); ds.Columns.Add("marks"); //for (int i = 0; i < d.Tables[0].Rows.Count; i++) //{ // DataRow dr = ds.NewRow(); // dr["quiz"] = d.Tables[0].Rows[i][0].ToString(); // dr["marks"] = d.Tables[0].Rows[i][1].ToString(); // ds.Rows.Add(dr); //} //Chart1.DataSource = ds; //Chart1.DataBind(); for (int j = 0; j < d.Tables.Count; j++) { Series sr = new Series(); sr["q"] = d.Tables[j].ToString(); // DataRow dr1= d.Tables[j].NewRow(); //dr1["quiz1"] = d.Tables[j].Rows[j][0].ToString(); //sr.Points.AddXY(dr1["quiz1"], j); for (int i = 0; i < d.Tables[j].Rows.Count; i++) { DataRow dr = ds.NewRow(); dr["quiz"] = d.Tables[j].Rows[i][0].ToString(); dr["marks"] = d.Tables[j].Rows[i][1].ToString(); sr.Points.AddXY(dr["quiz"].ToString(), Convert.ToDouble(dr["marks"].ToString())); ds.Rows.Add(dr); } Chart1.Series.Add(sr); } Chart1.DataSource = ds; Chart1.DataBind(); Chart2.DataSource = ds; Chart2.DataBind(); //Google Chart DataTable dsChartData = ds; StringBuilder strScript = new StringBuilder(); strScript.Append(@"<script type='text/javascript'> google.load('visualization', '1', {packages: ['corechart']});</script> <script type='text/javascript'> function drawVisualization() { var data = google.visualization.arrayToDataTable([ ['quiz', 'marks'],"); foreach (DataRow row in dsChartData.Rows) { strScript.Append("['" + row["quiz"] + "'," + row["marks"] + "],"); } strScript.Remove(strScript.Length - 1, 1); strScript.Append("]);"); strScript.Append("var options = { title : 'Monthly Coffee Production by Country', vAxis: {title: 'Cups'}, hAxis: {title: 'Month'}, seriesType: 'bars', series: {3: {type: 'area'}} };"); strScript.Append(" var chart = new google.visualization.ComboChart(document.getElementById('chart_div')); chart.draw(data, options); } google.setOnLoadCallback(drawVisualization);"); strScript.Append(" </script>"); ltScripts.Text = strScript.ToString(); //Pie Chart StringBuilder strScript1 = new StringBuilder(); strScript1.Append(@"<script type='text/javascript'> google.load('visualization', '1', {packages: ['corechart']}); </script> <script type='text/javascript'> function drawChart() { var data = google.visualization.arrayToDataTable([ ['quiz', 'marks'],"); foreach (DataRow row in dsChartData.Rows) { strScript1.Append("['" + row["quiz"] + "'," + row["marks"] + "],"); } strScript1.Remove(strScript1.Length - 1, 1); strScript1.Append("]);"); strScript1.Append(@" var options = { title: 'My Daily Schedule', is3D: true, }; "); strScript1.Append(@"var chart = new google.visualization.PieChart(document.getElementById('piechart_3d')); chart.draw(data, options); } google.setOnLoadCallback(drawChart); "); strScript1.Append(" </script>"); ltScripts.Text = strScript1.ToString(); }
private void FillAllChartsAndGrids(string QueryDate, string QueryLocation1, string QueryLocation2) { string connectionString = WebConfigurationManager.ConnectionStrings["procyk01ConnectionString"].ConnectionString; try { //~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ string sql = "SELECT complaint, CT "; sql += "FROM complaints "; sql += "WHERE (complaintdate = '" + QueryDate + "') AND (neighborhood = '" + QueryLocation1 + "') "; if (CheckBox1.Checked == true) { sql += "AND complaint NOT IN ('GENERAL CONSTRUCTION', 'NONCONST', 'PAINT - PLASTER', 'PLUMBING', 'ELECTRIC', 'HEATING') "; } ; sql += "ORDER BY CT DESC LIMIT 10"; OdbcConnection con1 = new OdbcConnection(connectionString); OdbcCommand cmdO = new OdbcCommand(sql, con1); con1.Open(); OdbcDataReader reader1 = cmdO.ExecuteReader(); Chart1.DataSource = reader1; Chart1.DataBind(); Chart1.Series["Series1"].ToolTip = "#VALX\nCount: #VALY"; reader1.Close(); con1.Close(); //~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ string sql2 = "SELECT complaint, CT "; sql2 += "FROM complaints "; sql2 += "WHERE (complaintdate = '" + QueryDate + "') AND (neighborhood = '" + QueryLocation2 + "') "; if (CheckBox2.Checked == true) { sql2 += "AND complaint NOT IN ('GENERAL CONSTRUCTION', 'NONCONST', 'PAINT - PLASTER', 'PLUMBING', 'ELECTRIC', 'HEATING') "; } ; sql2 += "ORDER BY CT DESC LIMIT 10"; OdbcConnection con2 = new OdbcConnection(connectionString); OdbcCommand cmd2 = new OdbcCommand(sql2, con2); con2.Open(); OdbcDataReader reader2 = cmd2.ExecuteReader(); Chart2.DataSource = reader2; Chart2.DataBind(); Chart2.Series["Series1"].ToolTip = "#VALX\nCount: #VALY"; reader2.Close(); con2.Close(); //~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ string sql3 = "SELECT Neighborhood, ZipCode, AvgIncome, BelowPovertyLine, Population "; sql3 += "FROM Demographics WHERE (Neighborhood = '" + QueryLocation1 + "') "; sql3 += "ORDER BY ZipCode"; OdbcConnection con3 = new OdbcConnection(connectionString); OdbcCommand cmd3 = new OdbcCommand(sql3, con3); con3.Open(); OdbcDataReader reader3 = cmd3.ExecuteReader(); GridView2.DataSource = reader3; GridView2.DataBind(); reader3.Close(); con3.Close(); //~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ string sql4 = "SELECT Neighborhood, ZipCode, AvgIncome, BelowPovertyLine, Population "; sql4 += "FROM Demographics WHERE (Neighborhood = '" + QueryLocation2 + "') "; sql4 += "ORDER BY ZipCode"; OdbcConnection con4 = new OdbcConnection(connectionString); OdbcCommand cmd4 = new OdbcCommand(sql4, con4); con4.Open(); OdbcDataReader reader4 = cmd4.ExecuteReader(); GridView1.DataSource = reader4; GridView1.DataBind(); reader4.Close(); con4.Close(); Label1.Text = QueryLocation1; Label2.Text = QueryLocation2; } finally { //con1.Close(); } }
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(); }
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(); } } }