public SearchResult <BTSDTO> GetDataByFilter(BTSSearchFilter filter)
{
if (string.IsNullOrEmpty(filter.SortName))
{
filter.SortName = "BTS_PK";
}
BTSQuery btsQuery = new BTSQuery(this.Db);
var filteredRecords =
btsQuery.GetQuery()
.Where(bts =>
bts.Name.Contains(filter.Keyword) ||
bts.OperatorTitle.Contains(filter.Keyword) ||
bts.TowerID.Contains(filter.Keyword) ||
bts.CellID.Contains(filter.Keyword) ||
bts.Alamat.Contains(filter.Keyword)
);
var displayedRecords = filteredRecords.
SortBy(filter.SortName, filter.SortDir)
.Skip(filter.Skip)
.Take(filter.PageSize)
.ToList();
var searchResult = new SearchResult <BTSDTO>(filter);
searchResult.Filter = filter;
searchResult.Count.TotalRecords = btsQuery.GetTotalRecords();
searchResult.Count.TotalFiltered = filteredRecords.Count();
searchResult.Count.TotalDisplayed = displayedRecords.Count();
searchResult.Records = displayedRecords;
return(searchResult);
}
public BTSListModel Get(BTSSearchFilter searchFilter)
{
BTSListFormData formData = new BTSListFormData();
SearchResult <BTSDTO> searchResult = btsSearch.GetDataByFilter(searchFilter);
return(new BTSListModel()
{
FormData = formData,
SearchResult = searchResult
});
}
public IHttpActionResult Search([FromUri] BTSSearchFilter filter)
{
ThrowIfUserHasNoRole(readRole);
if (filter == null)
{
throw new KairosException("Missing search filter parameter");
}
using (var btsSearch = new BTSSearch(Db))
{
var data = btsSearch.GetDataByFilter(filter);
return(Ok(new SuccessResponse(data)));
}
}
