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