public void Post([FromBody] Review review) { _db.Review.Add(review); Destination destination = _db.Destination.FirstOrDefault(dest => dest.DestinationId == review.DestinationId); destination.Reviews.Add(review); destination.Rating = (destination.Reviews.Sum(dest => Convert.ToInt32(dest.Rating)) / destination.Reviews.Count); _db.Entry(destination).State = EntityState.Modified; _db.SaveChanges(); }
public void Put(int id, [FromBody] Review review, string user_name) { if (review.user_name.ToLower() == user_name.ToLower()) { review.ReviewId = id; _db.Entry(review).State = EntityState.Modified; _db.SaveChanges(); } }
public void Post([FromBody] Review review) { List <Review> reviews = _db.Reviews.Where(rev => rev.DestinationId == review.DestinationId).ToList(); double rating = review.Rating; int j = 1; foreach (Review rev in reviews) { rating += rev.Rating; j++; } Destination currentDestination = _db.Destinations.FirstOrDefault(dest => dest.DestinationId == review.DestinationId); currentDestination.Rating = rating / j; _db.Entry(currentDestination).State = EntityState.Modified; _db.Reviews.Add(review); _db.SaveChanges(); }
public void Put(string user, int id, [FromBody] Review review) { review.ReviewId = id; if (review.user_name == user) { _db.Entry(review).State = EntityState.Modified; _db.SaveChanges(); } }
public void Put(int id, [FromBody] Review review) { // if (UserName == "0"/*UserId*/) // Needs to be intigrated with ApplicationUser for Identity // { review.ReviewId = id; _db.Entry(review).State = EntityState.Modified; _db.SaveChanges(); //} }
public void Put(int id, [FromBody] Destination destination) { destination.Reviews = _db.Review.Where(review => review.DestinationId == id).ToList(); _db.Entry(destination).State = EntityState.Modified; _db.SaveChanges(); // destination.Rating = (destination.Reviews.Sum(dest => Convert.ToInt32(dest.Rating))/destination.Reviews.Count); // _db.Entry(destination).State = EntityState.Modified; // _db.SaveChanges(); }
public void Put(int id, [FromBody] Review review) { review.ReviewId = id; _db.Entry(review).State = EntityState.Modified; _db.SaveChanges(); var thisDestination = _db.Destinations .Include(destination => destination.Reviews) .FirstOrDefault(x => x.DestinationId == review.DestinationId); thisDestination.GetAvgRating(); _db.SaveChanges(); }
public void Put(int id, [FromBody] Review review) { review.ReviewId = id; _db.Entry(review).State = EntityState.Modified; _db.SaveChanges(); }
public void Put(int id, [FromBody] City city) { city.CityId = id; _db.Entry(city).State = EntityState.Modified; _db.SaveChanges(); }
public void Put(int id, [FromBody] Destination theDestination) { theDestination.DestinationId = id; _db.Entry(theDestination).State = EntityState.Modified; _db.SaveChanges(); }
public void Put(int id, [FromBody] Packlist packlist) { packlist.PacklistId = id; _db.Entry(packlist).State = EntityState.Modified; _db.SaveChanges(); }
public void Put(int id, [FromBody] Place place) { place.PlaceId = id; _db.Entry(place).State = EntityState.Modified; _db.SaveChanges(); }
public void Put(int id, [FromBody] Location location) { location.LocationId = id; _db.Entry(location).State = EntityState.Modified; _db.SaveChanges(); }