// 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);
}
