Loading

Show Chart in MVC.

Show Chart in MVC.

Puja Aggarwal

5y706Learn iOS Programming

I have two tables Course and Student , Course can have multiple students , in MVC view i have to show each course with respective number of Student, how to achieve this, any article or exmple please.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sachin Singh5y ago
Accepted answer
In MVC there is a chart Html helper, you can use that , follow below example , i have taken dummy data for student and courses
public List GetChartData()
{

Course C1 =   new Course() {Id=1,Name="Asp.Net"};
Course C2 = new Course()   { Id = 2, Name = "Java" };
Course C3 =  new Course()  {Id=3,Name="C"};

Student s1= new Student()  {Id=1,Name="Shyam",course=C1 };
Student s2 = new Student() { Id = 2, Name = "Mohan", course = C1 };
Student s3 = new Student() { Id = 3, Name = "Geetha", course = C1 };
Student s4 = new Student() { Id = 4, Name = "Madhwan", course = C2 };
Student s5 = new Student() { Id = 5, Name = "Vikash", course = C3 };
Student s6 = new Student() { Id = 6, Name = "Jignesh", course = C3 };


    // Create two lists.
List courses = new List(){C1,C2,C3 };
List students = new List() { s1, s2, s3, s4, s5,s6};


var query = (from course in courses
join student in students on course equals student.course into gj
select new ChartVM
{
CourseName = course.Name,
StudentCount = gj.Count()
}).ToList();

    return query;
}

public class ChartVM
{
    public string CourseName { get; set; }
    public int StudentCount { get; set; }
}
@{
var chart = new Chart(width: 500, height: 500, theme: ChartTheme.Yellow)
.AddTitle("Course Vs Students")
.AddSeries("Default", chartType: "Bar",
xValue: Model, xField: "CourseName",
yValues: Model, yFields: "StudentCount")
.Write();
}
+1
Puja Aggarwal5y ago
Thank you so much.
0