public JsonResult CountRatingJson(int R, int IdPlace)
{
List <ReviewDTO> review = ReviewServices.GetAll().Where(x => x.PlaceId == IdPlace).ToList();
CountRating countRating = new CountRating();
countRating.RLike = review.Count(x => x.ValueLike == 1);
countRating.RDis = review.Count(x => x.ValueLike == 2);
countRating.RCheck = review.Count(x => x.Checkin == 1);
return(Json(countRating));
}
//----------------------------------------------------------------------------------
public ActionResult InformPlace(int id)
{
ViewBag.Page = pageInfo.setView("InformPlace").setTitle("InformPlace");
ViewBag.Method = HttpContext.Request.HttpMethod;
PlaceDTO placeDTO = PlaceService.Get(id);
if (placeDTO == null)
{
return(HttpNotFound());
}
List <PlacePhotoDTO> photo = PlacePhotoServices.GetAll().Where(x => x.PlaceId == id).ToList();
List <ReviewDTO> review = ReviewServices.GetAll().Where(x => x.PlaceId == id).OrderByDescending(x => x.Date).ToList();
//IQueryable<Rating> R = db.Ratings.Where(x => x.IdPlace == id);
int RLike = review.Count(x => x.ValueLike == 1);
int RDis = review.Count(x => x.ValueLike == 2);
int RCheck = review.Count(x => x.Checkin == 1);
int RRating = (RLike + RDis == 0) ? 0 : Convert.ToInt32(Math.Round(10.0 * Convert.ToDouble(RLike) / Convert.ToDouble(RLike + RDis)));
List <UserDTO> userDTO = UserServices.GetAll();
PlaceDTO obj = new PlaceDTO()
{
Id = placeDTO.Id,
Name = placeDTO.Name,
Longitude = placeDTO.Longitude,
Latitude = placeDTO.Latitude,
Address = placeDTO.Address,
Description = placeDTO.Description,
Phone = placeDTO.Phone,
Site = placeDTO.Site,
WorkingHour = placeDTO.WorkingHour
};
ViewBag.Album = photo;
ViewBag.Checkins = RCheck;
ViewBag.Comments = review;
ViewBag.Dislike = RDis;
ViewBag.Like = RLike;
ViewBag.Ratings = RRating;
ViewBag.Login = userDTO;
return(View(obj));
}
public JsonResult AddRatingJson(int R, int IdPlace)
{
ReviewDTO reviewDTO = null;
if (Identity.isAuthentication)
{
reviewDTO = ReviewServices.GetAll().FirstOrDefault(x => x.PlaceId == IdPlace && x.UserId == Identity.user.Id);
if (reviewDTO != null)
{
if (R != 4)
{
if (R == 1 || R == 2)
{
reviewDTO.ValueLike = R;
}
else
{
reviewDTO.Checkin = 1;
}
ReviewServices.Update(reviewDTO);
}
}
else
{
reviewDTO = new ReviewDTO();
{
reviewDTO.UserId = Identity.user.Id;
reviewDTO.PlaceId = IdPlace;
reviewDTO.ValueLike = (R != 3) ? R : 0;
reviewDTO.Checkin = (R == 3) ? 1 : 0;
reviewDTO.Date = DateTime.Now;
}
ReviewServices.Create(reviewDTO);
}
}
return(Json(reviewDTO));
}
public JsonResult TestRatingJson(int R, int IdPlace)
{
if (Identity.isAuthentication)
{
ReviewDTO reviewDTO = ReviewServices.GetAll().FirstOrDefault(x => x.PlaceId == IdPlace && x.UserId == Identity.user.Id);
if (reviewDTO != null)
{
if (R == 2 && reviewDTO.ValueLike == 2)
{
return(Json(true, JsonRequestBehavior.AllowGet));
}
else if (R == 1 && reviewDTO.ValueLike == 1)
{
return(Json(true, JsonRequestBehavior.AllowGet));
}
else if (R == 3 && reviewDTO.Checkin == 1)
{
return(Json(true, JsonRequestBehavior.AllowGet));
}
}
}
return(Json(false, JsonRequestBehavior.AllowGet));
}