public List <ListArticleViewModel> GetSearchResult(string search_key, int page, int page_size, int image_width, int image_height, int description_length = 40)
{
//clear search query
search_key = ClearSearchQuery(search_key);
List <ListArticleViewModel> result = new List <ListArticleViewModel>();
//IQueryable<Article> category_articles = DAManager.ArticlesRepository.Get(a => a.IsPublished == true && EntityFunctions.CreateDateTime(a.PublishDate.Year, a.PublishDate.Month, a.PublishDate.Day, a.PublishDate.Hour, a.PublishDate.Minute, a.PublishDate.Second) <= DateTime.Now && (a.Title.Contains(search_key)), a => a.OrderByDescending(ar => ar.PublishDate), "ArticleImages.Image,Likes,Comments").Skip((page-1) * page_size).Take(page_size);
List <SearchArticles_Result> category_articles = DAManager.ArticlesRepository.SearchArticles(search_key, page, page_size);
foreach (SearchArticles_Result AC in category_articles)
{
ListArticleViewModel article = new ListArticleViewModel()
{
Title = AC.Title, URL = AC.URL
};
article.Description = StringsUtility.StripHTML(AC.Description);
if (article.Description.Length > description_length)
{
article.Description = article.Description.Substring(0, description_length);
}
if (AC.ImageURL != "")
{
article.ImageURL = ImageService.GenerateImageFullPath(AC.ImageURL, image_width.ToString(), image_height.ToString());
}
result.Add(article);
}
return(result);
}
public List <ListArticleViewModel> GetCategoryArticles(int category_id, int page, int page_size, int image_width, int image_height, int description_length = 40)
{
List <ListArticleViewModel> result = new List <ListArticleViewModel>();
IQueryable <ArticleCategory> category_articles = DAManager.ArticleCategoriesRepository.Get(ac => ac.CategoryId == category_id && ac.Article.IsPublished == true && DbFunctions.CreateDateTime(ac.Article.PublishDate.Year, ac.Article.PublishDate.Month, ac.Article.PublishDate.Day, ac.Article.PublishDate.Hour, ac.Article.PublishDate.Minute, ac.Article.PublishDate.Second) <= DateTime.Now, a => a.OrderByDescending(ar => ar.Article.PublishDate), "Article.ArticleImages.Image,Article.Likes,Article.Comments").Skip(page * page_size).Take(page_size);
foreach (ArticleCategory AC in category_articles.ToList())
{
ListArticleViewModel article = new ListArticleViewModel()
{
CommentsCount = AC.Article.Comments.Count(), LikesCount = AC.Article.Likes.Count(), Title = AC.Article.Title, URL = AC.Article.URL
};
article.Description = StringsUtility.StripHTML(AC.Article.Description);
if (article.Description.Length > description_length)
{
article.Description = article.Description.Substring(0, description_length);
}
if (AC.Article.ArticleImages.Count() > 0)
{
article.ImageURL = ImageService.GenerateImageFullPath(AC.Article.ArticleImages.First().Image.URL, image_width.ToString(), image_height.ToString());
}
result.Add(article);
}
return(result);
}
public CategoryViewModel GetArticlesTag(string tag, int page, int page_size, int image_width, int image_height, int description_length = 40)
{
tag = tag.Replace("-", "_");
Tag db_tag = DAManager.TagsRepository.Get(t => t.TagName == tag).FirstOrDefault();
if (db_tag == null)
{
return(null);
}
CategoryViewModel result_viewmodel = new CategoryViewModel()
{
Name = db_tag.FrontTitle, MetaDescription = db_tag.MetaDescription, MetaTitle = db_tag.MetaTitle
};
List <ListArticleViewModel> result = new List <ListArticleViewModel>();
IQueryable <ArticleTag> tag_articles = DAManager.ArticleTagsRepository.Get(at => at.Tag == tag && at.Article.IsPublished == true && DbFunctions.CreateDateTime(at.Article.PublishDate.Year, at.Article.PublishDate.Month, at.Article.PublishDate.Day, at.Article.PublishDate.Hour, at.Article.PublishDate.Minute, at.Article.PublishDate.Second) <= DateTime.Now, a => a.OrderByDescending(ar => ar.Article.PublishDate), "Article.ArticleImages.Image,Article.Likes,Article.Comments").Skip((page - 1) * page_size).Take(page_size);
foreach (ArticleTag AC in tag_articles.ToList())
{
ListArticleViewModel article = new ListArticleViewModel()
{
CommentsCount = AC.Article.Comments.Count(), LikesCount = AC.Article.Likes.Count(), Title = AC.Article.Title, URL = AC.Article.URL
};
article.Description = StringsUtility.StripHTML(AC.Article.Description);
if (article.Description.Length > description_length)
{
article.Description = article.Description.Substring(0, description_length);
}
if (AC.Article.ArticleImages.Count() > 0)
{
article.ImageURL = ImageService.GenerateImageFullPath(AC.Article.ArticleImages.First().Image.URL, image_width.ToString(), image_height.ToString());
}
result.Add(article);
}
result_viewmodel.Articles = result;
int total_articles = DAManager.ArticleTagsRepository.Get(at => at.Tag == tag && at.Article.IsPublished == true && DbFunctions.CreateDateTime(at.Article.PublishDate.Year, at.Article.PublishDate.Month, at.Article.PublishDate.Day, at.Article.PublishDate.Hour, at.Article.PublishDate.Minute, at.Article.PublishDate.Second) <= DateTime.Now).Count();
//Set pagination properties
result_viewmodel.PageNumber = page;
result_viewmodel.PageSize = page_size;
result_viewmodel.TotalItems = total_articles;
return(result_viewmodel);
}
public List <ListArticleViewModel> GetArticlesPerFeatureCategories(int count, List <ListArticleViewModel> except, int image_width, int image_height, int description_size = 100)
{
List <ListArticleViewModel> final_result = new List <ListArticleViewModel>();
List <string> except_list = except.Select(a => a.URL).ToList();
List <Category> online_categories = DAManager.CategoriesRepository.Get(c => c.IsPublished == true && c.FeatureOrder != null).ToList();
IQueryable <ArticleCategory> AC = null;
foreach (Category c in online_categories)
{
if (AC == null)
{
AC = DAManager.ArticleCategoriesRepository.Get(a => !except_list.Contains(a.Article.URL) && a.Article.IsPublished == true && DbFunctions.CreateDateTime(a.Article.PublishDate.Year, a.Article.PublishDate.Month, a.Article.PublishDate.Day, a.Article.PublishDate.Hour, a.Article.PublishDate.Minute, a.Article.PublishDate.Second) <= DateTime.Now && a.CategoryId == c.CategoryId, a => a.OrderByDescending(ar => ar.Article.PublishDate), "Article,Article.ArticleImages.Image").Take(count).AsQueryable();
}
else
{
AC = AC.Union(DAManager.ArticleCategoriesRepository.Get(a => !except_list.Contains(a.Article.URL) && a.Article.IsPublished == true && DbFunctions.CreateDateTime(a.Article.PublishDate.Year, a.Article.PublishDate.Month, a.Article.PublishDate.Day, a.Article.PublishDate.Hour, a.Article.PublishDate.Minute, a.Article.PublishDate.Second) <= DateTime.Now && a.CategoryId == c.CategoryId, a => a.OrderByDescending(ar => ar.Article.PublishDate), "Article,Article.ArticleImages.Image").Take(count).AsQueryable());
}
}
foreach (ArticleCategory article_c in AC.ToList())
{
ListArticleViewModel item = new ListArticleViewModel()
{
CategoryId = article_c.CategoryId, URL = article_c.Article.URL, Title = article_c.Article.Title, PublishDate = article_c.Article.PublishDate
};
if (article_c.Article.ArticleImages.Count() > 0)
{
item.ImageURL = article_c.Article.ArticleImages.First().Image.URL;
}
item.Description = StringsUtility.StripHTML(article_c.Article.Description);
if (item.Description.Length > description_size)
{
item.Description = item.Description.Substring(0, description_size);
}
final_result.Add(item);
}
return(FormatImageURL(final_result.OrderByDescending(a => a.PublishDate).ToList(), image_width, image_height));
}
