public ArticleTypeItem GetItemByNameAscii(string nameAscii, bool isShow = true, bool isDeleted = false) { var key = string.Format("ArticleTypeRepositoryGetItemByNameAscii{0}", nameAscii); var articleType = new ArticleTypeItem(); if (!this.TryGetCache <ArticleTypeItem>(out articleType, key)) { articleType = (from p in web365db.tblTypeArticle where p.NameAscii == nameAscii && p.LanguageId == LanguageId && p.IsDeleted == isDeleted orderby p.ID descending select new ArticleTypeItem() { ID = p.ID, Parent = p.Parent, Name = p.Name, NameAscii = p.NameAscii, SEOTitle = p.SEOTitle, SEODescription = p.SEODescription, SEOKeyword = p.SEOKeyword, DateCreated = p.DateCreated, DateUpdated = p.DateUpdated, Number = p.Number, PictureID = p.PictureID, Summary = p.Summary, Detail = p.Detail, IsShow = p.IsShow, IsSinglePage = p.IsSinglePage.HasValue && p.IsSinglePage.Value }).FirstOrDefault(); this.SetCache(key, articleType, 10); } return(articleType); }
public ActionResult EditForm(int?id) { var obj = new ArticleTypeItem(); var listType = articleTypeRepository.GetListForTree <object>(); var listGroup = articleGroupTypeRepository.GetListForTree <object>(); if (id.HasValue) { obj = articleTypeRepository.GetItemById <ArticleTypeItem>(id.Value); } return(Json(new { data = obj, listType = listType, listGroup = listGroup }, JsonRequestBehavior.AllowGet)); }
public ArticleTypeItem GetGroupItemByNameAscii(string nameAscii, bool isShow = true, bool isDeleted = false) { var key = string.Format("GetGroupItemByNameAscii{0}", nameAscii); var articleType = new ArticleTypeItem(); if (!this.TryGetCache <ArticleTypeItem>(out articleType, key)) { articleType = (from p in web365db.tblGroupArticle where p.NameAscii == nameAscii && p.IsShow == isShow && p.IsDeleted == isDeleted orderby p.ID descending select new ArticleTypeItem() { ID = p.ID, Name = p.Name, NameAscii = p.NameAscii, }).FirstOrDefault(); this.SetCache(key, articleType, 10); } return(articleType); }
public ArticleTypeItem GetItemById(int id) { var key = string.Format("ArticleTypeRepositoryGetItemById{0}", id); var articleType = new ArticleTypeItem(); if (!this.TryGetCache <ArticleTypeItem>(out articleType, key)) { var result = (from p in web365db.tblTypeArticle where p.ID == id && p.IsShow == true && p.IsDeleted == false select p).FirstOrDefault(); articleType = new ArticleTypeItem() { ID = result.ID, Parent = result.Parent, 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, Summary = result.Summary, Detail = result.Detail, IsShow = result.IsShow, ListChildID = result.tblTypeArticle1.Where(t => t.IsShow == true && t.IsDeleted == false).OrderByDescending(t => t.Number).ThenByDescending(t => t.ID).Select(t => t.ID).ToArray() }; this.SetCache(key, articleType, 10); } return(articleType); }