private PageViewModel <UserLog> SearchAndGetPage(UserLogSearchCriteria criteria) { //this.db.Configuration.LazyLoadingEnabled = false; var page = this.db.UserLogs.Search(criteria).GetPage(criteria); return(page); }
public static IQueryable <UserLog> Search(this IQueryable <UserLog> userlogs, UserLogSearchCriteria searchCriteria) { if (searchCriteria.UserIDFrom.HasValue) { userlogs = userlogs.Where(x => x.UserID >= searchCriteria.UserIDFrom); } if (searchCriteria.UserIDTo.HasValue) { userlogs = userlogs.Where(x => x.UserID <= searchCriteria.UserIDTo); } if (searchCriteria.DateLoginFrom.HasValue) { userlogs = userlogs.Where(x => x.DateLogin >= searchCriteria.DateLoginFrom); } if (searchCriteria.DateLoginTo.HasValue) { userlogs = userlogs.Where(x => x.DateLogin <= searchCriteria.DateLoginTo); } if (searchCriteria.DateLogoutFrom.HasValue) { userlogs = userlogs.Where(x => x.DateLogout >= searchCriteria.DateLogoutFrom); } if (searchCriteria.DateLogoutTo.HasValue) { userlogs = userlogs.Where(x => x.DateLogout <= searchCriteria.DateLogoutTo); } if (!string.IsNullOrWhiteSpace(searchCriteria.Ip)) { userlogs = userlogs.Where(x => x.Ip.Contains(searchCriteria.Ip)); } return(userlogs); }
public CustomJsonResult Search(UserLogSearchCriteria criteria) { return(this.CustomJson(this.SearchAndGetPage(criteria))); }