public JsonResult GetComments(string id) { MongodbFunctions mongo = new MongodbFunctions(); ObjectId objID = new ObjectId(id); Databases.DomainModel.Product product = mongo.GetProduct(objID); List <MongoDBRef> mess = product.Messages; int count = product.Messages.Count; string role; if (User.IsInRole("Admin")) { role = "Admin"; } else { role = "User"; } List <Databases.DomainModel.MessageShow> comments = new List <Databases.DomainModel.MessageShow>(); List <Databases.DomainModel.UserShow> users = new List <Databases.DomainModel.UserShow>(); foreach (MongoDBRef r in mess) { Databases.DomainModel.Message comment = mongo.GetComment(new ObjectId(r.Id.ToString())); Databases.DomainModel.User user = mongo.GetUser(new ObjectId(comment.User.Id.ToString())); List <string> responses = new List <string>(); foreach (MongoDBRef rr in comment.Responses) { Databases.DomainModel.AdminResponse response = mongo.GetResponse(new ObjectId(rr.Id.ToString())); responses.Add(response.Content); } Databases.DomainModel.MessageShow messShow = new Databases.DomainModel.MessageShow { Id = comment.Id.ToString(), Content = comment.Content, Responses = responses }; Databases.DomainModel.UserShow userShow = new Databases.DomainModel.UserShow { Id = user.Id, Name = user.Name, Surname = user.Surname, Email = user.Email, Address = user.Address }; comments.Add(messShow); users.Add(userShow); } return(Json(new { number = count, status = role, com = comments, people = users }, JsonRequestBehavior.AllowGet)); }
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)); }