public string CateNameChild(int cateChildId)
{
var cacherKey = Cacher.CreateCacheKey("GetCateCodeChild", cateChildId);
var model = Cacher.Get <string>(cacherKey);
if (model == null)
{
using (VietCuongEntities ctx = new VietCuongEntities())
{
model = (from i in ctx.CateChilds where i.Id == cateChildId && String.IsNullOrEmpty(i.flag) select i.Name).FirstOrDefault();
}
Cacher.Add(cacherKey, model);
}
return(model);
}
public List <Cate> GetListCate()
{
var cacherKey = Cacher.CreateCacheKey("GetCate");
var model = Cacher.Get <List <Cate> >(cacherKey);
using (VietCuongEntities ctx = new VietCuongEntities())
{
if (model == null)
{
model = (from i in ctx.Cates where String.IsNullOrEmpty(i.flag) && i.Status == 1 orderby i.Sort select i).ToList();
Cacher.Add(cacherKey, model);
}
}
return(model);
}
public List <CateChild> GetListCateChild(int cate)
{
var cacherKey = Cacher.CreateCacheKey("GetCate", cate);
var model = Cacher.Get <List <CateChild> >(cacherKey);
if (model == null)
{
using (VietCuongEntities ctx = new VietCuongEntities())
{
model = (from i in ctx.CateChilds where String.IsNullOrEmpty(i.flag) && i.CateId == cate && i.Status == 1 orderby i.Sort select i).ToList();
}
Cacher.Add(cacherKey, model);
}
return(model);
}
public Cate GetCateByCode(string code)
{
var cacherKey = Cacher.CreateCacheKey("GetCateByCode", code);
var model = Cacher.Get <Cate>(cacherKey);
if (model == null)
{
using (VietCuongEntities ctx = new VietCuongEntities())
{
model = (from i in ctx.Cates
where i.NameCode == code &&
String.IsNullOrEmpty(i.flag)
select i).FirstOrDefault();
}
Cacher.Add(cacherKey, model);
}
return(model);
}
public List <New> GetNewsHome()
{
var cacherKey = Cacher.CreateCacheKey("GetNewsHome");
var news = Cacher.Get <List <New> >(cacherKey);
if (news == null)
{
using (VietCuongEntities ctx = new VietCuongEntities())
{
news = (from i in ctx.News
where i.Status == 1 && String.IsNullOrEmpty(i.flag)
orderby i.Create_Day descending
select i).Take(5).ToList();
}
Cacher.Add(cacherKey, news);
}
return(news);
}
public List <string> GetListImg(int productId, string firstImg)
{
var cacherKey = Cacher.CreateCacheKey("GetListImg", productId);
var model = Cacher.Get <List <string> >(cacherKey);
if (model == null)
{
using (VietCuongEntities ctx = new VietCuongEntities())
{
model = (from i in ctx.ImageDetails
where i.ItemId == productId &&
String.IsNullOrEmpty(i.flag)
select i.Link).ToList();
model.Insert(0, firstImg);
}
Cacher.Add(cacherKey, model);
}
return(model);
}
public Product GetDetailProduct(string namecode)
{
var cacherKey = Cacher.CreateCacheKey("GetDetailProduct", namecode);
var model = Cacher.Get <Product>(cacherKey);
if (model == null)
{
using (VietCuongEntities ctx = new VietCuongEntities())
{
var item = (from i in ctx.Items
where i.NameCode == namecode &&
String.IsNullOrEmpty(i.flag) &&
i.Status == 1
select i).FirstOrDefault();
model = GetProdcut(item);
}
Cacher.Add(cacherKey, model);
}
return(model);
}
public List <Product> GetListProductById(int?id)
{
var cacherKey = Cacher.CreateCacheKey("GetListProductById", id);
var model = Cacher.Get <List <Product> >(cacherKey);
if (model == null)
{
using (VietCuongEntities ctx = new VietCuongEntities())
{
model = new List <Product>();
var lstItem = (from i in ctx.Items
where i.CateChildId == id && i.Status == 1
orderby i.Create_Day descending
select i).Take(4).ToList();
foreach (var i in lstItem)
{
var product = GetProdcut(i);
model.Add(product);
}
}
Cacher.Add(cacherKey, model);
}
return(model);
}
public ListCateItem GetProductByCateId(int id, int page, string search, bool isChild)
{
int pageSize = 8;
string originLink = LinkHelper.GetBase(HttpContext.Current.Request.Url.AbsolutePath);
var cacheKey = Cacher.CreateCacheKey("GetCateProduct", id, page, search, isChild);
var model = Cacher.Get <ListCateItem>(cacheKey);
var lstProduct = new List <Product>();
var lstItem = new List <DataAccess.Item>();
int listCount = 0;
if (model == null)
{
using (VietCuongEntities ctx = new VietCuongEntities())
{
lstProduct = new List <Product>();
if (isChild)
{
lstItem = (from i in ctx.Items
where i.CateChildId == id &&
String.IsNullOrEmpty(i.flag) &&
i.Status == 1 &&
i.NameCode.Contains(search)
orderby i.Create_Day descending
select i).Skip((page - 1) * pageSize).Take(pageSize).ToList();
listCount = (from i in ctx.Items
where i.CateChildId == id &&
String.IsNullOrEmpty(i.flag) &&
i.Status == 1 &&
i.NameCode.Contains(search)
select i).ToList().Count();
}
else
{
lstItem = (from i in ctx.Items
where i.CateId == id &&
String.IsNullOrEmpty(i.flag) &&
i.Status == 1 &&
i.NameCode.Contains(search)
orderby i.Create_Day descending
select i).Skip((page - 1) * pageSize).Take(pageSize).ToList();
listCount = (from i in ctx.Items
where i.CateId == id &&
String.IsNullOrEmpty(i.flag) &&
i.Status == 1 &&
i.NameCode.Contains(search)
select i).ToList().Count();
}
if (lstItem != null)
{
foreach (var i in lstItem)
{
var product = GetProdcut(i);
lstProduct.Add(product);
}
int totalpage = PaginationHelper.GetTotal(pageSize, listCount);
List <int> pagination = PaginationHelper.GetPage(page, totalpage, 4);
model = new ListCateItem()
{
LstProduct = lstProduct,
OriginLink = originLink,
Page = page,
Pagination = pagination,
Search = search
};
Cacher.Add(cacheKey, model);
}
}
}
return(model);
}
