public void Update(string review, int stars)
{
int targetId = this.GetId();
SqlConnection conn = DB.Connection();
conn.Open();
SqlCommand cmd = new SqlCommand("UPDATE reviews SET review = @Review, stars = @Stars WHERE id = @TargetId", conn);
cmd.Parameters.Add(new SqlParameter("@Review", review));
cmd.Parameters.Add(new SqlParameter("@Stars", stars));
cmd.Parameters.Add(new SqlParameter("@TargetId", targetId));
cmd.ExecuteNonQuery();
Review updatedReview = Find(targetId);
this._review = updatedReview.GetReview();
this._stars = updatedReview.GetStars();
if (conn != null)
{
conn.Close();
}
}
public override bool Equals(System.Object otherReview)
{
if (!(otherReview is Review))
{
return(false);
}
else
{
Review newReview = (Review)otherReview;;
bool idEquality = this.GetId() == newReview.GetId();
bool reviewEquality = this.GetReview() == newReview.GetReview();
bool starsEquality = this.GetStars() == newReview.GetStars();
bool restaurantIdEquality = this.GetRestaurantId() == newReview.GetRestaurantId();
return(idEquality && reviewEquality && starsEquality && restaurantIdEquality);
}
}
public void Test_Review_Update_ChangeReviewInfo()
{
// Arrange
Restaurant testRestaurant = new Restaurant("Pizza Factory", "5th Street", "530-816-9999", 0);
testRestaurant.Save();
Review testReview = new Review("Their pizza was marvelous", 4, testRestaurant.GetId());
testReview.Save();
Review testReview1 = new Review("First time was great, second time their pizza was bland", 2, testRestaurant.GetId());
testReview1.Save();
// Act
testReview.Update("First time was great, second time their pizza was bland", 2);
// testReview.SetId(testRestaurant.GetId());
// testReview1.SetId(testRestaurant.GetId());
// Assert
Assert.Equal(testReview.GetReview(), testReview1.GetReview());
}