public PartialViewResult ajax_paging(User_filter paging)
{
PG <User> vmpg;
vmpg = _userServ.GetQueryPaging(paging, w => w.RoleId == 2);
return(PartialView(vmpg));
}
public PartialViewResult ajax_paging(User_filter paging)
{
PG <User> vmpg;
vmpg = _userServ.GetQueryPaging(paging, w => w.Username != "vuondao");
return(PartialView(vmpg));
}
public PartialViewResult ajax_paging(User_filter paging)
{
var __auth = MySsAuthUsers.GetAuth();
PG <User> vmpg;
vmpg = _userServ.GetQueryPaging(paging, w => w.OwnerId == __auth.ID);
return(PartialView(vmpg));
}
public PG <User> GetQueryPaging(User_filter paging = null, Expression <Func <VD.Data.Entity.User, bool> > where = null)
{
IQueryable <User> query;
//PHÂN QUYỀN ĐỒ
query = GetList(where);
if (paging.roleid != null && paging.roleid != -1)
{
query = query.Where(w => w.RoleId == paging.roleid);
}
if (paging.isvip)
{
query = query.Where(w => w.IsVip1);
}
//SORTING
query = query.OrderByField(paging.tentruongsort, paging.giatrisort == "asc");
//FILTERING
if (paging.bolocs != null)
{
foreach (var loc in paging.bolocs)
{
if (loc.tentruongloc.Equals("full_text_search"))
{
boloc loc1 = loc;
query = query.FullTextSearch(loc1.giatriloc, true);
}
else
{
if (loc.tentruongloc.Equals("Username"))
{
boloc loc1 = loc;
query = query.Where(q => q.Username.Contains(loc1.giatriloc));
}
}
}
}
return((new PGQuery <User>(query)).GetPG(paging));
}
