public ProductTypeItem GetByAsciiAndParent(string ascii, int parentId) { var key = string.Format("ProductTypeRepositoryGetByAsciiAndParent{0}{1}", ascii, parentId); var product = new ProductTypeItem(); if (!this.TryGetCache<ProductTypeItem>(out product, key)) { var query = from p in web365db.tblTypeProduct where p.NameAscii == ascii && p.Parent == parentId && p.LanguageId == LanguageId orderby p.ID descending select new ProductTypeItem() { ID = p.ID, Name = p.Name, NameAscii = p.NameAscii, ParentName = p.tblTypeProduct2.Name, ParentNameAscii = p.tblTypeProduct2.NameAscii, SEOTitle = p.SEOTitle, SEODescription = p.SEODescription, SEOKeyword = p.SEOKeyword, DateCreated = p.DateCreated, DateUpdated = p.DateUpdated, Number = p.Number, PictureID = p.PictureID, Detail = p.Detail, IsShow = p.IsShow }; product = query.FirstOrDefault(); this.SetCache(key, product, 10); } return product; }
public ProductTypeItem GetItemById(int id) { var key = string.Format("ProductRepositoryGetItemById{0}", id); var product = new ProductTypeItem(); if (!this.TryGetCache<ProductTypeItem>(out product, key)) { var result = GetById(id); product = new ProductTypeItem() { ID = result.ID, Name = result.Name, NameAscii = result.NameAscii, SEOTitle = result.SEOTitle, SEODescription = result.SEODescription, SEOKeyword = result.SEOKeyword, DateCreated = result.DateCreated, DateUpdated = result.DateUpdated, Number = result.Number, PictureID = result.PictureID, Detail = result.Detail, IsShow = result.IsShow }; this.SetCache(key, product, 10); } return product; }
public ProductTypeItem GetByParentAsciiAndAscii(string parentAscii, string ascii) { var key = string.Format("ProductTypeRepositoryGetByParentAsciiAndAscii{0}{1}", parentAscii, ascii); var productType = new ProductTypeItem(); if (!this.TryGetCache<ProductTypeItem>(out productType, key)) { var result = (from p in web365db.tblTypeProduct where p.tblTypeProduct2.NameAscii == parentAscii && p.NameAscii == ascii && p.LanguageId == LanguageId && p.IsShow == true && p.IsDeleted == false orderby p.ID descending select p).FirstOrDefault(); if (result != null) { productType = new ProductTypeItem() { ID = result.ID, Name = result.Name, NameAscii = result.NameAscii, ParentName = result.tblTypeProduct2.Name, ParentNameAscii = result.tblTypeProduct2.NameAscii, Detail = result.Detail, IsShow = result.IsShow, ListPicture = result.tblPicture1.Select(p => new PictureItem() { ID = p.ID, Link = p.Link, FileName = p.FileName }).ToList() }; } this.SetCache(key, productType, 10); } return productType; }