using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Mvc;
using Projects.Models;

namespace Projects.Controllers
{
    public class ActivityController : Controller
    {
        private ProjectsDBEntities db = new ProjectsDBEntities();

        // GET: Activity
        public ActionResult Index()
        {
            var results = (from pt in db.ProjectTasks
                           join ts in db.TaskStatuses on pt.task_status_id equals ts.id
                           where ts.status == "Done"
                           group pt.User by pt.User.id into g
                           join u in db.Users on g.Key equals u.id
                           select new ActivityResult { user = u.login, count = g.Count() })
                           .ToList();
            ViewBag.results = results;
            return View();
        }
    }
}