public List <LatestNewsModel> Popular_filler()
{
///////popular news
List <LatestNewsModel> Popular = new List <LatestNewsModel>();
DataTable popular_dt =
db.Select(
"SELECT top 5 [Post_tbl].Id,[Categories_tbl].name,[Post_tbl].[Title],[Post_tbl].[Date],[Post_tbl].[ImagePath],[Post_tbl].[ImageValue] FROM[Post_tbl] INNER JOIN [Categories_tbl] ON [Post_tbl].Id=[Categories_tbl].PostId order by(SELECT count(*) FROM [Comment_tbl]WHERE PostId=[Post_tbl].[Id]) DESC,Date DESC");
for (int i = 0; i < popular_dt.Rows.Count; i++)
{
DateTime date = dateTimeStamp.GetDateTime_fromUnix(popular_dt.Rows[i]["Date"].ToString());
PersianDateTime persianDateTime = new PersianDateTime(date);
var Late = new LatestNewsModel()
{
Id = Convert.ToInt32(popular_dt.Rows[i]["Id"]),
title = popular_dt.Rows[i]["Title"].ToString(),
date = persianDateTime.ToString(),
ImagePath = popular_dt.Rows[i]["ImagePath"].ToString(),
Category = popular_dt.Rows[i]["name"].ToString()
};
Popular.Add(Late);
}
//////// popular end
return(Popular);
}
public List <LatestNewsModel> Search_filler(string s_text)
{
///////Search news
List <LatestNewsModel> search = new List <LatestNewsModel>();
DataTable search_dt =
db.Select(
"SELECT top 6 [Post_tbl].Id,[Categories_tbl].name,[Post_tbl].[Title],[Post_tbl].[Date],[Post_tbl].[ImagePath],[Post_tbl].[ImageValue] FROM[Post_tbl] INNER JOIN [Categories_tbl] ON [Post_tbl].Id=[Categories_tbl].PostId WHERE [Post_tbl].Title like N'%" + s_text + "%' OR [Post_tbl].Text like N'%" + s_text + "%' order by([Post_tbl].weight) DESC,Date DESC");
for (int i = 0; i < search_dt.Rows.Count; i++)
{
DateTime date = dateTimeStamp.GetDateTime_fromUnix(search_dt.Rows[i]["Date"].ToString());
PersianDateTime persianDateTime = new PersianDateTime(date);
var S = new LatestNewsModel()
{
Id = Convert.ToInt32(search_dt.Rows[i]["Id"]),
title = search_dt.Rows[i]["Title"].ToString(),
date = persianDateTime.ToString(),
ImagePath = search_dt.Rows[i]["ImagePath"].ToString(),
Category = search_dt.Rows[i]["name"].ToString()
};
search.Add(S);
}
//////// Search end
return(search);
}
public List <LatestNewsModel> LatestNewsModels_filler()
{
///////latest news
List <LatestNewsModel> latest = new List <LatestNewsModel>();
DataTable latest_dt =
db.Select(
"SELECT top 5 [Post_tbl].Id,[Categories_tbl].name,[Post_tbl].[Title],[Post_tbl].[Date],[Post_tbl].[ImagePath],[Post_tbl].[ImageValue] FROM[Post_tbl] INNER JOIN [Categories_tbl] ON [Post_tbl].Id=[Categories_tbl].PostId order by([Post_tbl].Date)DESC");
for (int i = 0; i < latest_dt.Rows.Count; i++)
{
DateTime date = dateTimeStamp.GetDateTime_fromUnix(latest_dt.Rows[i]["Date"].ToString());
PersianDateTime persianDateTime = new PersianDateTime(date);
var Late = new LatestNewsModel()
{
Id = Convert.ToInt32(latest_dt.Rows[i]["Id"]),
title = latest_dt.Rows[i]["Title"].ToString(),
date = persianDateTime.ToString(),
ImagePath = latest_dt.Rows[i]["ImagePath"].ToString(),
Category = latest_dt.Rows[i]["name"].ToString()
};
latest.Add(Late);
}
//////// latest end
return(latest);
}
