public List <RestaurantReview> GetResturantReviews(RestaurantReviewParams restaurantReviewParams)
{
List <RestaurantReview> ratings = new List <RestaurantReview>();
try
{
var ratingList = _connection.TblRating.Where(e => e.TblRestaurantId == restaurantReviewParams.RestaurantID).ToList();
foreach (var rating in ratingList)
{
RestaurantReview restaurantReview = new RestaurantReview()
{
Id = rating.Id,
Rating = (rating.Rating),
Comments = rating.Comments,
RestaurantId = rating.TblRestaurantId,
CustomerId = rating.TblCustomerId,
UserCreated = rating.UserCreated,
UserModified = rating.UserCreated,
};
ratings.Add(restaurantReview);
}
return(ratings);
}
catch (Exception ex)
{
return(ratings);
}
}
public Review Create(EditReviewViewModel editVm)
{
Review review = null;
if (editVm.GetType() == typeof(EditRestaurantReviewViewModel))
{
review = new RestaurantReview
{
Body = editVm.Body,
Rating = editVm.Rating,
ReviewerName = editVm.ReviewerName,
RestaurantId = editVm.HorecaId
};
}
else if (editVm.GetType() == typeof(EditCafeReviewViewModel))
{
review = new CafeReview
{
Body = editVm.Body,
Rating = editVm.Rating,
ReviewerName = editVm.ReviewerName,
CafeId = editVm.HorecaId
};
}
return(review);
}
public IHttpActionResult PostRestaurantReview(RestaurantReviewDTO restaurantReviewDTO)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
try
{
restaurantsService = new RestaurantsService(User.Identity.Name);
}
catch (UserNotFoundException)
{
return(null);
}
var config = new MapperConfiguration(cfg =>
{
cfg.CreateMap <RestaurantReviewDTO, RestaurantReview>();
});
IMapper iMapper = config.CreateMapper();
RestaurantReview restaurantReview = iMapper.Map <RestaurantReviewDTO, RestaurantReview>(restaurantReviewDTO);
restaurantsService.AddReview(restaurantReview);
return(CreatedAtRoute("DefaultApi", new { id = restaurantReview.RestaurantReviewId }, restaurantReviewDTO));
}
public ActionResult Create(int restaurantId)
{
RestaurantReview r = new RestaurantReview();
r.RestaurantId = restaurantId;
return(View(r));
}
private void ThrowIfInvalid(RestaurantReview model)
{
if (model == null)
{
throw new ArgumentNullException(ERROR_MODEL_NULL);
}
}
public async Task <ActionResult <RestaurantReview> > PostRestaurantReview(RestaurantReview restaurantReview)
{
_context.RestaurantReviews.Add(restaurantReview);
await _context.SaveChangesAsync();
return(CreatedAtAction("GetRestaurantReview", new { id = restaurantReview.Id }, restaurantReview));
}
public async Task <IActionResult> PutRestaurantReview(int id, RestaurantReview restaurantReview)
{
if (id != restaurantReview.Id)
{
return(BadRequest());
}
_context.Entry(restaurantReview).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!RestaurantReviewExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
public ActionResult DeleteConfirmed(int id)
{
RestaurantReview reviewViewModel = db.RestaurantReviews.Find(id);
db.RestaurantReviews.Remove(reviewViewModel);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult DeleteConfirmed(int id)
{
RestaurantReview restaurantReview = db.Reviews.Find(id);
db.Reviews.Remove(restaurantReview);
db.SaveChanges();
return(RedirectToAction("Index", new { restId = restaurantReview.Restaurant_RestaurantId }));
}
//
// GET: /Review/Create
public ActionResult Create(int restaurantId)
{
var model = new RestaurantReview();
model.RestaurantId = restaurantId;
return(View(model));
}
public ActionResult DeleteConfirmed(int id)
{
RestaurantReview review = _db.Reviews.Find(id);
_db.Reviews.Remove(review);
_db.SaveChanges();
return(RedirectToAction("Index", new { RestaurantId = (int)Session["RestaurantId"] }));
}
public async Task <RestaurantReview> AddAsync(RestaurantReview review)
{
_context.RestaurantReviews.Add(review);
await _context.SaveChangesAsync();
return(review);
}
public ActionResult Create(RestaurantReview review)
{
if (ModelState.IsValid)
{
_repo.AddReview(review);
return(RedirectToAction("Index", new { id = review.RestaurantId }));
}
return(View(review));
}
public ActionResult Edit(int id, RestaurantReview review)
{
if (ModelState.IsValid)
{
_repo.UpdateReview(review);
return(RedirectToAction("Index", new { id = review.RestaurantId }));
}
return(View(review));
}
protected override void Seed(OdeToFood.Models.OdeToFoodDb context)
{
// This method will be called after migrating to the latest version.
// You can use the DbSet<T>.AddOrUpdate() helper extension method
// to avoid creating duplicate seed data.
//context.Restaurants.AddOrUpdate(r => r.Name,
// new Restaurant { Name = "Name1", City = "City1", Country = "Country1" },
// new Restaurant { Name = "Name2", City = "City2", Country = "Country2" },
// new Restaurant
// {
// Name = "Name3",
// City = "City3",
// Country = "Country3",
// Reviews = new List<RestaurantReview> {
// new RestaurantReview { Rating=9, Body="Great Food"}
// }
// });
List <Restaurant> restaurants = new List <Restaurant>();
for (int i = 1; i < 200; i++)
{
string num = i.ToString();
Restaurant restaurant = new Restaurant
{
Name = "Name_" + num,
City = "City_" + num,
Country = "Country_" + num
};
if (i > 100)
{
List <RestaurantReview> reviews = new List <RestaurantReview>();
for (int j = 1; j < 6; j++)
{
RestaurantReview review = new RestaurantReview();
review.Rating = rnd.Next(0, 10);
review.Body = "This is review number " + j.ToString() + " for restaurant number " + num;
reviews.Add(review);
}
restaurant.Reviews = reviews;
}
restaurants.Add(restaurant);
}
foreach (Restaurant restaurant in restaurants)
{
context.Restaurants.Add(restaurant);
}
}
public RestaurantReviewBuilder()
{
_random = new Random();
_review = new RestaurantReview
{
ReviewerName = Guid.NewGuid().ToString(),
Rating = _random.Next(1, 6)
};
}
public async Task UpdateAsync(RestaurantReview review)
{
//Review might not be tracked (attached) by the entity framework -> get original from DB and copy values
var original = _context.RestaurantReviews.Find(review.Id);
var entry = _context.Entry(original);
entry.CurrentValues.SetValues(review);
await _context.SaveChangesAsync();
}
public ActionResult CreateReview(RestaurantReview model)
{
if (ModelState.IsValid)
{
_db.Reviews.Add(model);
_db.SaveChanges();
return(RedirectToAction("Review", new { id = model.RestaurantId }));
}
return(View(model));
}
public ActionResult EditReview(RestaurantReview model)
{
if (ModelState.IsValid)
{
_db.Entry(model).State = System.Data.EntityState.Modified;
_db.SaveChanges();
return(RedirectToAction("Review", new { id = model.RestaurantId }));
}
return(View(model));
}
public ActionResult Edit(RestaurantReview review)
{
if (ModelState.IsValid)
{
_db.Entry(review).State = System.Data.Entity.EntityState.Modified;
_db.SaveChanges();
return(RedirectToAction("Index", new { id = review.RestaurantID }));
}
return(View(review));
}
public ActionResult BestReview()
{
RestaurantReview bestReview = new RestaurantReview()
{
Rating = 20,
Body = "this is the best review"
};
return(PartialView("_Review", bestReview));
}
public ActionResult Edit([Bind(Include = "Id,ReviewerName, Rating,Comment,DateRated, Restaurant_RestaurantId, ReviewerId ")] RestaurantReview restaurantReview)
{
if (ModelState.IsValid)
{
db.Entry(restaurantReview).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index", new { restId = restaurantReview.Restaurant_RestaurantId }));
}
return(View(restaurantReview));
}
public ActionResult Edit(RestaurantReview review)
{
if (ModelState.IsValid)
{
_db.Entry(review).State = EntityState.Modified;//Here is a review i want you to track so you can make changes in the database, but its not a new review so I don't want it inserted into the database. Instead its a review that's already in the database.
_db.SaveChanges();
return(RedirectToAction("Index", new { id = review.RestaurantId }));
}
return(View(review));
}
public ActionResult Edit([Bind(Include = "Id,Rating,Body,RestaurantReviewer")] RestaurantReview restaurantReview)
{
if (ModelState.IsValid)
{
db.Entry(restaurantReview).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(restaurantReview));
}
public void Delete(Guid id)
{
RestaurantReview review = new RestaurantReview
{
Id = id
};
_restaurantReviewRepository.Delete(review);
_restaurantReviewRepository.Save();
}
public ActionResult Create(RestaurantReview review)
{
if (ModelState.IsValid)
{
_db.Reviews.Add(review);
_db.SaveChanges();
return(RedirectToAction("Index", new { id = review.RestaurantId }));
}
return(View(review));
}
public ActionResult Edit(RestaurantReview reviewViewModel)
{
if (ModelState.IsValid)
{
db.Entry(reviewViewModel).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index", new { id = reviewViewModel.RestaurantId }));
}
return(View(reviewViewModel));
}
//
// GET: /RestaurantReview/Edit/5
public ActionResult Edit(int id = 0)
{
RestaurantReview restaurantreview = db.Reviews.Find(id);
if (restaurantreview == null)
{
return(HttpNotFound());
}
return(View(restaurantreview));
}
public ActionResult Edit([Bind(Exclude = "ReviewerName")] RestaurantReview review)
{
if (ModelState.IsValid)
{
_db.Entry(review).State = EntityState.Modified;
_db.SaveChanges();
return(RedirectToAction("Index", new { id = review.RestaurantId }));
}
return(View(review));
}
public ActionResult Add(RestaurantReview review)
{
if (ModelState.IsValid)
{
_reviewRepository.Add(review);
return(RedirectToAction(nameof(Index), new { restaurantId = review.RestaurantId }));
}
return(View(review));
}
