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