public Search_PersonDTO Search(Search_PersonDTO search) { try { search.Term1 = string.IsNullOrWhiteSpace(search.Term1) ? null : search.Term1; var result = from r in context.People // ------ Edit this to apply terms to desired fields in the desired way // where (search.Term1 == null || r.StringField.Contains(search.Term1)) // && (search.Term2 == null || r.IntField == search.Term2) // && (search.Term3 == null || r.DateTimeField == search.Term3) // && (search.Term4 == null || r.DecimalField == search.Term4) select r; search.recCount = result.Count(); // Apply sort order var applyOrdering = search.Orderings[search.sort]; result = applyOrdering(result, search.sortDir == "ASC"); // Take a page of data var recs = result.Skip(search.skip).Take(search.recsPerPage); search.results = recs.ToList(); } catch (Exception ex) { Utilities.LogException(_controller, ex); search.results = new List<Person>(); } search.refreshAll = false; return search; }
public Search_PersonDTO Search(Search_PersonDTO search) { try { search.Term1 = string.IsNullOrWhiteSpace(search.Term1) ? null : search.Term1; var result = from r in context.People // ------ Edit this to apply terms to desired fields in the desired way // where (search.Term1 == null || r.StringField.Contains(search.Term1)) // && (search.Term2 == null || r.IntField == search.Term2) // && (search.Term3 == null || r.DateTimeField == search.Term3) // && (search.Term4 == null || r.DecimalField == search.Term4) select r; search.recCount = result.Count(); // Apply sort order var applyOrdering = search.Orderings[search.sort]; result = applyOrdering(result, search.sortDir == "ASC"); // Take a page of data var recs = result.Skip(search.skip).Take(search.recsPerPage); search.results = recs.ToList(); } catch (Exception ex) { Utilities.LogException(_controller, ex); search.results = new List <Person>(); } search.refreshAll = false; return(search); }
// [OutputCache(Location = System.Web.UI.OutputCacheLocation.None)] public ActionResult Search(int id = 0, string formView = null, bool showAll = false, string funcRefresh = null, string funcSelect = null) { var dto = new Search_PersonDTO { FormView = formView, funcParentRefresh = funcRefresh, funcParentSelect = funcSelect }; if(showAll) dto = Repository_person.Search(dto); return PartialView(dto); }
public ActionResult Search(Search_PersonDTO search) { ModelState.Clear(); var refreshView = search.refreshAll; return PartialView(refreshView ? "Search" : "SearchResults", Repository_person.Search(search)); }