public IQueryable <Category> GetCategories() { var _db = new lab1.Models.ProductContext(); IQueryable <Category> query = _db.Categories; return(query); }
public IQueryable <Product> GetProducts([QueryString("id")] int?categoryId) { var _db = new lab1.Models.ProductContext(); IQueryable <Product> query = _db.Products; if (categoryId.HasValue && categoryId > 0) { query = query.Where(p => p.CategoryID == categoryId); } return(query); }
public IQueryable <Product> GetProduct( [QueryString("ProductID")] int?productId, [RouteData] string productName) { var _db = new lab1.Models.ProductContext(); IQueryable <Product> query = _db.Products; if (productId.HasValue && productId > 0) { query = query.Where(p => p.ProductID == productId); } else if (!String.IsNullOrEmpty(productName)) { query = query.Where(p => String.Compare(p.ProductName, productName) == 0); } else { query = null; } return(query); }