Loading

Group by with Count in MVC

Group by with Count in MVC

Raju Fodse

Raju Fodse

7y2.4kLearn iOS Programming

I am using MVC and following is my Database table

Table Name : DeptTask

TaskID	EmpID	Task	Dept	Status
1	101	xxc	Admin	C
2	102	xxxf	Admin	P
3	101	xxxr	Admin	P
4	101	xe	Admin	P
5	104	xh	Admin	P
6	104	xj	Admin	P

I want output list like this in Index view How can I do please help, Thanks in advance.

EmpID	Staus	Count Status
101	C	1
101	P	2
102	P	1
104	P	2

3 Replies

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

Kalyani Shevale7y ago
please try this code
var authorCategoryRecipies =
                               from r in db.DeptTasks
                               group r by new { r.Emp.EmpName, r.Status } into g
                               orderby g.Key.EmpName
                               select new { EmpName = g.Key.EmpName, StatusTag = g.Key.Status, RecipeCount =g.Count(r=>r.Status) };
if any Query then tell me...
Raju Fodse7y ago
Can it is possible to use linq I trying for this
var authorCategoryRecipies =
                               from r in db.DeptTasks
                               group r by new { r.Emp.EmpName, r.Status } into g
                               orderby g.Key.EmpName
                               select new { EmpName = g.Key.EmpName, StatusTag = g.Key.Status, RecipeCount = g.Count() };
But no idea how to use in mvc
Jignesh Kumar7y ago
Hi Raju,

You can create store procedure as below and get expected result. Create model with whichever property you want and call store procedure to get expected result.
Create Procedure Usp_GetStatusCount
As
Begin
select empId as EmpId, Status as Status,  count(Status) as[Count Status]
from DeptTask group by Status, EmpId
End