public JsonNews NewsList()
{
JsonNews jsonNews = new JsonNews();
NewsViewModel linknewsobj = new NewsViewModel();
List <NewsViewModel> linklistobj = new List <NewsViewModel>();
try
{
var ListNews = _link.LinkType();
foreach (var item in ListNews)
{
linknewsobj.LinkId = item.Id;
linknewsobj.Title = item.Title;
linknewsobj.Icon = item.Icon;
linklistobj.Add(linknewsobj);
}
jsonNews.Result = linklistobj;
return(jsonNews);
}
catch (Exception ex)
{
string mes = ex.Message;
return(jsonNews);
}
}
public JsonResult NewsPublished()
{
List <NewsEntity.Models.Article> theList = (List <NewsEntity.Models.Article>)NewsEntity.Models.Article.GetPublished();
List <JsonNews> theResult = new List <JsonNews>();
foreach (var item in theList)
{
JsonNews jsonObj = new JsonNews(item);
theResult.Add(jsonObj);
}
return(Json(theResult, JsonRequestBehavior.AllowGet));
}
public ActionResult GetNextNews(string nextRow)
{
Sql sql = null;
if (nextRow.IsBlank())
{
sql = new Sql("select top 3 * from news");
}
else
{
sql = new Sql("select top 1 * from news");
}
sql.Add(" where 1 = 1 ");
int?id = nextRow.ToInt(null);
if (id.HasValue)
{
sql.Add(" and newsID < ", id.Value.SqlizeNumber());
}
//
sql.Add(" order by newsID desc");
//sql.Add(" order by datedded desc");
NewsList newsList = NewsList.Load(sql);
List <JsonNews> jsonNews = new List <JsonNews>();
foreach (var news in newsList)
{
JsonNews jnews = new JsonNews();
jnews.NewsID = news.ID;
jnews.Title = news.Title;
jnews.Body = news.BodyTextHtml;
jnews.Date = news.DateAdded.FmtDate();
jsonNews.Add(jnews);
}
return(Json(jsonNews, JsonRequestBehavior.AllowGet));
}
