/// <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 static BlogPostCollection GetAllBlogPosts(int LanguageID) { DBBlogPostCollection dbCollection = DBProviderManager <DBBlogProvider> .Provider.GetAllBlogPosts(LanguageID); BlogPostCollection collection = DBMapping(dbCollection); return(collection); }
private static BlogPostCollection DBMapping(DBBlogPostCollection dbCollection) { if (dbCollection == null) return null; BlogPostCollection collection = new BlogPostCollection(); foreach (DBBlogPost dbItem in dbCollection) { BlogPost item = DBMapping(dbItem); collection.Add(item); } return collection; }
private static BlogPostCollection DBMapping(DBBlogPostCollection dbCollection) { if (dbCollection == null) { return(null); } var collection = new BlogPostCollection(); foreach (var dbItem in dbCollection) { var item = DBMapping(dbItem); collection.Add(item); } return(collection); }
/// <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; }