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