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