public IQueryable <LOAISANPHAM> GetLOAISANPHAMs() { var _db = new StudentShop.Models.SANPHAM_CT(); IQueryable <LOAISANPHAM> query = _db.LOAISANPHAMs; return(query); }
public IQueryable <SANPHAM> GetSANPHAMs([QueryString("id")] int?categoryId) { var _db = new StudentShop.Models.SANPHAM_CT(); IQueryable <SANPHAM> query = _db.SANPHAMs; if (categoryId.HasValue && categoryId > 0) { query = query.Where(p => p.MALOAISP == categoryId); } return(query); }
public IQueryable <SANPHAM> GetDetails([QueryString("bookID")] int?bookId) { var _db = new StudentShop.Models.SANPHAM_CT(); IQueryable <SANPHAM> query = _db.SANPHAMs; if (bookId.HasValue && bookId > 0) { query = query.Where(p => p.MASP == bookId); } else { query = null; } return(query); }