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