public static string[] PopulateArticleKeywordList(string prefixText) { using (ArticleEntities dbContext = new ArticleLibrary.ArticleEntities()) { if (dbContext.Connection.State != ConnectionState.Closed) dbContext.Connection.Open(); string LowerKeywords = @prefixText.ToLower(); var query = (from x in dbContext.Articles where x.Headline.ToLower().Contains(LowerKeywords) || x.Alias.Replace("-", " ").Contains(LowerKeywords) || x.Authors.Contains(LowerKeywords) || x.Abstract.Contains(LowerKeywords) || x.Source.Contains(LowerKeywords) || x.Tags.Contains(LowerKeywords) && x.Status == "2" orderby x.ArticleId descending select x).ToList(); string[] items = new string[query.Count]; items = query.Select(o => o.ToString()).ToArray(); return items; } }
public static List<Article> SearchByKeywords(string Keywords, string CultureCode, int iTotalItemCount) { using (ArticleEntities dbContext = new ArticleLibrary.ArticleEntities()) { if (dbContext.Connection.State != ConnectionState.Closed) dbContext.Connection.Open(); string LowerKeywords = @Keywords.ToLower(); var query = from x in dbContext.Articles where x.Headline.ToLower().Contains(LowerKeywords) || x.Alias.Replace("-", " ").Contains(LowerKeywords) || x.Authors.Contains(LowerKeywords) || x.Abstract.Contains(LowerKeywords) || x.MainText.Contains(LowerKeywords) || x.Source.Contains(LowerKeywords) || x.Tags.Contains(LowerKeywords) && x.CultureCode.Trim() == CultureCode && x.Status == "2" orderby x.ArticleId descending select x; int TotalItemCount = 0; if (query.Count() > 0) { if (iTotalItemCount <= query.Count()) TotalItemCount = iTotalItemCount; else TotalItemCount = query.Count(); } return query.Take(TotalItemCount).ToList(); } }
public static List <Article> GetActiveListByTotalViewsFixedNum(string Code, string CultureCode, int iTotalItemCount) { using (ArticleEntities dbContext = new ArticleLibrary.ArticleEntities()) { if (dbContext.Connection.State != ConnectionState.Closed) { dbContext.Connection.Open(); } var query = from x in dbContext.Articles where x.CategoryCode == Code && x.CultureCode.Trim() == CultureCode && x.Status == "2" && x.TotalViews > 3 orderby x.TotalViews descending select x; int TotalItemCount = 0; if (query.Count() > 0) { if (iTotalItemCount <= query.Count()) { TotalItemCount = iTotalItemCount; } else { TotalItemCount = query.Count(); } } return(query.Take(TotalItemCount).ToList()); } }
public static string[] PopulateArticleKeywordList(string prefixText) { using (ArticleEntities dbContext = new ArticleLibrary.ArticleEntities()) { if (dbContext.Connection.State != ConnectionState.Closed) { dbContext.Connection.Open(); } string LowerKeywords = @prefixText.ToLower(); var query = (from x in dbContext.Articles where x.Headline.ToLower().Contains(LowerKeywords) || x.Alias.Replace("-", " ").Contains(LowerKeywords) || x.Authors.Contains(LowerKeywords) || x.Abstract.Contains(LowerKeywords) || x.Source.Contains(LowerKeywords) || x.Tags.Contains(LowerKeywords) && x.Status == "2" orderby x.ArticleId descending select x).ToList(); string[] items = new string[query.Count]; items = query.Select(o => o.ToString()).ToArray(); return(items); } }
public static List <Article> GetActiveListByFixedRecords(int iTotalItemCount) { using (ArticleEntities dbContext = new ArticleLibrary.ArticleEntities()) { if (dbContext.Connection.State != ConnectionState.Closed) { dbContext.Connection.Open(); } List <Article> lst = (from x in dbContext.Articles where x.Status == "2" orderby x.ArticleId descending select x).ToList(); int TotalItemCount = 0; if (lst.Count() > 0) { if (iTotalItemCount <= lst.Count()) { TotalItemCount = iTotalItemCount; } else { TotalItemCount = lst.Count(); } } return(lst.Take(TotalItemCount).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(); } }
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()); } }
public static List <Article> GetActiveListByFixedNumCode(string Code, int iTotalItemCount) { using (ArticleEntities dbContext = new ArticleLibrary.ArticleEntities()) { if (dbContext.Connection.State != ConnectionState.Closed) { dbContext.Connection.Open(); } IQueryable <Article> query = from x in dbContext.Articles where x.Status == "2" orderby x.ArticleId descending select x; List <Article> lst = new List <Article>(); if (string.IsNullOrEmpty(Code)) { lst = query.ToList(); } else { lst = query.Where(x => x.CategoryCode.Trim() == Code).ToList(); } int TotalItemCount = 0; if (lst.Count() > 0) { if (iTotalItemCount <= lst.Count()) { TotalItemCount = iTotalItemCount; } else { TotalItemCount = lst.Count(); } } return(lst.Take(TotalItemCount).ToList()); } }
public static List <Article> SearchByKeywords(string Keywords, string CultureCode, int iTotalItemCount) { using (ArticleEntities dbContext = new ArticleLibrary.ArticleEntities()) { if (dbContext.Connection.State != ConnectionState.Closed) { dbContext.Connection.Open(); } string LowerKeywords = @Keywords.ToLower(); var query = from x in dbContext.Articles where x.Headline.ToLower().Contains(LowerKeywords) || x.Alias.Replace("-", " ").Contains(LowerKeywords) || x.Authors.Contains(LowerKeywords) || x.Abstract.Contains(LowerKeywords) || x.MainText.Contains(LowerKeywords) || x.Source.Contains(LowerKeywords) || x.Tags.Contains(LowerKeywords) && x.CultureCode.Trim() == CultureCode && x.Status == "2" orderby x.ArticleId descending select x; int TotalItemCount = 0; if (query.Count() > 0) { if (iTotalItemCount <= query.Count()) { TotalItemCount = iTotalItemCount; } else { TotalItemCount = query.Count(); } } return(query.Take(TotalItemCount).ToList()); } }
public static List<Article> GetActiveListByTotalViewsFixedNum(string Code, string CultureCode, int iTotalItemCount) { using (ArticleEntities dbContext = new ArticleLibrary.ArticleEntities()) { if (dbContext.Connection.State != ConnectionState.Closed) dbContext.Connection.Open(); var query = from x in dbContext.Articles where x.CategoryCode == Code && x.CultureCode.Trim() == CultureCode && x.Status == "2" && x.TotalViews > 3 orderby x.TotalViews descending select x; int TotalItemCount = 0; if (query.Count() > 0) { if (iTotalItemCount <= query.Count()) TotalItemCount = iTotalItemCount; else TotalItemCount = query.Count(); } return query.Take(TotalItemCount).ToList(); } }
public static List<Article> GetActiveListByFixedNumCode(string Code, int iTotalItemCount) { using (ArticleEntities dbContext = new ArticleLibrary.ArticleEntities()) { if (dbContext.Connection.State != ConnectionState.Closed) dbContext.Connection.Open(); IQueryable<Article> query = from x in dbContext.Articles where x.Status == "2" orderby x.ArticleId descending select x; List<Article> lst = new List<Article>(); if (string.IsNullOrEmpty(Code)) lst = query.ToList(); else lst = query.Where(x => x.CategoryCode.Trim() == Code).ToList(); int TotalItemCount = 0; if (lst.Count() > 0) { if (iTotalItemCount <= lst.Count()) TotalItemCount = iTotalItemCount; else TotalItemCount = lst.Count(); } return lst.Take(TotalItemCount).ToList(); } }
public static List<Article> GetActiveListByFixedRecords(int iTotalItemCount) { using (ArticleEntities dbContext = new ArticleLibrary.ArticleEntities()) { if (dbContext.Connection.State != ConnectionState.Closed) dbContext.Connection.Open(); List<Article> lst = (from x in dbContext.Articles where x.Status == "2" orderby x.ArticleId descending select x).ToList(); int TotalItemCount = 0; if (lst.Count() > 0) { if (iTotalItemCount <= lst.Count()) TotalItemCount = iTotalItemCount; else TotalItemCount = lst.Count(); } return lst.Take(TotalItemCount).ToList(); } }