public IQueryable <City> GetAsQueryable(CitySearchCriteria criteria, string includeProperties = "")
{
var outerpredicate = PredicateBuilder.New <City>(true);
if (criteria.Id != null)
{
outerpredicate = outerpredicate.And(d => d.Id == criteria.Id.Value);
}
return(Get(outerpredicate, includeProperties: includeProperties));
}
public List <City> GetCityeBySearch(CitySearchCriteria criteria)
{
IQueryable <City> cities = db.Cities.Where(c => c.isDelete == false).AsQueryable();
if (!string.IsNullOrEmpty(criteria.Name))
{
cities = cities.Where(c => c.Name.ToLower().Contains(criteria.Name.ToLower()));
}
return(cities.ToList());
}
//
// GET: /City/
public ActionResult Index(CitySearchCriteria model)
{
var cities = _cityManager.GetCityeBySearch(model);
if (cities == null)
{
cities = new List <City>();
}
model.CountryListItem = GetAllCountryList();
model.City = cities;
return(View(model));
}
public CitySearchResult Get(CitySearchCriteria citySearchCriteria)
{
var res = new CitySearchResult();
try
{
res.cityDTOs = cityRepository.GetAsQueryable(citySearchCriteria)
.Select(city => new CityDTO
{
Id = city.Id,
Name = city.Name
}).ToList();
res.TotalCount = res.cityDTOs.Count;
}
catch (Exception ex)
{
res.Exception = ex;
res.Message = "Error";
}
return(res);
}
public ActionResult <ExecutionResponse <bool> > Delete([FromBody] CitySearchCriteria searchCriteria)
{
var id = searchCriteria.Id ?? 0;
return(Ok(cityOrchestrator.Delete(id)));
}
public ActionResult <CitySearchResult> Get(CitySearchCriteria citySearchCriteria)
{
return(Ok(cityOrchestrator.Get(citySearchCriteria)));
}
public List <City> GetCityeBySearch(CitySearchCriteria criteria)
{
List <City> cities = _cityRepository.GetCityeBySearch(criteria);
return(cities);
}
