public static List <ArticleCategory> GetAllChildrenNodesOfSelectedNode(string CategoryCode, string CultureCode, string Status)
{
using (ArticleEntities dbContext = new ArticleEntities())
{
dbContext.CommandTimeout = Settings.CommandTimeout;
System.Data.Objects.ObjectResult <ArticleCategory> obj_result = dbContext.ArticleCategories_GetAllChildrenNodesOfSelectedNode(CategoryCode);
var query = obj_result.AsQueryable();
if (!string.IsNullOrEmpty(CultureCode))
{
query = query.Where(x => x.CultureCode.Trim() == CultureCode);
}
if (!string.IsNullOrEmpty(Status))
{
query = query.Where(x => x.Status.Trim() == Status);
}
return(query.ToList());
}
}
public List <ArticleComment> GetListByArticleIdStatus(int ArticleId, string status)
{
using (ArticleEntities dbContext = new ArticleLibrary.ArticleEntities())
{
dbContext.CommandTimeout = Settings.CommandTimeout;
System.Data.Objects.ObjectResult <ArticleComment> obj_result = dbContext.sp_ArticleComments_GetList();
IQueryable <ArticleComment> query = obj_result.AsQueryable();
if (ArticleId > 0)
{
query = query.Where(x => x.ArticleId == ArticleId);
}
if (!string.IsNullOrEmpty(status))
{
query = query.Where(x => x.Publish == status);
}
return(query.ToList());
}
}