private void BindPieChart() { reportBAL = new BAL.ReportBAL(); chart2.Series[0].Points.Clear(); chart2.Titles.Clear(); DataTable dt = reportBAL.getInvoiceStatusCount(); int i = 0; foreach (DataRow dr in dt.Rows) { chart2.Series["CountCollection"].Points.AddXY(dr["InvoiceStatus"], dr["Total"]); chart2.Series["CountCollection"].Points[i].ToolTip = "Count : " + dr["Total"].ToString(); i++; } chart2.Titles.Add("Invoice Status Counts"); }
private void BindChartData() { reportBAL = new BAL.ReportBAL(); chart1.Series[0].Points.Clear(); chart1.Titles.Clear(); DataTable dt = reportBAL.getLastWeekCollection(); int i = 0; foreach (DataRow dr in dt.Rows) { chart1.Series["Collection"].Points.AddXY(dr["OrderDate"], dr["Total"]); chart1.Series["Collection"].Points[i].ToolTip = "R : " + dr["Total"].ToString(); i++; } chart1.Titles.Add("Collection In Ruppes Chart"); BindPieChart(); orderBAL = new BAL.OrderBAL(); DataTable dtO = orderBAL.getRecentInvoices(); dgvRecentInvoices.DataSource = dtO; }