public List <Articles> getallarticlenonaccept()
{
List <Articles> ListArticle = null;
using (DataTable table = DBHelper.ExecuteSelectCommand("sp_GetAllArticleNonAccept", CommandType.StoredProcedure))
{
if (table.Rows.Count > 0)
{
ListArticle = new List <Articles>();
foreach (DataRow row in table.Rows)
{
Articles Ac = new Articles();
Ac.UserName = row["UserName"].ToString();
Ac.ArticleId = Convert.ToInt32(row["Article_Id"]);
Ac.ArticleTitle = row["Article_Title"].ToString();
Ac.ArticleAccept = Convert.ToBoolean(row["Article_Accept"]);
ListArticle.Add(Ac);
}
}
}
return(ListArticle);
}
public List <Articles> gettopthreearticle()
{
List <Articles> ListArticle = null;
using (DataTable table = DBHelper.ExecuteSelectCommand("sp_GetTopThreeArticles", CommandType.StoredProcedure))
{
if (table.Rows.Count > 0)
{
ListArticle = new List <Articles>();
foreach (DataRow row in table.Rows)
{
Articles Ac = new Articles();
Ac.ArticleId = Convert.ToInt32(row["Article_Id"]);
Ac.ArticleTitle = row["Title"].ToString();
Ac.ArticleDatePublish = Convert.ToDateTime(row["Article_Date"]);
Ac.ArticlePhoto = row["Article_Photo"].ToString();
Ac.ArticleDetails = row["Details"].ToString();
ListArticle.Add(Ac);
}
}
}
return(ListArticle);
}