// GET: Groups //public ActionResult Index() //{ // return View(db.Groups.ToList()); //} public ActionResult Index(string GroupName) { var groups = from gr in db.Groups select gr; if(!String.IsNullOrWhiteSpace(GroupName)) { groups = groups.Where(gr => gr.GroupName.Contains(GroupName)); ViewBag.GroupNames = GroupName; } //if (!string.IsNullOrWhiteSpace(GroupDescription)) //{ // groups = from g in db.Groups // select g; //} var Groups = from gr in db.Groups select gr; List<Group> group = new List<Group>(); Group groupType = new Group(); groupType.GroupID = 0; groupType.GroupName = "All"; group.Add(groupType); group.AddRange(Groups.ToList()); SelectList list; list = new SelectList(group, "GroupId", "GroupName"); //ViewBag.GroupId = list ViewData["GroupId"] = list; return View(groups); }
// GET: Activities //public ActionResult Index() //{ // var activities = db.Activities.Include(a => a.Attachment).Include(a => a.Groups).Include(a => a.TimeSheet); // return View(activities.ToList()); //} //// GET: Activities/Details/5 //public ActionResult Details(int? id) //{ // if (id == null) // { // return new HttpStatusCodeResult(HttpStatusCode.BadRequest); // } // Activity activity = db.Activities.Find(id); // if (activity == null) // { // return HttpNotFound(); // } // return View(activity); // GET: Activities public ActionResult Index(string Name, int? GroupId, int? FileId) { var currentUserId = User.Identity.GetUserId(); var currentUser = db.Users.Find(currentUserId); var currentGroupId = currentUser.GroupId; IQueryable<Activity> activities; IQueryable<Group> Groups; if (User.IsInRole("admin")) { activities = from s in db.Activities.Include(s => s.Attachment).Include(s => s.Groups) select s; Groups = from gr in db.Groups select gr; } else { activities = from s in db.Activities.Where(a=>a.GroupId == currentGroupId).Include(s => s.Attachment).Include(s => s.Groups) select s; Groups = db.Groups.Where(g=>g.GroupID == currentGroupId); // from gr in db.Groups.Where(GroupId == currentGroupId) select gr; } if (!String.IsNullOrEmpty(Name)) { activities = activities.Where(s => s.Name.Contains(Name)); ViewBag.Title = Name; } if (GroupId != null && GroupId != 0) { activities = activities.Where(s => s.GroupId == GroupId); } List<Group> group = new List<Group>(); Group groupType = new Group(); groupType.GroupID = 0; groupType.GroupName = "All"; group.Add(groupType); group.AddRange(Groups.ToList()); SelectList list; list = new SelectList(group, "GroupId", "GroupName"); //ViewBag.GroupId = list ViewData["GroupId"] = list; return View(activities); }