public ReviewInformation GetReviewDetails(int reviewID)
{
try
{
TblTableReview reviewDetail = new TblTableReview();
reviewDetail = review_Repository.GetReviewDetails(reviewID);
ReviewInformation review_Information = new ReviewInformation
{
ReviewId = reviewDetail.Id,
RestaurantId = reviewDetail.TblRestaurantId,
Comments = reviewDetail.Comments,
CreatedBy = reviewDetail.CreatedBy,
RatingId = reviewDetail.TblRatingId,
UpdatedBy = reviewDetail.UpdatedBy,
CreatedDateTime = reviewDetail.CreatedDateTime,
UpdatedDateTime = reviewDetail.UpdatedDateTime,
UserId = reviewDetail.TblUserId
};
return(review_Information);
}
catch (Exception ex)
{
throw ex;
}
}
public TblTableReview GetReviewDetails(int reviewID)
{
TblTableReview rreviewInformation = new TblTableReview();
try
{
if (db != null)
{
rreviewInformation = (from review in db.TblTableReview
where review.Id == reviewID
select new TblTableReview
{
Id = review.Id,
Comments = review.Comments,
CreatedBy = review.CreatedBy,
CreatedDateTime = review.CreatedDateTime,
TblRatingId = review.TblRatingId,
TblRestaurantId = review.TblRestaurantId,
TblUserId = review.TblUserId,
UpdatedBy = review.UpdatedBy,
UpdatedDateTime = review.UpdatedDateTime
}).FirstOrDefault();
}
return(rreviewInformation);
}
catch (Exception ex)
{
throw (ex);
}
}
public bool PostYourReview(TblTableReview tblTableReview)
{
if (tblTableReview != null)
{
db.Add(tblTableReview);
db.SaveChanges();
return(true);
}
return(false);
}
public bool UpdateYourReview(TblTableReview tblTableReview)
{
TblTableReview tblTableReviewEntity = db.Set <TblTableReview>().Where(tto => tto.Id == tblTableReview.Id).FirstOrDefault();
if (tblTableReviewEntity != null)
{
tblTableReviewEntity = tblTableReview;
tblTableReview.UpdatedDateTime = DateTime.Now;
db.SaveChanges();
return(true);
}
return(false);
}
public bool UpdateReviewDetails(ReviewInformation updatedReview)
{
TblTableReview tblTableReview;
if (updatedReview != null)
{
tblTableReview = new TblTableReview();
tblTableReview.Id = updatedReview.ReviewId;
tblTableReview.TblUserId = updatedReview.UserId;
tblTableReview.CreatedBy = updatedReview.CreatedBy;
tblTableReview.CreatedDateTime = updatedReview.CreatedDateTime;
tblTableReview.TblRestaurantId = updatedReview.RestaurantId;
tblTableReview.TblRatingId = updatedReview.RatingId;
tblTableReview.Comments = updatedReview.Comments;
tblTableReview.UpdatedDateTime = DateTime.Now;
return(review_Repository.UpdateYourReview(tblTableReview));
}
return(false);
}
public void Test_PostYourReview()
{
TblTableReview reviewDetails = new TblTableReview()
{
Id = 2,
TblRatingId = 1,
Comments = "Bad Experience",
CreatedBy = "Madhusmita M",
CreatedDateTime = DateTime.Now,
UpdatedBy = null,
UpdatedDateTime = DateTime.Now,
TblRestaurantId = 1,
TblUserId = 1
};
var options = new DbContextOptionsBuilder <ReviewManagementContext>()
.UseInMemoryDatabase(databaseName: "ReviewManagement")
.Options;
ReviewRepository repo = new ReviewRepository(new ReviewManagementContext(options));
var review = repo.PostYourReview(reviewDetails);
Assert.IsTrue(review);
}
