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