public IEnumerable<EData> getErrData(string _from, string to) { List<EData> data = new List<EData>(); List<string> daysList = getDates(_from, to); try { MultiTabberDataContext ctx = new MultiTabberDataContext(); int num = 1; foreach(string d in daysList) { var exist = ctx.ErrTabber.Where(m => m.err == d); foreach(var er in exist) { data.Add(new EData { date = er.date, descrip = er.description, err = er.err, Id = num++ }); } } } catch(Exception) { } return data; }
public IEnumerable<MData> getUserData(string _from, string to, int activityCount) { List<MData> data = new List<MData>(); List<string> daysList = getDates(_from, to); try { if (activityCount > 0) { MultiTabberDataContext ctx = new MultiTabberDataContext(); int num = 1; foreach (string d in daysList) { var exist = ctx.Tabber.Where(n => n.lastused == d && n.ActiveCount >= activityCount); foreach (UserTable m in exist) data.Add(new MData { Id = num++, email = m.email, lastused = m.lastused, ActivityCount = m.ActiveCount }); } } else { MultiTabberDataContext ctx = new MultiTabberDataContext(); int num = 1; foreach (string d in daysList) { var exist = ctx.Tabber.Where(n => n.lastused == d); foreach(UserTable m in exist) data.Add(new MData { Id = num++, email = m.email, lastused = m.lastused, ActivityCount = m.ActiveCount }); } } } catch (Exception ex) { } return data; }