public PG <ThongBao> GetQueryPaging(smartpaging paging = null, Expression <Func <ThongBao, bool> > where = null)
{
IQueryable <ThongBao> query;
//PHÂN QUYỀN ĐỒ
query = GetList(where);
//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("ThongBaoname"))
* {
* boloc loc1 = loc;
* query = query.Where(q => q.ThongBaoname.Contains(loc1.giatriloc));
* }*/
}
}
}
return((new PGQuery <ThongBao>(query)).GetPG(paging));
}
public PG <ProductCat> GetQueryPaging(smartpaging paging = null, Expression <Func <ProductCat, bool> > @where = null)
{
IQueryable <ProductCat> query;
//PHÂN QUYỀN ĐỒ
query = GetList(where);
if (paging.quanid != -1)
{
query = query.Where(w => w.QuanId == paging.quanid);
}
//SORTING
query = query.OrderByField(paging.tentruongsort, paging.giatrisort == "asc");
//FILTERING
if (paging.bolocs != null)
{
foreach (var loc in paging.bolocs)
{
//if (loc.tentruongloc.Equals("Username"))
//{
// boloc loc1 = loc;
// // query = query.Where(q => q.Username.Contains(loc1.giatriloc));
//}
}
}
return((new PGQuery <ProductCat>(query)).GetPG(paging));
}
public PartialViewResult ajax_paging(smartpaging paging)
{
PG <ThongBao> vmpg;
vmpg = _ThongBaoerv.GetQueryPaging(paging);
return(PartialView(vmpg));
}
public PartialViewResult ajax_paging(smartpaging paging)
{
var __auth = MySsAuthUsers.GetAuth();
PG <Ban> vmpg;
vmpg = _BanServ.GetQueryPaging(paging, w => w.Quan.UserId == __auth.OwnerId);
return(PartialView(vmpg));
}
public PartialViewResult ajax_paging(smartpaging paging)
{
var __auth = MySsAuthUsers.GetAuth();
PG <Product> vmpg;
if (__auth.Username == "admin")
{
vmpg = _ProductServ.GetQueryPaging(paging);
}
else
{
vmpg = _ProductServ.GetQueryPaging(paging, w => w.ProductCat.Quan.UserId == __auth.OwnerId);
}
return(PartialView(vmpg));
}
public static PG <T> GetPG <T>(this PGQuery <T> query, smartpaging paging)
where T : new()
{
PG <T> vmpg = null;
//TOTAL RECORDS
int tongdong = query.values.Count();
//PAGING INFORMATION
if (paging.tongdongmottrang != -1)
{
query.values = query.values.Skip(paging.numSkip).Take(paging.tongdongmottrang);
}
vmpg = new PG <T>(tongdong, paging.tranghientai, paging.tongdongmottrang, paging.fnjs);
vmpg.L = query.values.ToList();
return(vmpg);
}
public PartialViewResult ajax_paging(smartpaging paging)
{
var __auth = MySsAuthUsers.GetAuth();
PG <Quan> vmpg;
if (__auth.RoleId == 1 && __auth.Username == "admin")
{
vmpg = _QuanServ.GetQueryPaging(paging);
}
else
{
vmpg = _QuanServ.GetQueryPaging(paging, w => w.UserId == __auth.ID);
}
var user = __db.Users.Find(__auth.ID);
ViewBag.QuanDefaultId = user.QuanDefaultId ?? -1;
return(PartialView(vmpg));
}
