public IEnumerable<BOC.Entities.News> GetNewsByHeadLine(NewsTypeQry newsTypeQry)
{
var select = _BOCWebDBContext.News.Where(e => e.IsTopNews == true && e.IsPushOut == true);
if (!string.IsNullOrEmpty(newsTypeQry.languagecode))
{
select = select.Where(e => e.NewsLanguageCode == newsTypeQry.languagecode);
}
if (!string.IsNullOrEmpty(newsTypeQry.country))
{
select = select.Where(e => e.Countury == newsTypeQry.country);
}
if (!string.IsNullOrEmpty(newsTypeQry.keyword))
{
select = select.Where(e => e.NewsTitle.Contains(newsTypeQry.keyword) || e.KeyWords.Contains(newsTypeQry.keyword) || e.NewsSummary.Contains(newsTypeQry.keyword));
}
var lNews = select.OrderByDescending(e => e.NewsDateTime).ThenByDescending(e => e.NewsID).Skip((newsTypeQry.page - 1) * newsTypeQry.pagesize).Take(newsTypeQry.pagesize).ToList();
//var lNews = _BOCWebDBContext.News.Where(e => e.IsTopNews == true && e.NewsLanguageCode == newsTypeQry.languagecode).OrderBy(e => e.NewsDateTime).Skip(newsTypeQry.page * newsTypeQry.pagesize).Take(newsTypeQry.pagesize);
return lNews;
}
public int GetNewsCountByType(NewsTypeQry newsTypeQry)
{
var select = _BOCWebDBContext.News.Where(e => e.IsPushOut == true);
if (!string.IsNullOrEmpty(newsTypeQry.languagecode))
{
select = select.Where(e => e.NewsLanguageCode == newsTypeQry.languagecode);
}
if (!string.IsNullOrEmpty(newsTypeQry.type))
{
select = select.Where(e => e.Type == newsTypeQry.type);
}
if (!string.IsNullOrEmpty(newsTypeQry.country))
{
select = select.Where(e => e.Countury == newsTypeQry.country);
}
if (!string.IsNullOrEmpty(newsTypeQry.keyword))
{
select = select.Where(e => e.NewsTitle.Contains(newsTypeQry.keyword) || e.KeyWords.Contains(newsTypeQry.keyword) || e.NewsSummary.Contains(newsTypeQry.keyword));
}
int count = select.Count();
return count;
}