public void Query(CheckinRecordQueryInfo query, Action <Exception> failFunc)
{
var url = "http://localhost:8888/api/Checkin/Query";
web.AsyncJsonPost(url, query,
(response, cookies, exp) =>
{
if (null != response)
{
var ret = JsonSerializer <CheckinRecord[]> .Deserialize(response);
if (ret != null)
{
if (null != OnQueryCompleted)
{
OnQueryCompleted(ret);
}
}
else
{
failFunc(new Exception("Failed in Query Object!"));
}
}
else if (null != exp)
{
failFunc(exp);
}
});
}
public List <CheckinRecord> Query(CheckinRecordQueryInfo query)
{
var theses = from a in dbSet
select a;
if (!String.IsNullOrEmpty(query.EmployeeName))
{
theses = theses.Where(a => a.Employee != null && a.Employee.Name.Equals(query.EmployeeName, StringComparison.OrdinalIgnoreCase));
}
if (query.StartDate != null)
{
theses = theses.Where(a => a.CheckinTime >= query.StartDate.Value);
}
if (query.EndDate != null)
{
theses = theses.Where(a => a.CheckinTime < query.EndDate.Value);
}
theses.OrderByDescending(t => t.ID);
return(theses.ToList());
}
public IEnumerable <CheckinRecord> Query(CheckinRecordQueryInfo q)
{
var rep = new CheckinRecordRepository(db);
return(rep.Query(q));
}
