public JsonResult GetReviews(string id)
{
MongodbFunctions mongo = new MongodbFunctions();
ObjectId objID = new ObjectId(id);
Databases.DomainModel.Product product = mongo.GetProduct(objID);
List <MongoDBRef> rev = product.Reviews;
int count = product.Reviews.Count;
List <Databases.DomainModel.ReviewShow> reviews = new List <Databases.DomainModel.ReviewShow>();
List <Databases.DomainModel.UserShow> users = new List <Databases.DomainModel.UserShow>();
foreach (MongoDBRef r in rev)
{
Databases.DomainModel.Review review = mongo.GetReview(new ObjectId(r.Id.ToString()));
Databases.DomainModel.User user = mongo.GetUser(new ObjectId(review.User.Id.ToString()));
Databases.DomainModel.UserShow userShow = new Databases.DomainModel.UserShow
{
Id = user.Id,
Name = user.Name,
Surname = user.Surname,
Email = user.Email,
Address = user.Address
};
Databases.DomainModel.ReviewShow reviewShow = new Databases.DomainModel.ReviewShow
{
Id = review.Id,
Grade = review.Grade,
Comment = review.Comment
};
reviews.Add(reviewShow);
users.Add(userShow);
}
if (User.IsInRole("User"))
{
Databases.DomainModel.User u = mongo.GetUser(User.Identity.Name);
TimescaledbFunctions tdb = new TimescaledbFunctions();
tdb.SeeReviews(u.Id.ToString(), id);
tdb.CloseConnection();
}
return(Json(new { number = count, revs = reviews, people = users }, JsonRequestBehavior.AllowGet));
}