// [Authorize("{userName}")] public void Put(int id, [FromBody] Review review) { Console.WriteLine(review.UserName); review.ReviewId = id; _db.Entry(review).State = EntityState.Modified; _db.SaveChanges(); }
public void Post([FromBody] Review review) { _db.Reviews.Add(review); Place place = _db.Places.Where(x => x.PlaceId == review.PlaceId).Include(x => x.Reviews).FirstOrDefault(); // if (place.Reviews.Count() != 0) { double averageRating = place.Reviews.Sum(y => y.Rating); averageRating = (averageRating / place.Reviews.Count()); place.AverageRating = averageRating; } else { place.AverageRating = 0; } _db.Entry(place).State = EntityState.Modified; _db.SaveChanges(); }
public void Put(int id, [FromBody] Review review) { // if(review.UserName.ToLower() == username.ToLower()) // { review.ReviewId = id; _db.Entry(review).State = EntityState.Modified; _db.SaveChanges(); City city = _db.Cities.Find(review.CityId); double averageRating = _db.Cities.Where(entry => entry.CityName == city.CityName) .Include(entry => entry.Reviews).SelectMany(entry => entry.Reviews).Average(x => x.Rating); city.OverallRating = averageRating; _db.SaveChanges(); // } }
public void Put(int id, [FromBody] Place place) { place.PlaceId = id; if (_db.Reviews.Where(x => x.PlaceId == place.PlaceId).Count() != 0) { double averageRating = (_db.Reviews.Where(x => x.PlaceId == place.PlaceId).Sum(y => y.Rating)); averageRating = (averageRating / _db.Reviews.Where(x => x.PlaceId == place.PlaceId).Count()); place.AverageRating = averageRating; //System.Console.WriteLine(averageRating); } else { place.AverageRating = 0; } _db.Entry(place).State = EntityState.Modified; _db.SaveChanges(); }
public async Task <IActionResult> Put(int id, Location location) { if (id != location.LocationId) { return(BadRequest()); } _db.Entry(location).State = EntityState.Modified; try { await _db.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!LocationExists(id)) { return(NotFound()); } else { throw; } } return(NoContent()); }
public void Put(int id, [FromBody] Destination destination) { destination.DestinationId = id; _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(); }
[HttpPut("{id}")] // edits existing api entry 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(); }
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] Country country) { country.CountryId = id; _db.Entry(country).State = EntityState.Modified; _db.SaveChanges(); }