public ReviewData Add(ReviewData review) { review.createdDate = DateTime.UtcNow; review.lastModified = DateTime.UtcNow; //review = CopyFromReviewableToNew(review); //ReviewData newR = CopyFromModelToData(review); Guid newId = Guid.NewGuid(); review.id = newId; _reviewRepository.Collection.Insert(review); _rr.UpdateStatistics(review.parentReviewableId); return Get(newId); }
private Review PopulateData(ReviewData reviewData) { //retreive the matching parent reviewableData ReviewableData reviewableData = _reviewableRepository.Get(reviewData.parentReviewableId, Guid.Empty); //populate parent reviewable data //Review review = AutoMapper.Mapper.Map<ReviewableData, Review>(reviewableData); //populate review data //review = AutoMapper.Mapper.Map<ReviewData, Review>(reviewData); Review review = AutoMapper.Mapper.Map<ReviewData, Review>(reviewData); AutoMapper.Mapper.Map(reviewableData, review, typeof(ReviewableData), typeof(Review)); //populate images from parent reviewable //review = CopyImagesFromDomainToUI(reviewableData, review); return review; }
protected void Button4_Click(object sender, EventArgs e) { SqlConnection conn = null; SqlDataReader dr = null; try { ReviewRepository pr = new ReviewRepository(); ReviewableRepository rr = new ReviewableRepository(); UserRepository ur = new UserRepository(); conn = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["DataServices"].ConnectionString); conn.Open(); SqlCommand cmd = new SqlCommand("SELECT * from vCurrentProductReviews", conn); dr = cmd.ExecuteReader(); while (dr.Read()) { ReviewData prod = new ReviewData(); //prod.name = dr.GetString(4); //if (dr.GetValue(5) != DBNull.Value) // prod.description = dr.GetString(5); if (dr.GetValue(6) != DBNull.Value) prod.createdDate = dr.GetDateTime(6); if (dr.GetValue(7) != DBNull.Value) prod.lastModified = dr.GetDateTime(7); if (dr.GetValue(8) != DBNull.Value) prod.text = dr.GetString(8); if (dr.GetValue(9) != DBNull.Value) prod.rating = dr.GetDouble(9); if (dr.GetValue(10) != DBNull.Value) { prod.userName = dr.GetString(10); prod.user = ur.GetByName(prod.userName).id; } if (dr.GetValue(14) != DBNull.Value) prod.fBFeedPostId = dr.GetString(14); if (dr.GetValue(15) != DBNull.Value) prod.fBTimelinePostId = dr.GetString(15); if (dr.GetValue(4) != DBNull.Value) { ReviewableData x = rr.GetByName(dr.GetString(4), Guid.Empty).First(); prod.parentReviewableId = x.id; prod.parentName = x.name; //prod.outsideCode = x.outsideCode; //prod.outsideCodeType = x.outsideCodeType; //prod.issuerCountryCode = x.issuerCountryCode; //prod.issuerCountry = x.issuerCountry; //prod.providedByBizId = x.parentReviewableId; //prod.providedByBizName = x.parentName; } prod.reviewableType = "product"; pr.Add(prod); } dr.Close(); } finally { if (conn != null) { conn.Close(); } } }
public ReviewData Update(ReviewData review) { //Guid newId = Guid.GenerateNewId(); //review.lastModified = DateTime.UtcNow; //ReviewData newR = this.CopyFromModelToData(review); _reviewRepository.Collection.Save(review); _rr.UpdateStatistics(review.parentReviewableId); _rsr.Recalculate(); return Get(review.id); }