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