public JsonResult GetHotels()
{
HotelRating hotelRating = new HotelRating();
var hotels = hotelRating.GetAllHotels();
return(Json(hotels, JsonRequestBehavior.AllowGet));
}
public Review(User reviewAuthor, Hotel reviewedHotel, string description, HotelRating hotelRating)
{
ReviewAuthor = reviewAuthor;
ReviewedHotel = reviewedHotel;
Description = description;
HotelRating = hotelRating;
}
public ActionResult DeleteConfirmed(int id)
{
HotelRating hotelRating = db.HotelRatings.Find(id);
db.HotelRatings.Remove(hotelRating);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "Id,Rating,HotelName")] HotelRating hotelRating)
{
if (ModelState.IsValid)
{
db.Entry(hotelRating).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(hotelRating));
}
// GET: HotelRatings/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
HotelRating hotelRating = db.HotelRatings.Find(id);
if (hotelRating == null)
{
return(HttpNotFound());
}
return(View(hotelRating));
}
public async Task <bool> CreateHotelRatingAsync(HotelRatingCreate model)
{
var entity = new HotelRating
{
Comment = model.Comment,
HotelId = model.HotelId,
Grade = model.Grade,
UserId = _userId,
StayDate = model.StayDate
};
_context.Ratings.Add(entity);
var changeCount = await _context.SaveChangesAsync();
return(changeCount == 1);
}
public ActionResult Create([Bind(Include = "hotelrating_id,hotel_id,rating,review,user_id")] HotelRating hotelRating)
{
hotelRating.user_id = User.Identity.GetUserId();
if (hotelRating.rating <= 0) // if given is not given
{
ViewBag.error = true;
}
else if (ModelState.IsValid && hotelRating.rating > 0)
{
db.HotelRatings.Add(hotelRating);
db.SaveChanges();
var hotel = db.Hotels.FirstOrDefault(h => h.hotel_id == hotelRating.hotel_id);
var ratingAvg = hotel.HotelRatings.Average(h => h.rating); // recalculate the rating for the hotel
hotel.rating = (int)ratingAvg;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.hotel_id = new SelectList(db.Hotels, "hotel_id", "name", hotelRating.hotel_id);
return(View(hotelRating));
}
public ActionResult Rate([Bind(Include = "Id,Rating,HotelId")] HotelRating hotelRating)
{
hotelRating.UserId = User.Identity.GetUserId();
var userId = User.Identity.GetUserId();
ModelState.Clear();
TryValidateModel(hotelRating);
if (ModelState.IsValid)
{
if (!db.HotelRatings.Where(b => b.UserId == userId).Any(b => b.HotelId == hotelRating.HotelId &&
b.HotelId == hotelRating.HotelId))
{
db.HotelRatings.Add(hotelRating);
db.SaveChanges();
return(RedirectToAction("Index"));
}
else
{
return(View("Error"));
}
}
ViewBag.HotelId = new SelectList(db.Hotels, "Id", "Name", hotelRating.HotelId);
return(View(hotelRating));
}
public ActionResult InsertToHotelRating(HotelRating hotelRating)
{
modelobj.HotelRatings.Add(hotelRating);
return(View(modelobj.SaveChanges()));
}
public HttpResponseMessage InsertToHotelRating(HotelRating hotelRating)
{
modelobj.HotelRatings.Add(hotelRating);
return(Request.CreateResponse(HttpStatusCode.OK, modelobj.SaveChanges()));
}
