2 using System.Collections.Generic;
8 namespace Projects.Controllers
10 public class ActivityController : Controller
12 private ProjectsDBEntities db = new ProjectsDBEntities();
15 public ActionResult Index()
17 var results = (from pt in db.ProjectTasks
18 join ts in db.TaskStatuses on pt.task_status_id equals ts.id
19 where ts.status == "Done"
20 group pt.User by pt.User.id into g
21 join u in db.Users on g.Key equals u.id
22 select new ActivityResult { user = u.login, count = g.Count() })
24 ViewBag.results = results;