private BeerReview MapRowToBeerReview(SqlDataReader reader) { //try //{ var dt = Convert.ToString(reader["review_date"]); var reviewDate = DateTime.ParseExact(dt, "yyyy-MM-dd HH:mm:ss.fff", CultureInfo.InvariantCulture); var br = new BeerReview { BeerReviewId = Convert.ToInt32(reader["review_id"]), UserReviewing = MapRowToUser(reader), BeerReviewed = MapRowToBeer(reader), ReviewText = Convert.ToString(reader["review_text"]), DateOfReview = reviewDate }; br.SetRaiting(Convert.ToDouble(reader["review_rating"])); return(br); //} //catch //{ //return new BeerReview(); //} }
public IActionResult SaveBeerReview(BeerViewModel response) { var beerReviewed = BeerDAL.GetBeer(response.CurrentBeerId); var userReviewing = AuthProvider.GetCurrentUser(); var userReviewId = response.UserReviewId; var reviewText = response.UserReviewText; var reviewRating = response.UserRating; BeerReview beerReview = new BeerReview { BeerReviewed = beerReviewed, UserReviewing = userReviewing, DateOfReview = DateTime.Now, BeerReviewId = userReviewId, ReviewText = reviewText, }; beerReview.SetRaiting(response.UserRating); if (!string.IsNullOrEmpty(reviewText) && reviewRating > 0) { BeerReviewDAL.CreateOrUpdateReview(beerReview); } return(RedirectToAction("BeerDetail", new { id = beerReviewed.BeerId })); }
private BeerReview RowToBeerReview(SqlDataReader reader) { try { var br = new BeerReview { BeerReviewId = Convert.ToInt32(reader["review_id"]), ReviewText = Convert.ToString(reader["review_text"]), DateOfReview = Convert.ToDateTime("review_date"), UserReviewing = RowToUser(reader) }; br.SetRaiting(Convert.ToDouble(reader["review_rating"])); return(br); } catch { return(new BeerReview()); } }