private Expression <Func <Doctor, bool> > ApplySearch(SearchParamter searchParamter)
{
return
(x =>
(string.IsNullOrEmpty(searchParamter.SearchQuery) || x.Name.ToLower().Contains(searchParamter.SearchQuery.ToLower())) &&
(searchParamter.IdRelated == null || x.CategoryId == searchParamter.IdRelated));
}
private Expression <Func <BeatyandHealthy, bool> > ApplyMainFilter(SearchParamter filter)
{
return(e => (string.IsNullOrEmpty(filter.SearchQuery) ||
e.Category.ToLower().Contains(filter.SearchQuery.ToLower())) &&
(!filter.CreateFrom.HasValue || e.CreateDate >= filter.CreateFrom) &&
(!filter.CreateTo.HasValue || e.CreateDate <= filter.CreateTo));
}
private static Expression <Func <Medicin, bool> > ApplyFiliter(SearchParamter searchParamter)
{
return(x =>
(string.IsNullOrEmpty(searchParamter.SearchQuery) || x.Name.ToLower().Contains(searchParamter.SearchQuery.ToLower())) &&
(searchParamter.CreateFrom == null || x.CreateDate >= searchParamter.CreateFrom) &&
(searchParamter.CreateTo == null || x.CreateDate <= searchParamter.CreateTo));
}
public IActionResult Index(SearchParamter searchParamter)
{
searchParamter.Page = searchParamter.Page ?? 1;
searchParamter.PageSize = 5;
var model = _categoryRelativiesRepository.GetSearchResult(searchParamter);
return(View(model));
}
private Expression <Func <RelativeofBeatyandhealthy, bool> > ApplyFiliter(SearchParamter searchParamter)
{
return
(x =>
(string.IsNullOrEmpty(searchParamter.SearchQuery) ||
x.Address.ToLower().Contains(searchParamter.SearchQuery.ToLower())) &&
(!searchParamter.CreateFrom.HasValue || x.CreateDate >= searchParamter.CreateFrom) &&
(!searchParamter.CreateTo.HasValue || x.CreateDate <= searchParamter.CreateTo) &&
(!searchParamter.IdRelated.HasValue || x.BeatyandHealthy.Id == searchParamter.IdRelated));
}
public static SearchResult <T> PagingModel <T>(IQueryable <T> searchHits, SearchParamter searchParamter) where T : BaseEntity
{
var subset = searchHits.Skip((searchParamter.Page.Value - 1) * searchParamter.PageSize).Take(searchParamter.PageSize);
searchParamter.TotalCount = searchHits.Count();
var searchResult = new SearchResult <T>()
{
ItemsList = subset,
SearchParamter = searchParamter
};
return(searchResult);
}
public async Task <IActionResult> ExportToExcel(SearchParamter searchParamter)
{
var relativescategories = await _categoryRelativiesRepository.SearchHits(searchParamter);
using (var workbook = new XLWorkbook())
{
var worksheet = workbook.Worksheets.Add("RelativeCategory");
_excelHelper.AddRelativesCategoryExcelConfig(worksheet, relativescategories);
using (var stream = new MemoryStream())
{
workbook.SaveAs(stream);
var content = stream.ToArray();
var contentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet";
return(File(content, contentType));
}
}
}
public SearchResult <Medicin> GetSearchResult(SearchParamter searchParamter)
{
var searchHits = GetAll(ApplyFiliter(searchParamter))
.Include(m => m.BeatyandHealthy).Include(m => m.DiseaseMedicins).OrderByDescending(a => a.Id)
.Select(m => new Medicin()
{
Name = m.Name,
Affects = m.Affects,
Indications = m.Indications,
Id = m.Id,
Image = m.Image,
BeatyandHealthy = m.BeatyandHealthy,
Price = m.Price,
DiseaseMedicins = m.DiseaseMedicins,
CreateDate = m.CreateDate
});
return(PagingHelper.PagingModel(searchHits, searchParamter));
}
public SearchResult <Disease> GetSearchResult(SearchParamter searchParamter)
{
var searchHits = GetAll(ApplyFiliter(searchParamter)).Include(d => d.BeatyandHealthy).OrderByDescending(a => a.Id);
return(PagingHelper.PagingModel(searchHits, searchParamter));
}
public DoctorSearchHint(SearchParamter searchParamter)
{
searchHintBase = new SearchHintBase(searchParamter);
}
private IQueryable <BeatyandHealthy> Search(SearchParamter searchParamter)
{
return(GetAll(ApplyMainFilter(searchParamter)).OrderByDescending(a => a.Id));
}
public SearchResult <BeatyandHealthy> GetSearchResult(SearchParamter searchParamter)
{
return(PagingHelper.PagingModel(Search(searchParamter), searchParamter));
}
public async Task <IEnumerable <BeatyandHealthy> > GetSearchHits(SearchParamter searchParamter)
{
return(await Search(searchParamter).ToListAsync());
}
public DiseaseSearchHint(SearchParamter searchParamter)
{
searchHintBase = new SearchHintBase(searchParamter);
}
public MedicinSearchHint(SearchParamter searchParamter)
{
searchHintBase = new SearchHintBase(searchParamter);
}
public SearchResult <Doctor> GetSearchResult(SearchParamter searchParamter)
{
var searchHits = GetAll(ApplySearch(searchParamter)).Include(d => d.Category).OrderByDescending(a => a.Id);
return(PagingHelper.PagingModel(searchHits, searchParamter));
}
public SearchHintBase(SearchParamter searchParamter)
{
this.searchParamter = searchParamter;
}
public async Task <IActionResult> ExportToPDF(SearchParamter searchParamter)
{
var categories = await _categoryRelativiesRepository.SearchHits(searchParamter);
return(new ViewAsPdf(categories));
}
public async Task <IEnumerable <RelativeofBeatyandhealthy> > SearchHits(SearchParamter searchParamter)
{
return(await Search(searchParamter).ToListAsync());
}
private IQueryable <RelativeofBeatyandhealthy> Search(SearchParamter searchParamter)
{
return(GetAll(ApplyFiliter(searchParamter)).Include(rc => rc.BeatyandHealthy).OrderByDescending(a => a.Id));
}
public CategoryRelativeSearchHint(SearchParamter searchParamter)
{
searchHintBase = new SearchHintBase(searchParamter);
}
