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));
}