// GET: /api/ProductQuery
// If searchText is missing, interpret the request to get 'Featured' products
public IEnumerable <Product> Get()
{
using (BoardwalkContext context = new BoardwalkContext()) {
return(context.Products
.Where(x => x.isfeatured)
.ToList());
}
}
private static void StroreInDatabase(List <Product> allProducts)
{
using (BoardwalkContext context = new BoardwalkContext()) {
context.Database.ExecuteSqlCommand("DELETE FROM product");
context.Products.AddRange(allProducts);
context.SaveChanges();
}
}
// GET: /api/ProductQuery/<searchText>
public IEnumerable <Product> Get(string searchText)
{
using (BoardwalkContext context = new BoardwalkContext()) {
string query = string.Format("SELECT * FROM product WHERE lower(description) LIKE '%{0}%' LIMIT {1}", searchText.ToLower(), MAX_ITEMS);
return(context.Products
.SqlQuery(query)
.ToList());
}
}
