private static ProductReviewCollection DBMapping(DBProductReviewCollection dbCollection) { if (dbCollection == null) return null; ProductReviewCollection collection = new ProductReviewCollection(); foreach (DBProductReview dbItem in dbCollection) { ProductReview item = DBMapping(dbItem); collection.Add(item); } return collection; }
/// <summary> /// Gets all product reviews /// </summary> /// <returns>Product review collection</returns> public override DBProductReviewCollection GetAllProductReviews(bool showHidden) { DBProductReviewCollection productReviewCollection = new DBProductReviewCollection(); Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString); DbCommand dbCommand = db.GetStoredProcCommand("Nop_ProductReviewLoadAll"); db.AddInParameter(dbCommand, "ShowHidden", DbType.Boolean, showHidden); using (IDataReader dataReader = db.ExecuteReader(dbCommand)) { while (dataReader.Read()) { DBProductReview productReview = GetProductReviewFromReader(dataReader); productReviewCollection.Add(productReview); } } return productReviewCollection; }