I show completed Progress and pending on the graph i want when i click to completed it redirect to next page with value or show me the list what project is completed
public partial class DDL_CHART : System.Web.UI.Page
{
string name;
protected void Page_Load(object sender, EventArgs e)
{
}
[WebMethod]
public static string GetChart(string country)
{
string constr = ConfigurationManager.ConnectionStrings["myConnectionString"].ConnectionString;
using (SqlConnection con = new SqlConnection(constr))
{
string query = string.Format("select Proj_Status, COUNT(Proj_ID) from Project_Inventory_TBL where Proj_Team_Lead = '{0}' group by Proj_Status", country);
using (SqlCommand cmd = new SqlCommand())
{
cmd.CommandText = query;
cmd.CommandType = CommandType.Text;
cmd.Connection = con;
con.Open();
using (SqlDataReader sdr = cmd.ExecuteReader())
{
StringBuilder sb = new StringBuilder();
sb.Append("[");
while (sdr.Read())
{
sb.Append("{");
System.Threading.Thread.Sleep(50);
string color = String.Format("#{0:X6}", new Random().Next(0x1000000));
sb.Append(string.Format("text :'{0}', value:{1}, color: '{2}'", sdr[0], sdr[1], color));
sb.Append("},");
}
sb = sb.Remove(sb.Length - 1, 1);
sb.Append("]");
con.Close();
return sb.ToString();
}
}
}
}
}
<%@ Page Title="" Language="C#" MasterPageFile="~/Admin/Admin.Master" AutoEventWireup="true" CodeBehind="DDL_CHART.aspx.cs" Inherits="Quiz_Inventory_Management_System.Admin.DDL_CHART" %>
<asp:Content ID="Content1" ContentPlaceHolderID="head" runat="server">
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" runat="server">
<div class="content">
<div class="container-fluid">
<div class="card">
<div class="content">
<form id="form1" runat="server">
<h1 align="center">View Project Status Manager Wise</h1>
<br/>
<script src="http://cdn.jsdelivr.net/excanvas/r3/excanvas.js" type="text/javascript"></script>
<script src="http://cdn.jsdelivr.net/chart.js/0.2/Chart.js" type="text/javascript"></script>--%>
<script src="canvascript/Chart.js"></script>
<script src="canvascript/excanvas.js"></script>
<script src="canvascript/jquery.min.js"></script>
<script type="text/javascript">
$(function () {
LoadChart();
$("[id*=ddlCountries]").bind("change", function () {
LoadChart();
});
});
function LoadChart() {
$.ajax({
type: "POST",
url: "DDL_CHART.aspx/GetChart",
data: "{country: '" + $("[id*=ddlCountries]").val() + "'}",
contentType: "application/json; charset=utf-8",
dataType: "json",
success: function (r) {
$("#dvChart").html("");
$("#dvLegend").html("");
var data = eval(r.d);
var el = document.createElement('canvas');
el.width = 600;
el.height = 300;
$("#dvChart")[0].appendChild(el);
//Fix for IE 8
if ($.browser.msie && $.browser.version == "8.0") {
G_vmlCanvasManager.initElement(el);
}
var ctx = el.getContext('2d');
var userStrengthsChart;
// Based on your chart type comment and uncomment the below line.
userStrengthsChart = new Chart(ctx).Pie(data);
//userStrengthsChart = new Chart(ctx).Doughnut(data);
for (var i = 0; i < data.length; i++) {
var div = $("<div />");
div.css("margin-bottom", "10px");
div.html("<span style = 'display:inline-block;height:10px;width:10px;background-color:" + data[i].color + "'></span> " + data[i].text);
$("#dvLegend").append(div);
}
},
failure: function (response) {
alert('There was an error.');
}
});
}
</script>
<table border="0" cellpadding="0" cellspacing="0">
<div class="row">
<tr>
<td>
<div class="col-sm-5">
<strong> Select Manager Name : </strong>
</div>
<div class="col-sm-5">
<asp:DropDownList ID="ddlCountries" Class="form-control" runat="server">
<asp:ListItem Text="Tahir Sheikh" Value="Tahir Sheikh"></asp:ListItem>
<asp:ListItem Text="Imran Arif" Value="Imran Arif"></asp:ListItem>
<asp:ListItem Text="Arif Rana" Value="Arif Rana"></asp:ListItem>
<asp:ListItem Text="Ashraf Siddiquie" Value="Ashraf Siddiquie"></asp:ListItem>
<asp:ListItem Text="Asadullah" Value="Asadullah"></asp:ListItem>
<%-- <asp:ListItem Text="France" Value="France" />
<asp:ListItem Text="Brazil" Value="Brazil" />--%>
</asp:DropDownList>
</div>
<%--<asp:RadioButtonList ID="rblChartType" runat="server" RepeatDirection="Horizontal" Enabled="False" EnableViewState="False">
<asp:ListItem Text="Pie" Value="1" Selected="True" />
<%-- <asp:ListItem Text="Doughnut" Value="2" />
</asp:RadioButtonList>--%>
</td>
</tr>
</div>
<div class="row">
<tr>
<td>
<div id="dvChart" >
</div>
</td>
<td>
<div id="dvLegend">
</div>
</td>
</tr>
</div>
</table>
</form>
</div></div></div>
</asp:Content>