// [myAuthApi]
//iddm: thực đơn id
public ListPagingJson <SanPham> layds(string search = "", int iddm = -1, int page = 1, int pageSize = 1000)
{
//initial
var paging = new ListPagingJson <SanPham>();
paging.Paging.RecordsPerPage = pageSize;
paging.Paging.CurrentPage = page;
IQueryable <ThucDonCT> query = __db.ThucDonCT;
if (!string.IsNullOrWhiteSpace(search))
{
query = query.Where(w => w.Product.ProductName.Contains(search) || w.Product.MaSo.Contains(search));
}
if (iddm != -1)
{
query = query.Where(w => w.ThucDonId == iddm);
}
//calculator`1
paging.Paging.TotalRecords = query.Count();
query = query.OrderByDescending(o => o.Id).Skip((page - 1) * pageSize).Take(pageSize);
paging.List = query.Select(item => new SanPham()
{
ID = item.Product.Id,
ThucDonId = item.Id,
MaSo = item.Product.MaSo,
HinhAnh = Utils.site + item.Product.ThumbnailImage + "?v=2",
TenSanPham = item.Product.ProductName,
MoTa = item.Product.Infomation,
DanhMucId = item.Product.ProductCatId,
TenDanhMuc = item.Product.ProductCat.Name,
Hot = item.Product.Hot,
New = item.Product.New,
KM = item.Product.IsGiamGia,
Gia = item.Product.Price,
SoLuongGia = item.Product.SoLuongGia,
BangGiaCT = item.Product.BangGiaCT.Select(s => new BangGiaCTJson()
{
Id = s.Id,
Ten = s.Ten,
Price = s.Price
}).ToList(),
});
return(paging);
}
public IEnumerable <DanhMucSanPham> layds(int quanid, int page = 1, int pageSize = 1000)
{
int __v = Utils.GetRandomNumber(1, 1000);
var td = __db.ProductCat.Where(w => w.QuanId == quanid).ToList().Select(s => new DanhMucSanPham()
{
ID = s.Id,
TenDanhMuc = s.Name,
HinhAnh = Utils.site + s.ImageThumbnail + "?v=" + __v
}).ToList();
foreach (var thucdonitem in td)
{
//initial
var paging = new ListPagingJson <SanPham>();
paging.Paging.RecordsPerPage = pageSize;
paging.Paging.CurrentPage = page;
IQueryable <Product> query = __db.Product;
DanhMucSanPham thucdonitem1 = thucdonitem;
query = query.Where(w => w.ProductCatId == thucdonitem1.ID);
//calculator
paging.Paging.TotalRecords = query.Count();
query = query.OrderByDescending(o => o.Id).Skip((page - 1) * pageSize).Take(pageSize);
paging.List = query.AsQueryable().Select(item => new SanPham()
{
ID = item.Id,
ThucDonId = item.Id,
MaSo = item.MaSo,
HinhAnh = Utils.site + item.ThumbnailImage + "?v=" + __v,
TenSanPham = item.ProductName,
MoTa = item.Infomation,
DanhMucId = item.ProductCatId,
TenDanhMuc = item.ProductCat.Name,
Hot = item.Hot,
New = item.New,
KM = item.IsGiamGia,
Gia = item.Price,
SoLuongGia = item.SoLuongGia,
BangGiaCT = item.BangGiaCT.Select(s => new BangGiaCTJson()
{
Id = s.Id,
Ten = s.Ten,
Price = s.Price,
}).ToList(),
}).ToList();
thucdonitem.DSSP = paging;
}
return(td);
}
public ListPagingJson <DonHangVM> layds(int userid, string token, int page, int pageSize)
{
vuong_cms_context __db = new vuong_cms_context();
//initial
var paging = new ListPagingJson <DonHangVM>();
paging.Paging.RecordsPerPage = pageSize;
paging.Paging.CurrentPage = page;
//calculator
var query = __db.DonHangs.Where(w => w.UserId == userid);
paging.Number1 = query.Count(c => c.TrangThaiThanhToanId == 1);
paging.Paging.TotalRecords = query.Count();
paging.List = DonHangVM.map(query.OrderByDescending(o => o.Id).Skip((page - 1) * pageSize).Take(pageSize));
return(paging);
}
public ListPagingJson <DonHangVM> laydsdevice(string uniqueID, int trangthaithanhtoanid, int page, int pageSize)
{
//initial
var paging = new ListPagingJson <DonHangVM>();
paging.Paging.RecordsPerPage = pageSize;
paging.Paging.CurrentPage = page;
vuong_cms_context __db = new vuong_cms_context();
//calculator
var query = __db.DonHangs.Where(w => w.UniqueID == uniqueID);
paging.Number1 = query.Count(c => c.TrangThaiThanhToanId == 1);
if (trangthaithanhtoanid != -1)
{
query = query.Where(w => w.TrangThaiThanhToanId == trangthaithanhtoanid);
}
paging.Paging.TotalRecords = query.Count();
paging.List = DonHangVM.map(query.OrderByDescending(o => o.Id).Skip((page - 1) * pageSize).Take(pageSize));
//so don hang chua thanh toan
return(paging);
}
