/// <summary> /// Gets news item collection /// </summary> /// <param name="LanguageID">Language identifier. 0 if you want to get all news</param> /// <param name="NewsCount">News item count. 0 if you want to get all news</param> /// <param name="showHidden">A value indicating whether to show hidden records</param> /// <returns>News item collection</returns> public override DBNewsCollection GetNews(int LanguageID, int NewsCount, bool showHidden) { DBNewsCollection newsCollection = new DBNewsCollection(); Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString); DbCommand dbCommand = db.GetStoredProcCommand("Nop_NewsLoadAll"); db.AddInParameter(dbCommand, "LanguageID", DbType.Int32, LanguageID); db.AddInParameter(dbCommand, "NewsCount", DbType.Int32, NewsCount); db.AddInParameter(dbCommand, "ShowHidden", DbType.Boolean, showHidden); using (IDataReader dataReader = db.ExecuteReader(dbCommand)) { while (dataReader.Read()) { DBNews news = GetNewsFromReader(dataReader); newsCollection.Add(news); } } return(newsCollection); }
/// <summary> /// Gets news item collection /// </summary> /// <param name="languageId">Language identifier. 0 if you want to get all news</param> /// <param name="showHidden">A value indicating whether to show hidden records</param> /// <param name="pageSize">Page size</param> /// <param name="pageIndex">Page index</param> /// <param name="totalRecords">Total records</param> /// <returns>News item collection</returns> public override DBNewsCollection GetAllNews(int languageId, bool showHidden, int pageIndex, int pageSize, out int totalRecords) { var result = new DBNewsCollection(); Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString); DbCommand dbCommand = db.GetStoredProcCommand("Nop_NewsLoadAll"); db.AddInParameter(dbCommand, "LanguageID", DbType.Int32, languageId); db.AddInParameter(dbCommand, "ShowHidden", DbType.Boolean, showHidden); db.AddInParameter(dbCommand, "PageIndex", DbType.Int32, pageIndex); db.AddInParameter(dbCommand, "PageSize", DbType.Int32, pageSize); db.AddOutParameter(dbCommand, "TotalRecords", DbType.Int32, 0); using (IDataReader dataReader = db.ExecuteReader(dbCommand)) { while (dataReader.Read()) { result.Add(GetNewsFromReader(dataReader)); } } totalRecords = Convert.ToInt32(db.GetParameterValue(dbCommand, "@TotalRecords")); return(result); }