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));
}
