public List <ReferenceDto> GetByPrefix(CountryFilterDto countryFilterDto)
{
return(_genericDao.FindByPrefix <Country>(countryFilterDto, x => new ReferenceDto()
{
Id = x.Id, Label = x.Name
}));
}
public IResponseDTO SearchCountries([FromQuery] CountryFilterDto filterDto)
{
_response = _countryService.SearchCountries(filterDto);
return(_response);
}
public IResponseDTO SearchCountries(CountryFilterDto filterDto)
{
try
{
var query = _appDbContext.Countries.Where(x => !x.IsDeleted);
if (filterDto != null)
{
if (!string.IsNullOrEmpty(filterDto.Name))
{
query = query.Where(x => x.Name.Trim().ToLower().Contains(filterDto.Name.Trim().ToLower()));
}
if (!string.IsNullOrEmpty(filterDto.Code))
{
query = query.Where(x => x.Code.Trim().ToLower().Contains(filterDto.Code.Trim().ToLower()));
}
if (!string.IsNullOrEmpty(filterDto.NativeName))
{
query = query.Where(x => x.NativeName.Trim().ToLower().Contains(filterDto.NativeName.Trim().ToLower()));
}
if (filterDto.IsActive != null)
{
query = query.Where(x => x.IsActive == filterDto.IsActive);
}
}
//Check Sort Property
if (!string.IsNullOrEmpty(filterDto?.SortProperty))
{
//query = query.OrderBy(
// string.Format("{0} {1}", filterDto.SortProperty, filterDto.IsAscending ? "ASC" : "DESC"));
}
else
{
query = query.OrderByDescending(x => x.Id);
}
// Pagination
var total = query.Count();
if (filterDto.PageIndex.HasValue && filterDto.PageSize.HasValue)
{
query = query.Skip((filterDto.PageIndex.Value - 1) * filterDto.PageSize.Value).Take(filterDto.PageSize.Value);
}
var datalist = _mapper.Map <List <CountryDto> >(query.ToList());
_response.IsPassed = true;
_response.Data = new
{
List = datalist,
Total = total,
};
}
catch (Exception ex)
{
_response.Data = null;
_response.IsPassed = false;
_response.Errors.Add($"Error: {ex.Message}");
}
return(_response);
}
