Group by Inside Group by Using EntityFramwork in Mvc5

محمد صلاح الدين

7y850.NET

Hi guys I am trying I try to bring the count for each male and female by age As in the table

I was able to calculate all ages but I can not count the ages as boys and girls like this

here is my code in controller

public ActionResult AllCuont()
{ var query = (from t in db.Pations
let range = (
t.Age>= 1 && t.Age < 5 ? "age from 1 to 4" :
t.Age >= 5 && t.Age < 15 ? "age from 5 to 14" :
t.Age >= 15 && t.Age < 25 ? "age from 15 to 24" :
t.Age >= 25 && t.Age < 45 ? "age from 25 to 44" : ""
) group t by range into g
select new UserRange { AgeRange = g.Key, Count = g.Count() }).ToList();
query.Add(new UserRange() { AgeRange = "Sum",Count = query.Sum(c => c.Count) });
ViewBag.UserData = query; return View(db.Pations); }

and my modal pation like this

and this is table for count my value

my question is how Display count for each male and female by age

2 Replies

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

Piyush Pansuriya7y ago
Hi,
Please accept as correct answer if it is really helps you.
Piyush Pansuriya7y ago
Hello,
You have to take two different count in your class
public class UserRange
{
public string AgeRange { get; set; }
public int BoysCount { get; set; }
public int GirlsCount { get; set; }
}
And in Linq
public ActionResult AllCuont()
{
var query = (from t in db.Pations
let range = (
t.Age>= 1 && t.Age < 5 ? "age from 1 to 4" :
t.Age >= 5 && t.Age < 15 ? "age from 5 to 14" :
t.Age >= 15 && t.Age < 25 ? "age from 15 to 24" :
t.Age >= 25 && t.Age < 45 ? "age from 25 to 44" : ""
) group t by range into g
select new UserRange { AgeRange = g.Key, BoysCount = g.Count(b=>b.Sex == boys), GirlsCount = g.count(d=>d.Sex==girls) }).ToList();
query.Add(new UserRange() { AgeRange = "Sum",Count = query.Sum(c => c.Count) });
ViewBag.UserData = query; return View(db.Pations); }