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