// GET: MyTasks public async Task <IActionResult> Index(string myTaskAsignee, string searchString) { if (UsersController.logged_user.username == "None") { return(RedirectToAction("Privacy", "Home")); } IQueryable <string> asigneeQuery = from m in _context.MyTask orderby m.Asignee select m.Asignee; var myTasks = from m in _context.MyTask select m; if (!string.IsNullOrEmpty(searchString)) { myTasks = myTasks.Where(s => s.Project.Contains(searchString)); } if (!string.IsNullOrEmpty(myTaskAsignee)) { myTasks = myTasks.Where(x => x.Asignee == myTaskAsignee); } var myTaskAsigneeVM = new MyTaskAsigneeViewModel { Asignees = new SelectList(await asigneeQuery.Distinct().ToListAsync()), MyTasks = await myTasks.ToListAsync() }; return(View(myTaskAsigneeVM)); }
//GET : Dashboard public async Task <IActionResult> Dashboard(string name) { if (UsersController.logged_user == null) { return(RedirectToAction("Privacy", "Home")); //Privacy is used as default empty page } // Use LINQ to get list of genres. IQueryable <string> asigneeQuery = from m in _context.MyTask orderby m.Asignee select m.Asignee; var myTasks = from m in _context.MyTask where m.Asignee == name || m.Owner == name orderby m.Due_Date select m; if (string.IsNullOrEmpty(name)) { name = logged_user.username; } // myTasks = myTasks.Where(x => x.Asignee == name || x.Owner==name); var myTaskAsigneeVM = new MyTaskAsigneeViewModel { Asignees = new SelectList(await asigneeQuery.Distinct().ToListAsync()), MyTasks = await myTasks.ToListAsync() }; return(View(myTaskAsigneeVM)); }
// GET: MyTasks public async Task <IActionResult> Index(string myTaskTag, string location) { if (UsersController.logged_user == null) { return(RedirectToAction("Privacy", "Home")); } IQueryable <MyTask.TagType> tagsQuery = from m in _context.MyTask orderby m.Tag select m.Tag; var myTasks = from m in _context.MyTask select m; myTasks = myTasks.Where(asgn => asgn.Asignee == null); if (!string.IsNullOrEmpty(location)) { myTasks = myTasks.Where(s => s.Location.Contains(location)); } if (!string.IsNullOrEmpty(myTaskTag)) { MyTask.TagType tag = (MyTask.TagType)Enum.Parse(typeof(MyTask.TagType), myTaskTag); myTasks = myTasks.Where(x => x.Tag == tag); } var myTaskAsigneeVM = new MyTaskAsigneeViewModel { Tags = new SelectList(await tagsQuery.Distinct().ToListAsync()), MyTasks = await myTasks.ToListAsync() }; return(View(myTaskAsigneeVM)); }