public List<ProdResult> ReturnProduct(int? catagoryId) { var _db = new WebFormsDemo.Models.ProductContext(); List<ProdResult> product = null; IQueryable<Product> query = _db.Products; if (catagoryId.HasValue && catagoryId > 0) { query = query.Where(p => p.CategoryID == catagoryId); } if (query.Count()>0) { IEnumerable<Product> penum = query.AsEnumerable<Product>(); product = new List<ProdResult>(); for (int i = 0; i < penum.Count(); i++) { ProdResult prod = new ProdResult(); prod.ProductName = penum.ElementAt(i).ProductName.Trim(); prod.Description = penum.ElementAt(i).Description.Trim(); prod.ImagePath = penum.ElementAt(i).ImagePath.Trim(); prod.UnitPrice = penum.ElementAt(i).UnitPrice.ToString().Trim(); product.Add(prod); prod = null; } } return product; }
public IQueryable<Product> GetProducts([QueryString("id")] int? categoryId) { var _db = new WebFormsDemo.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) { var _db = new WebFormsDemo.Models.ProductContext(); IQueryable<Product> query = _db.Products; if (productid.HasValue && productid > 0) { query = query.Where(p => p.ProductID == productid); } else { query = null; } return query; }
public IQueryable<Catagory> GetCategories() { var _db = new WebFormsDemo.Models.ProductContext(); IQueryable<Catagory> query = _db.Catagories; return query; }