Home view

[wsti_pai.git] / Projects / Controllers / HomeController.cs

diff --git a/Projects/Controllers/HomeController.cs b/Projects/Controllers/HomeController.cs
index c5d394a44686af0865849f1c343c3a01b181f012..a55e6d23f575c923c252c1642ca5b0471f2fe9ed 100644 (file)
--- a/Projects/Controllers/HomeController.cs
+++ b/Projects/Controllers/HomeController.cs
@@ -3,13 +3,28 @@ using System.Collections.Generic;
 using System.Linq;
 using System.Web;
 using System.Web.Mvc;
+using Projects.Models;
 
 namespace Projects.Controllers
 {
     public class HomeController : Controller
     {
+        private ProjectsDBEntities db = new ProjectsDBEntities();
+
         public ActionResult Index()
         {
+            Project recentProject = (from d in db.Projects
+                                     orderby d.updated_at descending
+                                     select d)
+                .FirstOrDefault();
+            ProjectTask recentTask = (from d in db.ProjectTasks
+                                     orderby d.updated_at descending
+                                     select d)
+                .FirstOrDefault();
+
+            ViewBag.recentProject = recentProject;
+            ViewBag.recentTask = recentTask;
+            
             return View();
         }