Ejemplo n.º 1
0
 private DBProductReview GetProductReviewFromReader(IDataReader dataReader)
 {
     DBProductReview productReview = new DBProductReview();
     productReview.ProductReviewID = NopSqlDataHelper.GetInt(dataReader, "ProductReviewID");
     productReview.ProductID = NopSqlDataHelper.GetInt(dataReader, "ProductID");
     productReview.CustomerID = NopSqlDataHelper.GetInt(dataReader, "CustomerID");
     productReview.Title = NopSqlDataHelper.GetString(dataReader, "Title");
     productReview.ReviewText = NopSqlDataHelper.GetString(dataReader, "ReviewText");
     productReview.Rating = NopSqlDataHelper.GetInt(dataReader, "Rating");
     productReview.HelpfulYesTotal = NopSqlDataHelper.GetInt(dataReader, "HelpfulYesTotal");
     productReview.HelpfulNoTotal = NopSqlDataHelper.GetInt(dataReader, "HelpfulNoTotal");
     productReview.IsApproved = NopSqlDataHelper.GetBoolean(dataReader, "IsApproved");
     productReview.CreatedOn = NopSqlDataHelper.GetUtcDateTime(dataReader, "CreatedOn");
     return productReview;
 }
Ejemplo n.º 2
0
        private static ProductReview DBMapping(DBProductReview dbItem)
        {
            if (dbItem == null)
                return null;

            ProductReview item = new ProductReview();
            item.ProductReviewID = dbItem.ProductReviewID;
            item.ProductID = dbItem.ProductID;
            item.CustomerID = dbItem.CustomerID;
            item.Title = dbItem.Title;
            item.ReviewText = dbItem.ReviewText;
            item.Rating = dbItem.Rating;
            item.HelpfulYesTotal = dbItem.HelpfulYesTotal;
            item.HelpfulNoTotal = dbItem.HelpfulNoTotal;
            item.IsApproved = dbItem.IsApproved;
            item.CreatedOn = dbItem.CreatedOn;

            return item;
        }