private ProductResult getDetailsFromId(int id)
{
ProductsDataContext db = new ProductsDataContext();
var query = from p in db.Products
where p.Id == id
select new { p.Category, p.Description, p.Id, p.ImageUrl, p.Name, p.Price, p.Stock };
var result = new ProductResult
{
Name = query.First().Name,
Category = query.First().Category,
Price = (double)query.First().Price,
ImageUrl = query.First().ImageUrl,
Description = query.First().Description,
Stock = query.First().Stock,
Id = query.First().Id
};
return result;
}
public List<ProductResult> getResultsByCategory(string category)
{
ProductsDataContext db = new ProductsDataContext();
var query = from p in db.Products
where p.Category == category
select new { p.Category, p.Description, p.Id, p.ImageUrl, p.Name, p.Price, p.Stock };
var results = new List<ProductResult>();
foreach (var q in query)
{
var result = new ProductResult
{
Name = q.Name,
Category = q.Category,
Price = (double)q.Price,
ImageUrl = q.ImageUrl,
Description = q.Description,
Stock = q.Stock,
Id = q.Id
};
results.Add(result);
}
return results;
}
