Projects/Controllers/ActivityController.cs

   1 using System;
   2 using System.Collections.Generic;
   3 using System.Linq;
   4 using System.Web;
   5 using System.Web.Mvc;
   6 using Projects.Models;
   7
   8 namespace Projects.Controllers
   9 {
  10     public class ActivityController : Controller
  11     {
  12         private ProjectsDBEntities db = new ProjectsDBEntities();
  13
  14         // GET: Activity
  15         public ActionResult Index()
  16         {
  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() })
  23                            .ToList();
  24             ViewBag.results = results;
  25             return View();
  26         }
  27     }
  28 }