public IQueryable<Item> GetItems([QueryString("id")] int? itemCategoryId) { var _db = new PresentationWebForms.Models.DataContext(); IQueryable<Item> query = _db.Items; if (itemCategoryId.HasValue && itemCategoryId > 0) { query = query.Where(p => p.ItemCategoryId == itemCategoryId); } return query; }
public IQueryable<Item> GetSingleItem([QueryString("ItemId")]int? ItemId) { var _db = new PresentationWebForms.Models.DataContext(); IQueryable<Item> query = _db.Items; if (ItemId.HasValue && ItemId > 0) { query = query.Where(p => p.ItemId == ItemId); } else { query = null; } return query; }
public IQueryable<ItemCategory> GetItemCategories() { var db = new PresentationWebForms.Models.DataContext(); IQueryable<ItemCategory> query = db.ItemCategories; return query; }