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