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