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