public static Rating Create(this RestaurantsEntities DB, Rating rating)
{
Rating newRating = DB.Ratings.Add(rating);
DB.UpdateRating(newRating.Restaurant_Id);
DB.SaveChanges();
return(newRating);
}
public static void DeleteRating(this RestaurantsEntities DB, int ratingId)
{
Rating ratingToDelete = DB.Ratings.Find(ratingId);
if (ratingToDelete != null)
{
int restaurantToUpdateId = ratingToDelete.Restaurant_Id;
DB.Ratings.Remove(ratingToDelete);
DB.UpdateRating(restaurantToUpdateId);
DB.SaveChanges();
}
}
public static Rating Update(this RestaurantsEntities DB, Rating rating)
{
if (rating != null)
{
Rating ratingToUpdate = DB.Ratings.Find(rating.Id);
if (ratingToUpdate != null)
{
ratingToUpdate.Update(rating);
DB.Entry(ratingToUpdate).State = System.Data.Entity.EntityState.Modified;
DB.UpdateRating(ratingToUpdate.Restaurant_Id);
DB.SaveChanges();
return(ratingToUpdate);
}
}
return(null);
}