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; }
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; }