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