public ActionResult Search(int id = 0, string formView = null, bool includeResults = true, string funcRefresh = null, string funcSelect = null) { var dto = new SearchDTO_Person { FormView = formView }; dto = includeResults ? _db.Search(dto) : null; return PartialView(dto); }
public SearchDTO_Person Search(SearchDTO_Person search) { try { search.FirstName = string.IsNullOrWhiteSpace(search.FirstName) ? null : search.FirstName; search.LastName = string.IsNullOrWhiteSpace(search.LastName) ? null : search.LastName; search.DoB_From = search.DoB_From.GetValueOrDefault() == default(DateTime) ? null : search.DoB_From; search.DoB_To = search.DoB_To.GetValueOrDefault() == default(DateTime) ? null : search.DoB_To; search.GenderID = search.GenderID.GetValueOrDefault() == default(int) ? null : search.GenderID; var result = from r in All where (search.FirstName == null || r.FirstName.Contains(search.FirstName)) && (search.LastName == null || r.LastName.Contains(search.LastName)) && (search.DoB_From == null || search.DoB_From <= r.DoB) && (search.DoB_To == null || r.DoB <= search.DoB_To) && (search.GenderID == null || r.GenderID == search.GenderID) select r; search.recCount = result.Count(); if (search.Orderings.ContainsKey(search.sort)) // Apply sort order { var applyOrdering = search.Orderings[search.sort]; result = applyOrdering(result, search.sortDir == "ASC"); } else { _controllerContext.ModelState.AddModelError(string.Empty, $"column sort for {search.sort} not implemented"); } // Take page of data var recs = result.Skip(search.skip).Take(search.recsPerPage); search.results = recs.ToList(); } catch (Exception ex) { Utilities.LogException(_controllerContext, ex); search.results = new List <Person>(); } return(search); }
public SearchDTO_Person Search(SearchDTO_Person search) { try { search.FirstName = string.IsNullOrWhiteSpace(search.FirstName) ? null : search.FirstName; search.LastName = string.IsNullOrWhiteSpace(search.LastName) ? null : search.LastName; search.DoB_From = search.DoB_From.GetValueOrDefault() == default(DateTime) ? null : search.DoB_From; search.DoB_To = search.DoB_To.GetValueOrDefault() == default(DateTime) ? null : search.DoB_To; search.GenderID = search.GenderID.GetValueOrDefault() == default(int) ? null : search.GenderID; var result = from r in All where (search.FirstName == null || r.FirstName.Contains(search.FirstName)) && (search.LastName == null || r.LastName.Contains(search.LastName)) && (search.DoB_From == null || search.DoB_From <= r.DoB ) && (search.DoB_To == null || r.DoB <= search.DoB_To) && (search.GenderID == null || r.GenderID == search.GenderID) select r; search.recCount = result.Count(); if (search.Orderings.ContainsKey(search.sort)) // Apply sort order { var applyOrdering = search.Orderings[search.sort]; result = applyOrdering(result, search.sortDir == "ASC"); } else { _controllerContext.ModelState.AddModelError(string.Empty, $"column sort for {search.sort} not implemented"); } // Take page of data var recs = result.Skip(search.skip).Take(search.recsPerPage); search.results = recs.ToList(); } catch (Exception ex) { Utilities.LogException(_controllerContext, ex); search.results = new List<Person>(); } return search; }
public IViewComponentResult Invoke(string formView) { var dto = new SearchDTO_Person() { FormView = formView }; return View(rep.Search(dto)); }
public ActionResult Search(SearchDTO_Person search) { ModelState.Clear(); return PartialView(search.entireView ? "Search" : "SearchResults", _db.Search(search)); }