//Delete a review public static void DeleteReview(int id) { var db = new RestaurantDBEntities1(); RestaurantReviews.Data.Review dlRev = db.Reviews.Find(id); db.Reviews.Remove(dlRev); db.SaveChanges(); }
//Update a review public static void UpdateReview(Reviews rev) { var db = new RestaurantDBEntities1(); RestaurantReviews.Data.Review dbRev = db.Reviews.Find(rev.RestaurantId); dbRev.Comment = rev.Comment; dbRev.Rating = rev.Rating; dbRev.Reviewer = rev.Reviewer; db.SaveChanges(); }
public static Reviews ImportReview(RestaurantReviews.Data.Review dlRev) { int revId = dlRev.RestaurantId; var libRev = new Reviews() { RestaurantId = dlRev.RestaurantId, Reviewer = dlRev.Reviewer, Comment = dlRev.Comment, Rating = dlRev.Rating }; return(libRev); }
//Create a review public static void AddReviewToDb(Reviews rev) { var db = new RestaurantDBEntities1(); RestaurantReviews.Data.Review dbRev = new RestaurantReviews.Data.Review(); dbRev.Reviewer = rev.Reviewer; dbRev.RestaurantId = rev.RestaurantId; dbRev.Reviewer_Id = rev.ReviewId; dbRev.Comment = rev.Comment; dbRev.Rating = rev.Rating; db.Reviews.Add(dbRev); db.SaveChanges(); }