public void get_all_activities(object arg, DoWorkEventArgs e) { e.Result = (object)(new List<activity_item>()); try { naturenet_dataclassDataContext db = new naturenet_dataclassDataContext(); var r = from a in db.Activities where (a.name != "Free Observation") && (a.name != "Design Idea") select a; if (r != null) { //List<Activity> activities = r.ToList<Activity>(); List<activity_item> activity_items = new List<activity_item>(); foreach (Activity a in r) { DateTime last_time = a.creation_date; var n1 = from m in db.Collection_Contribution_Mappings where m.Collection.activity_id == a.id orderby m.Contribution.date descending select new { m.Contribution.date, m.Collection.User.name }; int cnt = 0; if (n1 != null) cnt = n1.Count(); activity_item ai = new activity_item(); ai.activity = a; ai.count = cnt; if (cnt != 0) ai.username = n1.First().name; else ai.username = ""; if (cnt != 0) last_time = n1.First().date; ai.last_date = last_time; activity_items.Add(ai); } e.Result = (object)activity_items; } else { e.Result = (object)(new List<activity_item>()); } } catch (Exception ex) { log.WriteErrorLog(ex); } }