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