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