/// <summary>
/// Gets all blog posts
/// </summary>
/// <param name="LanguageID">Language identifier. 0 if you want to get all news</param>
/// <returns>Blog posts</returns>
public override DBBlogPostCollection GetAllBlogPosts(int LanguageID)
{
DBBlogPostCollection blogPostCollection = new DBBlogPostCollection();
Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString);
DbCommand dbCommand = db.GetStoredProcCommand("Nop_BlogPostLoadAll");
db.AddInParameter(dbCommand, "LanguageID", DbType.Int32, LanguageID);
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
while (dataReader.Read())
{
DBBlogPost blogPost = GetBlogPostFromReader(dataReader);
blogPostCollection.Add(blogPost);
}
}
return(blogPostCollection);
}
/// <summary>
/// Gets all blog posts
/// </summary>
/// <param name="languageId">Language identifier. 0 if you want to get all news</param>
/// <param name="pageSize">Page size</param>
/// <param name="pageIndex">Page index</param>
/// <param name="totalRecords">Total records</param>
/// <returns>Blog posts</returns>
public override DBBlogPostCollection GetAllBlogPosts(int languageId, int pageSize,
int pageIndex, out int totalRecords)
{
totalRecords = 0;
var result = new DBBlogPostCollection();
Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString);
DbCommand dbCommand = db.GetStoredProcCommand("Nop_BlogPostLoadAll");
db.AddInParameter(dbCommand, "LanguageID", DbType.Int32, languageId);
db.AddInParameter(dbCommand, "PageSize", DbType.Int32, pageSize);
db.AddInParameter(dbCommand, "PageIndex", DbType.Int32, pageIndex);
db.AddOutParameter(dbCommand, "TotalRecords", DbType.Int32, 0);
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
while (dataReader.Read())
{
var item = GetBlogPostFromReader(dataReader);
result.Add(item);
}
}
totalRecords = Convert.ToInt32(db.GetParameterValue(dbCommand, "@TotalRecords"));
return(result);
}
/// <summary>
/// Gets all blog posts
/// </summary>
/// <param name="LanguageID">Language identifier. 0 if you want to get all news</param>
/// <returns>Blog posts</returns>
public override DBBlogPostCollection GetAllBlogPosts(int LanguageID)
{
DBBlogPostCollection blogPostCollection = new DBBlogPostCollection();
Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString);
DbCommand dbCommand = db.GetStoredProcCommand("Nop_BlogPostLoadAll");
db.AddInParameter(dbCommand, "LanguageID", DbType.Int32, LanguageID);
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
while (dataReader.Read())
{
DBBlogPost blogPost = GetBlogPostFromReader(dataReader);
blogPostCollection.Add(blogPost);
}
}
return blogPostCollection;
}