// GET: Search
/// <summary>
/// A search page [view]
/// </summary>
public ActionResult Index(string key, int?costBegin, int?costEnd)
{// từ trang khác, chuyển trang qua Search
IQueryable <Product> products = null;
if (!string.IsNullOrEmpty(key))
{
//products = db.Products.Where();
List <string> nameList = (List <string>)db.Products.Select(n => n.Name).ToList();
SimilarSearch similarSearch = new SimilarSearch(key, nameList);
nameList = similarSearch.getResult(20);
products = db.Products.Where(n => nameList.Any(s => s == n.Name));
}
else
{
products = db.Products;
}
if (costBegin != null)
{
products = products.Where(p => p.CostPrice >= costBegin);
}
if (costEnd != null)
{
products = products.Where(p => p.CostPrice <= costEnd);
}
// keyword bỏ vào search box (cho người dùng biết họ đã nhập cái gì)
ViewData["key"] = key;
// dữ liệu đổ vào Side search
ViewData["Categories"] = db.Categories.ToList();
ViewData["Authors"] = db.Authors.ToList();
// sản phẩm của kết quả search từ trang khác
return(View(products.ToList()));
}
public ActionResult Search(
string key
, int?authorId, int?categoryId
, int?costBegin, int?costEnd)
{// search từ trang search, gọi lệnh search cùng các filter parameter
if (costBegin != null)
{
costBegin *= 1000;
}
if (costEnd != null)
{
costEnd *= 1000;
}
IQueryable <Product> products;
if (!string.IsNullOrEmpty(key))
{
//products = db.Products.Where(p => p.Name.Contains(key));
List <string> nameList = (List <string>)db.Products.Select(n => n.Name).ToList();
SimilarSearch similarSearch = new SimilarSearch(key, nameList);
nameList = similarSearch.calcSimilarity();
products = db.Products.Where(n => nameList.Contains(n.Name));
}
else
{
products = db.Products;
}
if (authorId != null)
{
//Product newPrd = new Product();
//var tmp = products.Join(db.ProductDetails, id => id.ID, prId => prId.ProductId, (id, prId)
// => new { id.ID, prId.AuthorId } as ProductItemView)
// .Where(a => a.prId.AuthorId == authorId).ToList();
//products = products.Where(n => tmp.Contains(n.ID));
List <Product> tmp = products.ToList();
List <Product> tmp2 = new List <Product>(tmp);
foreach (var singleProduct in tmp2)
{
var details = singleProduct.ProductDetails;
if (details != null)
{
var found = details.Where(pd => pd.AuthorId == authorId);
if (found == null || found.Count() == 0)
{
tmp.Remove(singleProduct);
}
}
}
if (tmp.Count == 0)
{
return(Json(tmp, JsonRequestBehavior.AllowGet));
}
try
{
products = tmp.AsQueryable();
}
catch (Exception)
{
return(Json("lỗi không xác định", JsonRequestBehavior.AllowGet));
}
}
if (categoryId != null)
{
products = products.Where(p => p.CategoryId == categoryId);
if (products.Count() == 0)
{
return(PartialView("ItemPartial", new List <Product>()));
}
}
if (costBegin != null)
{
products = products.Where(p => p.Price >= costBegin);
if (products.Count() == 0)
{
return(PartialView("ItemPartial", new List <Product>()));
}
}
if (costEnd != null)
{
products = products.Where(p => p.Price <= costEnd);
if (products.Count() == 0)
{
return(PartialView("ItemPartial", new List <Product>()));
}
}
// trả về list products
return(PartialView("ItemPartial", products.ToList()));
}
