public static void DeleteReview(RestaurantModels.Review review)
{
var rev = db.Reviews.ToList();
db.Reviews.Remove(rev.Find(x => x.ID.Equals(review.ID)));
db.SaveChanges();
}
public static void AddNewReview(RestaurantModels.Review review)
{
//using (RReviewsEntities db = new RReviewsEntities())
{
db.Reviews.Add(LibraryToData(review));
db.SaveChanges();
}
}
public static RestaurantModels.Review DataToLibraryReview(Review dataModel)
{
var libModel = new RestaurantModels.Review()
{
ReviewRating = dataModel.ReviewerRating,
ReviewComment = dataModel.ReviewerComment,
ReviewerName = dataModel.ReviewerName,
RestaurantID = dataModel.RestaurantID
};
return(libModel);
}
public static Review LibraryToData(RestaurantModels.Review libModel)
{
var dataModel = new Review()
{
ReviewerName = libModel.ReviewerName,
ReviewerComment = libModel.ReviewComment,
ReviewerRating = libModel.ReviewRating,
RestaurantID = libModel.RestaurantID,
DateSubmitted = libModel.DateSubmitted
};
return(dataModel);
}
public static void EditReview(int id, RestaurantModels.Review review)
{
var rev = db.Reviews.ToList();
var select = rev.Find(x => x.ID.Equals(id));
if (review.ReviewerName != null && review.ReviewerName != "")
{
select.ReviewerName = review.ReviewerName;
}
if (review.ReviewerName != null && review.ReviewComment != "")
{
select.ReviewerComment = review.ReviewComment;
}
select.ReviewerRating = review.ReviewRating;
db.SaveChanges();
}
public static void AddNewReview(RestaurantModels.Review review)
{
RestaurantAccessData.AddNewReview(review);
}
public static void DeleteReview(RestaurantModels.Review review)
{
RestaurantAccessData.DeleteReview(review);
}
public static void EditReview(int id, RestaurantModels.Review review)
{
RestaurantAccessData.EditReview(id, review);
}
