public static ArticleCategory GetDetailByCode(string code)
{
using (ArticleEntities dbContext = new ArticleEntities())
{
dbContext.CommandTimeout = Settings.CommandTimeout;
var query = (from x in dbContext.ArticleCategories
where x.CategoryCode.Trim() == code
select x).SingleOrDefault();
return query;
}
}
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();
}
}