public ActionResult gvListSearch(string searchQuery, int page = 1) {
var se = new UnitySearchData();
var model = se.GetSearch<t_ListOfQuestions>(searchQuery, db.ListOfQuestionsRepository.GetAll()).OrderByDescending(o => o.CreateDate);
return PartialView("gvListPartial", new PagerList<t_ListOfQuestions>(model, page, 100));
}
public ActionResult gvCategorySearch(string searchValue,int page = 1)
{
UnitySearchData usd = new UnitySearchData();
var list = db.CategoryRepository.GetAll();
foreach (var row in list)
{
var obj = list.Where(i => i.ID == row.ParentID).FirstOrDefault();
row.ParentName = (obj == null ? "Главная категория" : obj.Name);
}
var model = usd.GetSearch(searchValue, list);
return PartialView("gvCategory", new PagerList<t_Category>(model.OrderBy(i => i.ParentName).OrderBy(i => i.Order), page));
}
public ActionResult gvProductsSearch(string searchValue,int? CatId, int page = 1)
{
UnitySearchData usd = new UnitySearchData();
IEnumerable<t_Product> list = null;
if (CatId == null)
{
list = db.ProductsRepository.GetAll();
}
else
{
list = db.ProductsRepository.GetAll().Where(i => i.CategoryID == CatId);
}
ViewBag.CategoryId = CatId;
ViewBag.searchValue = searchValue;
ViewBag.CurrentPage = page;
var model = usd.GetSearch(searchValue, list);
return PartialView("gvProducts", new PagerList<t_Product>(model, page));
}
public static IEnumerable<UsersAdminModel> GetSearch(string searchValue)
{
IUnitOfWork repo = DependencyResolver.Current.GetService<IUnitOfWork>();
try
{
/*string sql =
string.Format(
"select * from dbo.t#User where FirstName like '%{0}%' or LastName like '%{0}%' or Email like '%{0}%' or Enable like '%{0}%'",
searchValue);
var list = repo.UserRepository.SqlQuery(sql);*/
var usd = new UnitySearchData();
var list = usd.GetSearch(searchValue, repo.UserRepository.GetAll());
if (list == null)
{
yield return null;
}
foreach (var row in list)
{
yield return new UsersAdminModel()
{
ID = row.ID,
FirstName = row.FirstName ?? "-",
LastName = row.LastName ?? "-",
Email = row.Email ?? "-",
Status = row.Enable
};
}
}
finally
{
repo.Dispose();
}
}
