public ActionResult CreateReview(int id) { LibRestaurant findRestaurant = controllerManager.SearchResByID(id); LibReview newReview = new LibReview(); ViewBag.RestName = findRestaurant.Name; newReview.RestID = id; return(View(newReview)); }
public double CalculateAvgRating(LibRestaurant rateRestaurant) { double runningTotal = 0.0; double avg = 0.0; foreach (Models.LibReview r in rateRestaurant.Reviews) { runningTotal += r.Rating; } avg = runningTotal / rateRestaurant.Reviews.Count; return(avg); }
public List <LibRestaurant> PrintRestaurants() { //RestaurantData crud = new RestaurantData(); List <LibRestaurant> returnRestaurants = new List <LibRestaurant>(); foreach (RestaurantReviewData.Restaurant dbr in crud.PrintRestaurants()) { LibRestaurant tempRestaurant = ModelConverter.DBToResObject(dbr); foreach (Review rev in dbr.Reviews) { tempRestaurant.Reviews.Add(ModelConverter.DBToRevObj(rev)); } tempRestaurant.AvgRating = CalculateAvgRating(tempRestaurant); returnRestaurants.Add(tempRestaurant); } return(returnRestaurants); }
public static Restaurant ResObjToDB(LibRestaurant objRest) { Restaurant DBRest = new Restaurant() { ID = objRest.ID, Name = objRest.Name, Address = objRest.Address, City = objRest.City, Country = objRest.Country, ZIP = objRest.ZIP, AvgRating = objRest.AvgRating, Reviews = new List <Review>() }; foreach (Models.LibReview r in objRest.Reviews) { DBRest.Reviews.Add(RevObjToDB(r)); } return(DBRest); }
public static LibRestaurant DBToResObject(Restaurant DBRestaurant) { LibRestaurant restObj = new LibRestaurant() { ID = DBRestaurant.ID, Name = DBRestaurant.Name, Address = DBRestaurant.Address, City = DBRestaurant.City, Country = DBRestaurant.Country, ZIP = DBRestaurant.ZIP, AvgRating = (double?)DBRestaurant.AvgRating ?? 0.0, Reviews = new List <LibReview>() }; foreach (Review r in DBRestaurant.Reviews) { restObj.Reviews.Add(DBToRevObj(r)); } return(restObj); }
public ActionResult CreateRestaurant(/*[Bind(Include = "ID, Name, Address, City, Country, ZIP")]*/ LibRestaurant restaurant) { try { webManager.AddRestaurantToDB(restaurant); return(RedirectToAction("Index")); } catch { return(View()); } }
public ActionResult DeleteRestaurant(/*[Bind(Include = "ID, Name, Address, City, Country, ZIP")]*/ LibRestaurant delete) { try { webManager.DeleteRestaurantFromDB(delete.ID); return(RedirectToAction("Index")); } catch { return(View()); } }
public ActionResult Edit(/*[Bind(Include = "ID, Name, Address, City, Country, ZIP")]*/ int id, LibRestaurant newRestaurant) { try { var oldRestaurant = restaurants.First(x => x.ID == id); webManager.UpdateRestaurantInDB(newRestaurant); return(RedirectToAction("Index")); } catch { return(View()); } }