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); }