public JsonResult GroupActivities(int ID)
{
var group = db.Groups.Find(ID);
List<Activity> activities = db.Activities.Where(a => a.Event.ID == eventID).ToList();
foreach (var timeSlot in db.TimeSlots.Where(t => t.Event.ID == eventID && t.isGeneral))
{
activities.Add(new Activity
{
Group = group,
TimeSlot = timeSlot,
Station = new Station { ID = -1, Name = timeSlot.Name }
});
}
return Json((from activity in activities
where activity.Group.ID == ID
select new
{
ID = activity.ID,
StationName = activity.Station.Name,
Start = activity.TimeSlot.Start,
End = activity.TimeSlot.End
}).AsEnumerable().OrderBy(a => a.StationName).Select(a => new
{
ID = a.ID,
Name = a.StationName,
Start = a.Start.ToString(),
End = a.End.ToString()
}));
}