This is Webservices page
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Services;
using System.Collections.Specialized;
using System.Text.RegularExpressions;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.IO;
using System.Web.SessionState;
namespace FTSUPPRPB.WebRoot
{
/// <summary>
/// Summary description for WebService1
/// </summary>
[WebService(Namespace = "http://tempuri.org/")]
[WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
[System.ComponentModel.ToolboxItem(false)]
// To allow this Web Service to be called from script, using ASP.NET AJAX, uncomment the following line.
[System.Web.Script.Services.ScriptService]
public class WebService1 : System.Web.Services.WebService
{
//HttpCookie getCookie = System.Web.HttpContext.Current.Response.Cookies["usermaster"];
SqlCommand cmd;
HttpCookie getCookie;
string cons = ConfigurationManager.ConnectionStrings["con"].ConnectionString;
HttpSessionState session = HttpContext.Current.Session;
[WebMethod]
public string HelloWorld()
{
return "Hello World";
}
[WebMethod]
public List<Zone> fillchart(int type)
{
SqlConnection con = new SqlConnection(cons);
List<Zone> result = new List<Zone>();
cmd = new SqlCommand("select count(newfile.fileid) as filenu ,m.firstnm from newfile newfile inner join master_employee m on m.employeeid=newfile.status group by m.firstnm", con);
con.Open();
//cmd.CommandType = CommandType.StoredProcedure;
//cmd.Parameters.AddWithValue("@qrytype", "PIS_DG_ZONE");
//cmd.Parameters.AddWithValue("@type", type);
SqlDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
Zone zn;
while (dr.Read())
{
zn = new Zone();
zn.ZoneName = dr["firstnm"].ToString();
zn.AVL = Convert.ToInt32(dr["filenu"].ToString());
//zn.ALC = Convert.ToInt32(dr["ALC"].ToString());
//zn.VAC = Convert.ToInt32(dr["VAC"].ToString());
//zn.dtvalue = dr["AVL"].ToString() + "$" + dr["ALC"].ToString() + "$" + dr["VAC"].ToString();
result.Add(zn);
}
return result;
}
public class Zone
{
public string ZoneName;
public int AVL;
}
and this is webservices1.aspx page
<%@ WebService Language="C#" CodeBehind="WebService1.asmx.cs" Class="FTSUPPRPB.WebService1" %>
This is Web.aspx Form page
<%@ Page Title="" Language="C#" MasterPageFile="~/WebRoot/banner.master" AutoEventWireup="true" CodeFile="Dashboardss.aspx.cs" Inherits="WebRoot_Dashboardss" %>
<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
<script src="../dashboards-js/highcharts.js" type="text/javascript"></script>
<%--<script src="../dashboard-js/modules/exporting.js" type="text/javascript"></script>--%>
<script src="../dashboards-js/modules/exporting.src.js" type="text/javascript"></script>
<script src="../dashboards-js/modules/data.js" type="text/javascript"></script>
<script src="../dashboards-js/highcharts-more.src.js" type="text/javascript"></script>
<script type="text/javascript">
var chart;
var rangechart;
var type;
var nondefchart;
var dialog;
var distdialog;
var distcastedialog;
var zonearray = [];
var Rangearray = [];
var Distarray = [];
$(function () {
// prepare an empty Highcharts object
dialog = $('#rangediv').dialog({
'autoOpen': false,
'width': 420,
'height': 350,
'closeOnEscape': true,
'modal': true
});
distdialog = $('#distdiv').dialog({
'autoOpen': false,
'width': 420,
'height': 350,
'closeOnEscape': true,
'modal': true,
'position': [300, 100]
});
distcastedialog = $('#dist_cast').dialog({
'autoOpen': false,
'width': 720,
'height': 350,
'closeOnEscape': true,
'modal': true
});
chart = new Highcharts.Chart({
chart: {
renderTo: 'container',
showAxes: true,
height: 300,
width: 300
},
title: {
text: ''
},
credits: {
text: 'DGP HQ'
},
xAxis: {
title: {
text: 'Graphical Representation Of Officers Name & File'
}
},
plotOptions: {
series: {
cursor: 'pointer',
point: {
events: {
click: function () {
GenerateDashboardForRange(this.name);
}
}
}
}
},
yAxis: {
title: {
text: 'Amount'
}
},
tooltip: {
shared: true,
useHTML: true,
formatter: function () { return getreturnvalue(this.key, 1, zonearray); },
style: { padding: 10, color: '{series.color}' }
}
});
function getreturnvalue(name, type, arr) {
var i = 0;
var data = '';
for (i = 0; i < arr.length; i++) {
if (arr[i].split('$')[0] == name) {
if (type == 1) {
data = '<table><tr><td colspan="2" align="center"><h4> Officer Name : ' + name + "</h4></td></tr>";
//data += '<tr><td><b>Total File :</b></td><td style="color:green"><b>' + arr[i].split('$')[1] + '</b></td></tr>';
}
else if (type == 2) {
data = '<table><tr><td colspan="2" align="center"><h4> Range : ' + name + "</h4></td></tr>";
}
else {
data = '<table><tr><td colspan="2" align="center"><h4> District : ' + name + "</h4></td></tr>";
}
data += '<tr><td><b>Total File :</b></td><td style="color:blue"><b>' + arr[i].split('$')[2] + '</b></td></tr>';
data += '<tr><td><b>Total File :</b></td><td style="color:green"><b>' + arr[i].split('$')[1] + '</b></td></tr>';
data += '<tr><td><b>Vacancy :</b></td><td style="color:red"><b>' + arr[i].split('$')[3] + '</b></td></tr></table>';
return data;
}
}
}
function GenerateDashboard() {
zonearray = [];
chart.showLoading('Getting Range data please wait....');
$.ajax({
type: "POST",
contentType: "application/json; charset=utf-8",
url: '../WebService1.asmx/fillchart',
data: JSON.stringify({ type: type }),
dataType: "json",
success: function (msg) {
// remove all existing series
aData = msg.d;
while (chart.series.length) {
chart.series[0].remove();
}
// re-set categories for X axe
var categories = [];
$.each(aData, function (idx, res) {
categories.push(res.ZoneName);
});
chart.xAxis[0].setCategories(categories);
chart.yAxis[0].axisTitle.attr({
text: ''
});
// gather data (percentages) and prepare a new Series array
var seriesPerData = [];
$.each(aData, function (idx, res) {
seriesPerData.push([res.ZoneName, res.AVL]);
zonearray.push(res.ZoneName + '$' + res.AVL);
});
var seriesPercentages = {
name: 'No. Of Officers',
data: seriesPerData,
type: 'pie',
size: '65%',
center: ['50%', '40%'],
showInLegend: true
}
// hide Loading, add both series and redraw our chart
chart.hideLoading();
//chart.addSeries(seriesValues, false);
chart.addSeries(seriesPercentages, false);
chart.redraw();
// GenerateDashboardForRange('LKW');
//GenerateDashboardForDistrict('LKW');
GenerateDashboardNonDef();
GenerateDashboardCaste();
},
error: Errorocr
});
}
</script>
<div id="container" style="border: 4px solid #DFDFDF;
margin: 0 auto">
<div id="rangediv" style="border: 4px solid #DFDFDF; width: 600px; height: 400px;
margin: 0 auto; display: none">
<div id="rangediv_child">
</div>
</div>
<div id="distdiv" style="border: 4px solid #DFDFDF; width: 341px; height: 300px;
margin: 0 auto; display: none">
<div id="distdiv_child">
</div>
</div>
<div id="dist_cast" style="border: 4px solid #DFDFDF; width: 341px; height: 300px;
margin: 0 auto; display: none">
<div id="dist_caste_sub">
</div>
</div>
and this web.aspx.cs page using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.Services;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using System.Web.Script.Services;
public partial class WebRoot_Dashboardss : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
SqlConnection cn;
SqlCommand cmd;
SqlDataReader dr;
SqlDataAdapter da;
DepotDetails dd = new DepotDetails();
HttpCookie getCookie;
}
[WebMethod(EnableSession = true)]
[ScriptMethod(UseHttpGet = false, ResponseFormat = ResponseFormat.Json)]
public List<Zone> fillchart()
{
List<Zone> Zone = new List<Zone>
{
new Zone{ZoneName="Audi",ZoneCount=6},
new Zone{ZoneName="Audi",ZoneCount=16},
new Zone{ZoneName="Audi",ZoneCount=50},
new Zone{ZoneName="Audi",ZoneCount=58},
new Zone{ZoneName="Audi",ZoneCount=55},
};
var query = from c in Zone select c;
return query.ToList();
}
}
public class Zone
{
public string ZoneName;
public int ZoneCount;
}