public IEnumerable <Campain> GetCampaigns() { if (!_cachingEx.Exists("Campaigns")) { var result = _dbContext.Campain .Where(i => i.IsActive == true && i.IsFree == false) .OrderBy(i => i.Priority) .ToList(); _cachingEx.Add("Campaigns", result); } return(_cachingEx.Get <List <Campain> >("Campaigns")); }
public List <Category> GetCategories() { if (!_cachingEx.Exists("Categories")) { var categories = _dbContext.Category .Include(i => i.ChildCategories) .OrderBy(i => i.Name) .ToList(); //foreach (var category in categories) //{ // category.SlugUrl = UrlConverter.ToUrlSlug(category.Name); // foreach (var item in category.ChildCategories) // item.SlugUrl = UrlConverter.ToUrlSlug(item.Name); //} //_dbContext.SaveChanges(); _cachingEx.Add("Categories", categories); } return(_cachingEx.Get <List <Category> >("Categories")); }
public IEnumerable <string> GetProvinceDistrict() { if (!_cachingEx.Exists("ProvinceDistrict")) { var provinces = _dbContext.Province .OrderBy(i => i.Name) .Select(i => i.Name) .ToList(); var districts = _dbContext.District .Select(i => i.Name) .ToList(); provinces.AddRange(districts); _cachingEx.Add("ProvinceDistrict", provinces); } return(_cachingEx.Get <List <string> >("ProvinceDistrict")); }