public JsonResult SearchProductsList(string filterText)
{
List <Models.Product> products = new List <Models.Product>();
if (!string.IsNullOrWhiteSpace(filterText))
{
using (OnlineStoreDataContext context = new OnlineStoreDataContext())
{
var query = (from p in context.Products
where p.Name.ToLower().Contains(filterText.ToLower().Trim())
select p).Take(15);
foreach (OnlinestoreContext.Product prod in query)
{
products.Add(new Models.Product
{
sku = prod.Sku,
name = prod.Name,
type = prod.Type,
price = prod.Price.HasValue ? Convert.ToDouble(prod.Price.Value) : 0,
upc = prod.Upc,
shipping = prod.Shipping.HasValue ? Convert.ToDouble(prod.Shipping.Value) : 0,
description = prod.Description,
manufacturer = prod.Manufacturer,
model = prod.Model,
url = prod.Url,
image = !string.IsNullOrWhiteSpace(prod.Image) ? prod.Image.Replace("http:", "https:") : string.Empty
});
}
};
}
return(Json(products, JsonRequestBehavior.AllowGet));
}
public void CanUseDataServiceContextToQueryData()
{
var context = new OnlineStoreDataContext(new Uri("http://localhost:9000/entity"));
context.SendingRequest2 += (sender, e) => Console.WriteLine(e.RequestMessage.Url);
var allProducts = context.Products.ToArray();
foreach ( var product in allProducts )
{
Console.WriteLine("Product ID={0}, Name={1}, Price={2}", product.Id, product.Name, product.Price);
}
}