public IQueryable <Models.Product> GetProducts([QueryString("id")] int?categoryId) { var db = new Models.MyDbContext(); IQueryable <Models.Product> query = db.Products; return((categoryId ?? 0) > 0 ? query.Where(p => p.CategoryID == categoryId) : query); }
public IQueryable <Category> GetCategories() { var db = new Models.MyDbContext(); IQueryable <Category> query = db.Categories; return(query); }
public IQueryable <Models.Product> GetProduct([QueryString("productID")] int?productId) { if ((productId ?? 0) < 1) { return(null); } var db = new Models.MyDbContext(); IQueryable <Models.Product> query = db.Products; return(query.Where(p => p.ProductID == productId)); }