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