public void displayChart()
{
//bind data with chart
DataTable dt1 = new DataTable();
dt1.Columns.Add("Status");
dt1.Columns.Add("Days");
int pending = 0;
int scheduled = 0;
int consumed = 0;
int remained = 0;
for (int i = 0; i < GridView1.Rows.Count; i++)
{
pending = pending + Convert.ToInt32(GridView1.Rows[i].Cells[2].Text);
scheduled = scheduled + Convert.ToInt32(GridView1.Rows[i].Cells[3].Text);
consumed = consumed + Convert.ToInt32(GridView1.Rows[i].Cells[4].Text);
remained = remained + Convert.ToInt32(GridView1.Rows[i].Cells[5].Text);
}
List <string> status = new List <string>();
status.Add("Pending Leave"); status.Add("Scheduled Leave"); status.Add("Consumed Leave"); status.Add("Remained Leave");
List <int> days = new List <int>();
days.Add(pending); days.Add(scheduled); days.Add(consumed); days.Add(remained);
for (int i = 0; i < 4; i++)
{
DataRow row = dt1.NewRow();
row["Status"] = status[i];
row["Days"] = days[i];
dt1.Rows.Add(row);
}
Chart2.DataSource = dt1;
Chart2.DataBind();
}
private void LoadChart2()
{
try
{
//get data from SQL
var tb = from data in _db.tblJobs
select new
{
col1 = data.Month,
col2 = data.AspNet,
col3 = data.PHP
};
//Set chart data source
Chart2.DataSource = tb;
//Set series members names for the X and Y values
Chart2.Series["aspnet"].XValueMember = "col1";
Chart2.Series["aspnet"].YValueMembers = "col2";
Chart2.Series["php"].XValueMember = "col1";
Chart2.Series["php"].YValueMembers = "col3";
//Data bind to the selected data source
Chart2.DataBind();
//name x,y
Chart2.ChartAreas["ChartArea2"].AxisX.Title = "Tháng";
Chart2.ChartAreas["ChartArea2"].AxisY.Title = "Số lượng tuyển dụng";
}
catch (Exception ms)
{
Response.Write(ms.Message);
}
}
void ShowChart2()
{
var data = new ArrayList();
data.Add(new { Product = "衬衫", Sale = 5, Inc = 20 });
data.Add(new { Product = "羊毛衫", Sale = 50, Inc = 60 });
data.Add(new { Product = "裤子", Sale = 15, Inc = 80 });
data.Add(new { Product = "高跟鞋", Sale = 25, Inc = 120 });
data.Add(new { Product = "袜子", Sale = 20, Inc = 300 });
var series = new List <Serie>();
series.Add(new Serie {
Name = "销量", DataField = "Sale", Type = SerieType.Bar
});
series.Add(new Serie {
Name = "增速", DataField = "Inc", Type = SerieType.Line
});
var yAxis = new List <YAxis>();
yAxis.Add(new YAxis()
{
Name = "销量"
});
yAxis.Add(new YAxis()
{
Name = "增速"
});
Chart2.Show(data, "Product", series, "销售情况", yAxis);
}
private void setGrph(DataTable idtSet)
{
DundasCharts.DundasChartBase(Chart1, ChartImageType.Flash, 300, 290
, 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);
DundasCharts.DundasChartBase(Chart2, ChartImageType.Flash, 500, 290
, 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 series1 = 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));
Series series2 = DundasCharts.CreateSeries(Chart2, "Series2", "Default", "계획", null, SeriesChartType.Column, 1, Color.FromArgb(0x5A, 0x7D, 0xDE), Color.FromArgb(0x4A, 0x58, 0x7E), Color.FromArgb(64, 0, 0, 0), 1, 9, Color.FromArgb(64, 64, 64));
series1.FontColor = Color.White;
Chart1.DataSource = idtSet.DefaultView;
Chart1.Series[series1.Name].ValueMemberX = "COL_RNAME";
Chart1.Series[series1.Name].ValueMembersY = "COL_RATE";
Chart1.DataBind();
Chart2.DataSource = idtSet.DefaultView;
Chart2.Series[series2.Name].ValueMemberX = "COL_CNAME";
Chart2.Series[series2.Name].ValueMembersY = "COL_COUNT";
Chart2.DataBind();
}
private void ImageToPdf(Document myDocument, out System.IO.MemoryStream stream, out iTextSharp.text.Image gif, int chart)
{
stream = new System.IO.MemoryStream();
switch (chart)
{
case 1:
Chart1.SaveImage(stream, System.Drawing.Imaging.ImageFormat.Jpeg);
break;
case 2:
Chart2.SaveImage(stream, System.Drawing.Imaging.ImageFormat.Jpeg);
break;
case 3:
Chart3.SaveImage(stream, System.Drawing.Imaging.ImageFormat.Jpeg);
break;
case 4:
Chart4.SaveImage(stream, System.Drawing.Imaging.ImageFormat.Jpeg);
break;
case 5:
Chart5.SaveImage(stream, System.Drawing.Imaging.ImageFormat.Jpeg);
break;
}
Chart1.SaveImage(stream, System.Drawing.Imaging.ImageFormat.Jpeg);
gif = iTextSharp.text.Image.GetInstance(stream.ToArray());
gif.Alignment = Element.ALIGN_CENTER;
//gif.ScaleAbsolute(10, 10);
}
protected void CargaChart()
{
Chart.DataSource = null;
Chart.DataBind();
Chart2.DataSource = null;
Chart2.DataBind();
DataTable Dt = new DataTable();
Dt.Columns.Add("Lenguaje");
Dt.Columns.Add("Porcentaje");
foreach (var item in list)
{
Dt.Rows.Add(item.Nombre, item.Valor);
}
Chart.DataSource = Dt;
Chart.Series["Series1"].XValueMember = "Lenguaje";
Chart.Series["Series1"].YValueMembers = "Porcentaje";
Chart.DataBind();
Chart2.DataSource = Dt;
Chart2.Series["Series1"].XValueMember = "Lenguaje";
Chart2.Series["Series1"].YValueMembers = "Porcentaje";
Chart2.DataBind();
}
protected override void Dispose(bool disposing)
{
Chart.Dispose();
Chart2.Dispose();
Chart3.Dispose();
LogarithmicChart.Dispose();
base.Dispose(disposing);
}
public void View3_bind()
{
if (!DropDownList3.SelectedValue.Equals("-1") && !DropDownList4.SelectedValue.Equals("-1") && !DropDownList5.SelectedValue.Equals("-1"))
{
Label6.Text = string.Format(DropDownList4.SelectedItem.Text.ToString() + ": " + DropDownList4.SelectedValue.ToString());
GridView2.DataBind();
Chart2.DataBind();
}
}
public void InitializeChart()
{
try
{
ds = obj.LoadMovieList("2", movieName);
Chart1.DataSource = ds.Tables[0];
Chart1.Series["pieChart"].XValueMember = "polarity";
Chart1.Series["pieChart"].YValueMembers = "count";
Chart1.DataBind();
Chart2.DataSource = ds.Tables[0];
Chart2.Series["barChart"].XValueMember = "polarity";
Chart2.Series["barChart"].YValueMembers = "count";
//Chart3.ChartAreas["ChartArea1"].AxisX.
Chart2.DataBind();
colorChart(Chart1, "pieChart");
colorChart(Chart2, "barChart");
SqlDataReader dr = obj.DataForHistogram(movieName, "pos");
Chart3.Series["Series1"].Points.DataBind(dr, "timeField", "polCount", "Label=");
dr = obj.DataForHistogram(movieName, "neg");
Chart3.Series["Series2"].Points.DataBind(dr, "timeField", "polCount", "Label=");
dr = obj.DataForHistogram(movieName, "neu");
Chart3.Series["Series3"].Points.DataBind(dr, "timeField", "polCount", "Label=");
//dr = obj.DataForHistogram(movieName, "irr");
//Chart3.Series["Series4"].Points.DataBind(dr, "timeField", "polCount", "Label=");
colorChart(Chart3, "Series1");
colorChart(Chart3, "Series2");
colorChart(Chart3, "Series3");
Chart3.Series["Series1"]["PointWidth"] = "0.3";
Chart3.Series["Series2"]["PointWidth"] = "0.3";
Chart3.Series["Series3"]["PointWidth"] = "0.3";
Chart3.ChartAreas["ChartArea1"].AxisX.IsMarginVisible = true;
Chart1.ChartAreas["ChartArea1"].Area3DStyle.Enable3D = true;
}
catch (Exception e)
{
}
}
protected void DropDownList3_SelectedIndexChanged(object sender, EventArgs e)
{
cd2 = new SqlCommand("getModuleFromProject", con);
cd2.CommandType = CommandType.StoredProcedure;
cd2.Parameters.AddWithValue("@ProjectID", DropDownList3.SelectedItem.Value);
da2 = new SqlDataAdapter(cd2);
dt2 = new DataTable();
da2.Fill(dt2);
DataTable mydt = new DataTable();
mydt.Columns.Add("modulname", typeof(System.String));
mydt.Columns.Add("prg", typeof(System.Int16));
foreach (DataRow item in dt2.Rows)
{
DataRow dr = mydt.NewRow();
dr[0] = item[0].ToString();
cd = new SqlCommand("getmoduleprogress", con);
cd.Parameters.AddWithValue("@mid", Convert.ToInt16(item[1]));
cd.CommandType = CommandType.StoredProcedure;
da = new SqlDataAdapter(cd);
DataTable newdt = new DataTable();
da.Fill(newdt);
foreach (DataRow item1 in newdt.Rows)
{
dr[1] = Convert.ToInt16(item1[0]);
}
mydt.Rows.Add(dr);
Chart2.DataSource = mydt;
Chart2.DataBind();
}
bindchart();
cd = new SqlCommand("counttask", con);
cd.Parameters.AddWithValue("@mid", DropDownList2.SelectedItem.Value);
cd.CommandType = CommandType.StoredProcedure;
da = new SqlDataAdapter(cd);
dt = new DataTable();
da.Fill(dt);
Chart1.DataSource = dt;
Chart1.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
DataTable fd = cs.select("select distinct a.Appname, avg(rating) as rating from Rating d join AddApp a on d.apid=a.apid where d.status !='fraud' group by a.Appname");
Chart2.DataSource = fd;
Chart2.Series[0].ChartType = SeriesChartType.RangeColumn;
//Chart2.Legends[0].Enabled = true;
Chart2.Series[0].XValueMember = "Appname";
Chart2.Series[0].YValueMembers = "rating";
Chart2.DataBind();
}
}
void initChart2()
{
SqlDataReader rdr = c.DiagnosisPerCity(Convert.ToInt32(DropDownList1.SelectedItem.Text), DropDownList2.SelectedItem.Text);
if (rdr != null)
{
Chart2.Visible = true;
Label2.Text = "";
Chart2.DataBindTable(rdr, "illness");
}
else
{
Label2.Text = "There is No Enough Data ";
Chart2.Visible = false;
}
}
void initChart2()
{
SqlDataReader rdr = c.Get_Surgeries(DropDownList3.SelectedItem.Text);
if (rdr != null)
{
Chart2.Visible = true;
Label2.Text = "";
Chart2.DataBindTable(rdr, "Type");
}
else
{
Label2.Text = "There is No Enough Data ";
Chart2.Visible = false;
}
}
private void loadChart2()
{
//chart 2
//This is for pitch type
string sqlQuery2 = (@"SELECT *
FROM
(
SELECT[pitchno],
[pitcher],
[pitchtype]
FROM[dbo].[pitchData]
--ORDER BY pitcher ASC
) AS SourceTable PIVOT(COUNT([pitchno]) FOR[pitchtype] IN([Splitter],
[Fastball],
[Sinker],
[ChangeUp],
[Cutter],
[Curveball],
[Slider])) AS PivotTable ORDER BY pitcher ASC;" );
DataTable ChartData2 = SqlQueryExecute(sqlQuery2);
DataView dv = new DataView(ChartData2);
Chart2.DataSource = dv;
Chart2.DataBind();
foreach (Series cs in Chart2.Series)
{
cs.Enabled = false;
Debug.WriteLine(cs.Name);
cs.ChartType = SeriesChartType.StackedColumn;
foreach (DataPoint point in cs.Points)
{
if ((double)point.YValues.GetValue(0) != 0)
{
Debug.WriteLine("not empty");
cs.Enabled = true;
}
}
}
//Setting width of line
Chart2.Series[0].BorderWidth = 10;
}
private void LoadChartData4()
{
Chart2.ChartAreas[0].AxisX.MajorGrid.Enabled = false;
Chart2.ChartAreas[0].AxisY.MajorGrid.Enabled = false;
string query = "SELECT comment_type,Ccount from tbl_cat_wise_comment ";
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, "comment_type", dv, "Ccount");
getdata1();
}
private void LoadChartData2()
{
Chart2.ChartAreas[0].AxisX.MajorGrid.Enabled = false;
Chart2.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;
Chart2.DataBind();
Chart2.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();
}
}
}
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();
}
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();
//s Chart2.Series["Series1"]["PieLabelStyle"] = "Outside";
Chart2.Series["Series1"].Points.DataBindXY(dv, "City_nm", dv, "Count");
getdata3();
}
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
}
}
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 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();
}
}
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 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();
}
}
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 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 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";;
}
