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