Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: jQuery JSON MVC3
Hi all i am working on Piecharts using jquery json in mvc3
Here i had created my models and controllers & view when i am exicuting it is taking the values in controllers but in case of vies not displayinng the pie chart could u plz chek it and plz help me to do this work
thank in advance
here my models :
=====================
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Data.Entity;
 
namespace JqueryCharts.Models
{
    public class PiechartModel:DbContext
    {
       public static List<PiechartModel> Employeelist { get; set; }
 
        public Int16 EmployeeId { get; set; }
        public string EmployeeName { get; set; }
        public string EmployeeEmailId { get; set; }
        public string GroupName { get; set; }
        public string EmployeePassword { get; set; }
        public List<PiechartModel> List { get; set; } 
 
    }
}
 
and hers are  my controllers :
======================================
<pre>using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Mvc;
using JqueryCharts.Models;
using System.Data.SqlClient;
 
namespace JqueryCharts.Controllers
{
    public class PiechartsController : Controller
    {
        //
        // GET: /Piecharts/
      public BugtrackerNewEntities1 db = new BugtrackerNewEntities1();
 
        public ActionResult Index()
        {
            return View();
        }
 

        public JsonResult GetData()
        {
            
            var ViewEmployelist = db.EmployeeDetails.ToList<EmployeeDetail>().Select(e =>
           new
           {
               
               EmployeId = e.EmployeId,
               EmployeeName = e.EmployeeName
           }).ToList();
            return Json(ViewEmployelist, JsonRequestBehavior.AllowGet);
        }
    }
}
 

 

 
and here my View page
=============================
<pre><%@ Page Language="C#" Inherits="System.Web.Mvc.ViewPage<JqueryCharts.Models.PiechartModel>" %>
<script src="../../Scripts/highcharts.src.js" type="text/javascript"></script>
<script src="../../Scripts/highcharts-more.js" type="text/javascript"></script>
<script src="../../Scripts/highcharts.js" type="text/javascript"></script>
<script src="../../Scripts/jquery-1.5.1.js" type="text/javascript"></script>
<script src="../../Scripts/modernizr-1.7.js" type="text/javascript"></script>
<script src="../../Scripts/jquery-ui-1.8.11.js" type="text/javascript"></script>
<!DOCTYPE html>
 
<html>
<head runat="server">
    <title>Index</title>
 
      <script type="text/javascript">
          $(function () {
          alert("1")
              $.getJSON('<%= Url.Action("GetData","Piecharts") %>', {}, function (data) {
                  var json = data;
                  var jsondata = [];
                  for (var i in json) {
                      // var serie = new Array(json[i].Projects, json[i].Bugs);
                      jsondata.push([json[i].EmployeId, json[i].EmployeeName]);
                      alert("1")
                  }
                  var chart = new Highcharts.Chart({
                      chart: {
                          renderTo: 'container',
                          type: 'pie',
                          plotBackgroundColor: null,
                          plotBorderWidth: null,
                          plotShadow: false
                      },
                      title: {
                          text: 'Resource Reports of BugTracker'
                         
                      },
 
                      plotOptions: {
                          pie: {
                              showInLegend: true,
                              animation: false,
                              allowPointSelect: true,
                              cursor: 'pointer'
                          }
                      },
                      legend: {
                          enabled: true
                      },
                      series: [{
                          type: 'pie',
                          data: jsondata
                      }]
                  });
              });
          });
          alert("1")
    </script>
</head>
<body>
    <div id="container" style="min-width: 400px; height: 400px; margin: 0 auto">
    
    </div>
</body>
</html>
 

 
could u plz help to do this work it is not displaying data in ives page
Thank in Advance
Posted 26-Aug-12 21:22pm

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 Sergey Alexandrovich Kryukov 535
1 OriginalGriff 275
2 Shweta N Mishra 244
3 BillWoodruff 235
4 Deepu S Nair 230
0 OriginalGriff 6,168
1 Sergey Alexandrovich Kryukov 5,818
2 DamithSL 4,958
3 Manas Bhardwaj 4,539
4 Maciej Los 3,755


Advertise | Privacy | Mobile
Web04 | 2.8.1411019.1 | Last Updated 27 Aug 2012
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100