protected void CountArticlesByCategory(int id)
{
ArticlesByCategoryCountVM abccObj = new ArticlesByCategoryCountVM();
abccObj = postSvc.CountArticlesByCategory(id);
lblNumber.Text = abccObj.NumOfArticles.ToString();
lblCategory.Text = abccObj.CategoryName;
}
public ArticlesByCategoryCountVM CountArticlesByCategory(int id)
{
string query = "SELECT COUNT(post_category.PostID) AS NumOfArticles, category.CategoryName " +
"FROM category " +
"INNER JOIN post_category ON category.ID = post_category.CategoryID " +
"INNER JOIN post ON post_category.PostID = post.ID " +
"WHERE category.ID = @CategoryID ";
MySqlConnection connection = null;
ArticlesByCategoryCountVM abccObj = new ArticlesByCategoryCountVM();
var parameters = new List <MySqlParameter>();
parameters.Add(dbManager.CreateParameter("@CategoryID", id, DbType.Int32));
var dataReader = dbManager.GetDataReader(query, CommandType.Text, parameters.ToArray(), out connection);
try
{
while (dataReader.Read())
{
abccObj.NumOfArticles = Convert.ToInt32(dataReader["NumOfArticles"]);
abccObj.CategoryName = dataReader["CategoryName"].ToString();
}
return(abccObj);
}
catch (Exception ex)
{
throw ex;
}
finally
{
dataReader.Close();
dbManager.CloseConnection(connection);
}
}
