public List <City> FindCities(CityCriteria criteria = null) { List <City> cityList = null; string cacheKey = criteria == null ? "CityCriteria_null" : criteria.GetCacheKey(); if (!TryGetCacheData(cacheKey, out cityList)) { cityList = GetCityManager().FindCities(criteria); SetCacheData(_cacheName, cacheKey, cityList); } return(cityList); }
public PagedModel<City> FindForSuggest(CityCriteria c) { PagedModel<City> m = new PagedModel<City>(); var r = this.Repository.FindForSuggest(c.NameSrh); if (!String.IsNullOrEmpty(c.sortname)) { if (c.sortname.ToLower().Equals("id")) { if (c.sortorder.ToLower().Equals("asc")) { r = r.OrderBy(o => o.Id); } else { r = r.OrderByDescending(o => o.Id); } } if (c.sortname.ToLower().Equals("name")) { if (c.sortorder.ToLower().Equals("asc")) { r = r.OrderBy(o => o.Name); } else { r = r.OrderByDescending(o => o.Name); } } if (c.sortname.ToLower().Equals("provinceid")) { if (c.sortorder.ToLower().Equals("asc")) { r = r.OrderBy(o => o.ProvinceId); } else { r = r.OrderByDescending(o => o.ProvinceId); } } } m.RecordCount = r.Count(); if (c.pagesize.HasValue) { int page = c.page ?? 1; int pageCount = m.RecordCount / c.pagesize.Value; if (m.RecordCount % c.pagesize.Value > 0) { pageCount++; } int skip = (page - 1) * c.pagesize.Value; if (skip > 0) { r = r.Skip(skip); } r = r.Take(c.pagesize.Value); } m.Data = r.ToList(); return m; }
/// <summary> /// Find data in database /// </summary> /// <returns></returns> public List <City> Find(CityCriteria cityCriteria = null) { List <City> resultList = null; IQueryable <CityRow> rowList = _dbContext.City; CriteriaTransformer.CompleteQuery(ref rowList, cityCriteria); if (rowList != null) { foreach (var row in rowList) { if (resultList == null) { resultList = new List <City>(); } resultList.Add(CityTransformer.ToBean(row)); } } return(resultList); }
public List <City> FindCities(CityCriteria cityCriteria = null) { return(_module.Find(cityCriteria)); }