public PG <Conf> GetQueryPaging(Conf_filter paging = null, Expression <Func <VD.Data.Entity.Conf, bool> > where = null)
{
IQueryable <Conf> 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("Key"))
{
boloc loc1 = loc;
query = query.Where(q => q.Key.Contains(loc1.giatriloc));
}
}
}
}
return((new PGQuery <Conf>(query)).GetPG(paging));
}
public PG <Contact> GetQueryPaging(Contact_filter paging = null, Expression <Func <Contact, bool> > where = null)
{
IQueryable <Contact> query;
//PHÂN QUYỀN ĐỒ
query = base.GetList(where);
if (paging.contactstatusid != -1)
{
query = query.Where(w => w.ContactStatusId == paging.contactstatusid);
}
//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 <Contact>(query)).GetPG(paging));
}
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 <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));
}
public PG <DonHang> GetQueryPaging(donhang_sp paging = null, Expression <Func <DonHang, bool> > where = null)
{
IQueryable <DonHang> query;
//PHÂN QUYỀN ĐỒ
query = GetList(where);
if (paging.quanid != -1)
{
query = query.Where(w => w.QuanId == paging.quanid);
}
if (paging.trangthaigiaohangid != -1)
{
query = query.Where(w => w.TrangThaiGiaoHangId == paging.trangthaigiaohangid);
}
if (paging.trangthaithanhtoanid != -1)
{
query = query.Where(w => w.TrangThaiThanhToanId == paging.trangthaithanhtoanid);
}
if (paging.ban != -1)
{
query = query.Where(w => w.Ban == paging.ban);
}
if (paging.loctg)
{
query = query.Where(e => EntityFunctions.TruncateTime(e.CreatedDate) >= paging.tu
&&
EntityFunctions.TruncateTime(e.CreatedDate) <=
EntityFunctions.TruncateTime(paging.den));
}
//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;
int id_loc = -1;
if (int.TryParse(loc1.giatriloc, out id_loc))
{
query = query.Where(q => q.Id == id_loc);
}
}
}
}
PG <DonHang> vmpg = null;
//TOTAL RECORDS
int tongdong = query.Count();
decimal tongtien = query.Sum(s => (decimal?)s.TongTienHang) ?? 0;
//PAGING INFORMATION
if (paging.tongdongmottrang != -1)
{
query = query.Skip(paging.numSkip).Take(paging.tongdongmottrang);
}
vmpg = new PG <DonHang>(tongdong, paging.tranghientai, paging.tongdongmottrang, paging.fnjs);
vmpg.L = query.ToList();
vmpg.TongTien = tongtien;
return(vmpg);
}
