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