public monantotal Get_Mon_An_Loai(int id, int pageSize, int pageIndex, int order) { var ds = _context.monans.Where(x => x.idloaimon == id); switch (order) { case 1: //mac dinh ds = ds.OrderBy(x => x.tenmon); break; case 2: // theo ten ds = ds.OrderBy(x => x.tenmon); break; case 3: // danh gia ds = ds.OrderByDescending(x => x.id); break; case 4: // moi nhat ds = ds.OrderByDescending(x => x.id); break; case 5: // thap cao ds = ds.OrderBy(x => x.gia); break; case 6: // cao thap ds = ds.OrderByDescending(x => x.gia); break; } int count = ds.Count(); int index = (pageSize * (pageIndex - 1)); ds = ds.Skip(index).Take(pageSize); monantotal result = new monantotal(); result.monans = ds.ToList(); result.total = count; return(result); }
public monantotal Get_Mon_An_Loai_Search(int?id, int pageSize, int pageIndex, int order, string search) { IQueryable <monan> ds; if (id == 0) { if (search == null || search == "") { ds = _context.monans; } else { ds = _context.monans.Where(x => x.tenmon.IndexOf(search) >= 0); } } else { if (search == null || search == "") { ds = _context.monans.Where(x => x.idloaimon == id); } else { ds = _context.monans.Where(x => x.idloaimon == id && x.tenmon.IndexOf(search) >= 0); } } switch (order) { case 1: //mac dinh ds = ds.OrderBy(x => x.tenmon); break; case 2: // theo ten ds = ds.OrderBy(x => x.tenmon); break; case 3: // danh gia ds = ds.OrderByDescending(x => x.id); break; case 4: // moi nhat ds = ds.OrderByDescending(x => x.id); break; case 5: // thap cao ds = ds.OrderBy(x => x.gia); break; case 6: // cao thap ds = ds.OrderByDescending(x => x.gia); break; } int count = ds.Count(); int index = (pageSize * (pageIndex - 1)); ds = ds.Skip(index).Take(pageSize); monantotal result = new monantotal(); result.monans = ds.ToList(); result.total = count; return(result); }