public IQueryable<Item> GetItems([QueryString("id")] int? categoryId)
{
var _db = new DotShop.Models.ItemContext();
IQueryable<Item> query = _db.Items;
if (categoryId.HasValue && categoryId > 0)
{
query = query.Where(i => i.CategoryID == categoryId);
}
return query;
}
public IQueryable<Item> GetItem([QueryString("itemID")]int? itemId)
{
var _db = new DotShop.Models.ItemContext();
IQueryable<Item> query = _db.Items;
if (itemId.HasValue && itemId > 0)
{
query = query.Where(i => i.ItemID == itemId);
}
else
{
query = null;
}
return query;
}
public IQueryable<Category> GetCategories()
{
var db = new DotShop.Models.ItemContext();
IQueryable<Category> query = db.Categories;
return query;
}
