public FindResponse FindArtices(FindRequest request)
{
var response = new FindResponse();
using (var db = DbContext)
{
var query = db.Artices
.AsQueryable();
if (!string.IsNullOrWhiteSpace(request.TextSearch))
{
request.TextSearch = request.TextSearch.ToLower().Trim();
query = query.Where(q => q.Name.ToLower().Contains(request.TextSearch)
|| q.Description.ToLower().Contains(request.TextSearch)
|| q.Content.ToLower().Contains(request.TextSearch)
|| q.Status.ToString().ToLower().Contains(request.TextSearch)
);
}
query = request.IsSortingValid ? request.ApplySortOption(query) : request.ApplyPageOption(query.OrderBy(q => q.Name));
var pagingResult = request.ApplyPageOption(query).ToList();
response.TotalRecords = query.Count();
response.Results = pagingResult.MapList<Artice>();
}
return response;
}
public FindResponse FindArtices(FindRequest request)
{
return Execute(_repository, r => r.FindArtices(request));
}
private void PopulateIndexModel(ArticeIndexModel model)
{
model.InitSortInfo();
if (string.IsNullOrWhiteSpace(model.SortBy))
{
model.SortBy = "Name";
}
var filter = new FindRequest
{
TextSearch = model.TextSearch,
SortOption = new SortOption(new[] { new SortItem(model.SortBy, model.SortDirection.Value) }),
PageOption = new PageOption { PageSize = model.Pagination.PageSize, PageNumber = model.Pagination.CurrentPageIndex }
};
var response = ServiceHelper.Artice.ExecuteDispose(s => s.FindArtices(filter));
model.Results = response.Results.MapList<ArticeModel>();
model.Pagination.TotalRecords = response.TotalRecords;
}
