public async Task <IActionResult> PutUserReview([FromRoute] long id, [FromBody] UserReview userReview)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != userReview.Id)
{
return(BadRequest());
}
_context.Entry(userReview).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!UserReviewExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
public async Task GiveUserReviewCommand(GiveReviewForUserRequest request, string userId, UserManager <UserModel> userManager)
{
try
{
var user = await userManager.FindByIdAsync(request.OwnerId);
var userReviewOwner = await userManager.FindByIdAsync(userId);
var review = new UserReview()
{
ReviewDate = DateTime.Now,
ReviewDescription = request.ReviewDescription,
UserRefId = user.Id,
ReviewOwnerRefId = userId,
ReviewTitle = request.ReviewTitle,
UpVoteNum = Convert.ToString(request.UpVotePoints),
ReviewUsername = userReviewOwner.UserName
};
await _userRepository.AddUserReview(review);
user.UpVote += request.UpVotePoints;
await userManager.UpdateAsync(user);
}
catch (Exception ex)
{
_logger.LogError($"error while saving user review to database: {ex}");
throw ex.GetBaseException();
}
}
public UserReview Map(UserReviewDb userReview)
{
UserReview userReview_newType = new UserReview();
#region Transfer main attributes
userReview_newType.Id = userReview.Id;
userReview_newType.Content = userReview.Content;
userReview_newType.CreateDate = userReview.CreateDate;
userReview_newType.Rating = userReview.Rating;
#endregion
#region Transfering interop attributes
userReview_newType.IdReviewer = new User()
{
Id = userReview.IdReviewer
};
userReview_newType.IdReviewed = new User()
{
Id = userReview.IdReviewed
};
#endregion
return(userReview_newType);
}
public bool addUserReview(UserReview review, Book book)
{
string userId;
using (MySqlConnection con = new MySqlConnection(conString))
{
con.Open();
string cmdString = "select UserId from userreview where UserUname = @userUname";
using (MySqlCommand cmd = new MySqlCommand(cmdString))
{
cmd.Parameters.Add(new MySqlParameter("@userUname", review.ReviewOwner.UserName));
MySqlDataReader dataSet = cmd.ExecuteReader();
if (dataSet.HasRows)
{
userId = dataSet["UserId"].ToString();
}
else
{
dataSet.Close();
con.Close();
return(false);
}
}
cmdString = "INSERT INTO `bookstore`.`customerreview`(`CustomerId`,`BookId`,`CustomerRating`,`CustomerComment`) VALUES(@userId,@bookId,@bookRating,@bookComment)";
using (MySqlCommand cmd = new MySqlCommand(cmdString))
{
cmd.Parameters.Add(new MySqlParameter("@userId", userId));
cmd.Parameters.Add(new MySqlParameter("@bookId", book.BookId));
cmd.Parameters.Add(new MySqlParameter("@bookRating", review.ReviewRating));
cmd.Parameters.Add(new MySqlParameter("@bookComment", review.ReviewComment));
cmd.ExecuteNonQuery();
}
}
return(true);
}
public static List <UserReview> GetUserDetails(int UserID)
{
DataSet ds;
List <UserReview> list = new List <UserReview>();
using (MySqlConnection conn = new MySqlConnection(ConfigurationManager.ConnectionStrings["DB"].ConnectionString))
{
ds = MySqlHelper.ExecuteDataset(conn, "GetUserDetails");
}
foreach (DataRow row in ds.Tables[0].Rows)
{
UserReview u = new UserReview();
u.ID = (int)row["ID"];
u.UserID = (int)row["UserID"];
u.Name = row["Name"].ToString();
u.PreparedBy = row["PreparedBy"].ToString();
u.Rating = (int)row["rating"];
u.Approval = (int)row["Approval"];
u.Comment = row["Comment"].ToString();
list.Add(u);
}
List <UserReview> UserReview = new List <UserReview>();
for (int i = 0; i < list.Count; i++)
{
if (list[i].UserID == UserID)
{
UserReview.Add(list[i]);
}
}
return(UserReview);
}
public IActionResult Create(UserReview nr)
{
if (ModelState.IsValid)
{
UserReview NewUserReview = new UserReview
{
Reviewer = nr.Reviewer,
Restaurants = nr.Restaurants,
Review = nr.Review,
Visit = nr.Visit,
Stars = nr.Stars,
};
if (nr.Visit > DateTime.Now)
{
TempData["InvalidDate"] = "Date has to be before todays date";
}
else
{
_context.Add(NewUserReview);
_context.SaveChanges();
return(RedirectToAction("Reviews"));
}
}
return(RedirectToAction("Index"));
}
public UserReview AddUserReview(UserReview userReview)
{
_repositoryWrapper.UserReview.AddUserReview(userReview);
//_logger.WriteInfo($"Added user with id: {user.Id}.");
return(userReview);
}
public async Task <ActionResult <UserReview> > PostUserReview(UserReview UserReview)
{
_context.UserReview.Add(UserReview);
await _context.SaveChangesAsync();
return(CreatedAtAction("GetUserReview", new { id = UserReview.LngReviewId }, UserReview));
}
public void TestAddLongerDescriptionUserReview()
{
var userReview = new AuctionUser {
Id = 1, FirstName = "Ionel", LastName = "Pascu", Gender = "M"
};
var reviewUser = new AuctionUser {
Id = 2, FirstName = "Popa", LastName = "Andrei", Gender = "M"
};
var resultUser1 = this.auctionUserService.AddAuctionUser(userReview, Role.Buyer);
var resultUser2 = this.auctionUserService.AddAuctionUser(reviewUser, Role.Buyer);
var user1 = this.auctionUserService.GetAuctionUserByFistNameAndLastName("Ionel", "Pascu");
var user2 = this.auctionUserService.GetAuctionUserByFistNameAndLastName("Popa", "Andrei");
var review1 = new UserReview
{
Description =
"bFuDu3e8H7LuEGyZbYTUfxdKm9gweGGho3e8H9m2hlgBHgglrMME0Rf6CI99bdLg1wnSwBj3dKsJ2LpRENQIloUp4m7oj4Xs9mMbxbFuDu3e8H7LuEGyZbYTUfxdKm9gweGGho3e8H9m2hlgBHgglrMME0Rf6CI99bdLg1wnSwBj3dKsJ2LpRENQIloUp4m7oj4Xs9mMbx",
Score = 4,
ReviewByUser = user2,
ReviewForUser = user1
};
var resultReview1 = this.userReviewService.AddUserReview(review1);
Assert.True(!this.libraryContextMock.UserReviews.Any());
}
public UserReview UpdateUserReview(UserReview existing, UserReview userReview)
{
_repositoryWrapper.UserReview.UpdateUserReview(existing, userReview);
// _logger.WriteInfo($"Updated user with id: {user.Id}.");
return(userReview);
}
public void apiLogic(bool post, UserReview userReview)
{
JObject obj;
if (post)
{
obj = new APICaller("postReview.php")
.AddParam("privateKey", PrivateKey)
.AddParam("message", userReview.Message)
.AddParam("username", userReview.Username)
.AddParam("positive", (userReview.Karma > 0).ToString())
.Call();
}
else
{
obj = new APICaller("removeReview.php")
.AddParam("privateKey", PrivateKey)
.AddParam("username", userReview.Username)
.Call();
}
ManagerStatus status = ManagerStatus.UnknownError;
if (!Enum.TryParse <ManagerStatus>(obj["message"].ToString(), out status))
{
status = ManagerStatus.UnknownError;
}
if (post)
{
PostUserReviewResult(status, userReview);
}
else
{
RemoveUserReviewResult(status, userReview);
}
}
public void TestGetAllUserReviewsWithAWrongUser()
{
var userReview = new AuctionUser {
Id = 1, FirstName = "Ionel", LastName = "Pascu", Gender = "M"
};
var reviewUser = new AuctionUser {
Id = 2, FirstName = "Popa", LastName = "Andrei", Gender = "M"
};
var resultUser1 = this.auctionUserService.AddAuctionUser(userReview, Role.Buyer);
var resultUser2 = this.auctionUserService.AddAuctionUser(reviewUser, Role.Buyer);
var user1 = this.auctionUserService.GetAuctionUserByFistNameAndLastName("Ionel", "Pascu");
var user2 = this.auctionUserService.GetAuctionUserByFistNameAndLastName("Popa", "Andrei");
var review1 = new UserReview
{
Description = "He is a good man", Score = 4, ReviewByUser = user2, ReviewForUser = user1
};
var review2 = new UserReview
{
Description = null, Score = 2, ReviewByUser = userReview, ReviewForUser = user2
};
var resultReview1 = this.userReviewService.AddUserReview(review1);
var resultReview2 = this.userReviewService.AddUserReview(review2);
var reviews = this.userReviewService.GetUserReviews();
Assert.IsFalse(reviews.Count() == 2);
}
public void postReview(UserReview userReview)
{
if (UserReviewManagerThread != null && UserReviewManagerThread.IsAlive) // Jau vyksta užklausa
{
return;
}
if (String.IsNullOrEmpty(userReview.Username) || String.IsNullOrWhiteSpace(userReview.Username))
{
PostUserReviewResult(ManagerStatus.UsernameEmpty, null);
return;
}
if (String.IsNullOrEmpty(userReview.Message) || String.IsNullOrWhiteSpace(userReview.Message))
{
PostUserReviewResult(ManagerStatus.MessageEmpty, null);
return;
}
if (userReview.Message.Length > 2000)
{
PostUserReviewResult(ManagerStatus.MessageTooLong, null);
return;
}
UserReviewManagerThread = new Thread(() => apiLogic(true, userReview)); // There's probably a better way
UserReviewManagerThread.Start();
}
public async Task <IActionResult> Edit(int id, [Bind("ID,name,game,rating,review")] UserReview userReview)
{
if (id != userReview.ID)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(userReview);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!UserReviewExists(userReview.ID))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction("Index"));
}
return(View(userReview));
}
private void listBox2_SelectedIndexChanged(object sender, EventArgs e)
{
if (listBox2.SelectedIndex != -1)
{
var showHist = ((UserShowHistory)listBox2.SelectedItem);
Tuple <int, int> data = new Tuple <int, int>(this.user.Id, showHist.Id);
var review = new ApiConnector <UserReview>().ForController("userReview")
.AddParameter("userId", this.user.Id)
.AddParameter("historyId", showHist.Id)
.Get();
if (review == null)
{
review = new UserReview();
}
numericUpDown2.Value = review.Rating;
textBox6.Text = review.Review;
}
else
{
numericUpDown2.Value = 0;
textBox6.Clear();
}
}
public async Task <ActionResult <UserReview> > PostUserReview([FromBody] PostUserReviewDto model)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (model.UserId == User.Identity.Name)
{
return(BadRequest("You can't review yourself"));
}
if (await _context.UserReviews.Where(x => x.UserId == model.UserId && x.ReviewerId == User.Identity.Name).FirstOrDefaultAsync() != null)
{
return(BadRequest("You can review only once"));
}
var review = new UserReview()
{
UserId = model.UserId,
ReviewerId = User.Identity.Name,
Review = model.Review,
Comment = model.Comment
};
await _context.UserReviews.AddAsync(review);
try { await _context.SaveChangesAsync(); }
catch (Exception error) { BadRequest(error); }
return(Ok("Thanks for your review"));
}
public void Run()
{
var userReviews = new List <UserReview>();
foreach (string line in threadLines)
{
string[] data = line.Split("::");
if (data.Length >= 4 &&
int.TryParse(data[0], out int userId) &&
int.TryParse(data[1], out int movieId) &&
byte.TryParse(data[2], out byte movieRating) &&
int.TryParse(data[3], out int timestamp))
{
var newUserReview = new UserReview()
{
MovieId = movieId,
Rating = movieRating,
Timestamp = timestamp,
UserId = userId
};
userReviews.Add(newUserReview);
}
else
{
Console.WriteLine($"Error: {line}");
}
}
aggregator.Aggregate(userReviews);
}
public WriteUserReviewForm(LocalUser localUser, User user)
{
this.localUser = localUser;
this.user = user;
InitializeComponent();
userReview = new UserReview();
}
public DistinctReviewList <UserReview> GetUserReviewData(string category)
{
MySqlCommand command = new MySqlCommand("SELECT * FROM Review WHERE isCriticReview<>1 AND productType = \"" + category + "\"", connection);
DistinctReviewList <UserReview> result = new DistinctReviewList <UserReview>();
MySqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
object[] tempResult = new object[reader.FieldCount];
reader.GetValues(tempResult);
UserReview row = new UserReview((int)tempResult[0], reader.GetBoolean(10), (float)tempResult[4], (float)tempResult[14],
reader.GetDateTime(1),
(string)tempResult[13], (string)tempResult[12], (string)tempResult[11], reader.GetBoolean(9),
(string)tempResult[3], //content
(string)tempResult[6] //author
);
if (!reader.IsDBNull(7) && !reader.IsDBNull(8))
{
row.positiveReception = (int)tempResult[7];
row.negativeReception = (int)tempResult[8];
}
result.Add(row);
}
reader.Close();
return(result);
}
public override void OnStart()
{
Film f = SharedComponents.CurrentFilm;
DetailedFilm df = WaitForItBLL.Singleton.GetMovie(f);
_userReview = SharedComponents.CurrentUser.GetUserReview(f.Id);
_movieTitleTextView = Activity.FindViewById <TextView>(Resource.Id.filmNameTextView);
_movieReleaseDateTextView = Activity.FindViewById <TextView>(Resource.Id.filmRealeaseDateTextView);
_movieOverviewTextView = Activity.FindViewById <TextView>(Resource.Id.filmOverviewTextView);
_moviePosterImageView = Activity.FindViewById <ImageView>(Resource.Id.filmPosterImageView);
_movieDirectorTextView = Activity.FindViewById <TextView>(Resource.Id.filmDirectorTextView);
_movieActorsTextView = Activity.FindViewById <TextView>(Resource.Id.filmCastTextView);
_movieNoteTextView = Activity.FindViewById <TextView>(Resource.Id.filmNotesTextView);
_movieNoteCountTextView = Activity.FindViewById <TextView>(Resource.Id.filmNotesCountTextView);
_movieRuntimeTextView = Activity.FindViewById <TextView>(Resource.Id.filmRuntimeTextView);
_movieGenresTextView = Activity.FindViewById <TextView>(Resource.Id.filmGenresTextView);
_yepButton = Activity.FindViewById <Button>(Resource.Id.yepButton);
_nopButton = Activity.FindViewById <Button>(Resource.Id.nopButton);
_reviewStatusTextView = Activity.FindViewById <TextView>(Resource.Id.reviewStatusTextView);
_positiveReviewsTextView = Activity.FindViewById <TextView>(Resource.Id.positiveReviewsTextView);
_negativeReviewsTextView = Activity.FindViewById <TextView>(Resource.Id.negativeReviewsTextView);
_percentageTextView = Activity.FindViewById <TextView>(Resource.Id.percentageTextView);
_percentageProgressBar = Activity.FindViewById <ProgressBar>(Resource.Id.percentageProgressBar);
_movieTitleTextView.Text = df.Title;
_movieReleaseDateTextView.Text = Resources.GetString(Resource.String.Released, df.ReleaseDate.ToLongDateString());
_movieOverviewTextView.Text = (df.Overview == null || df.Overview == string.Empty) ? Resources.GetString(Resource.String.EmptyOverview) : df.Overview;
_movieActorsTextView.Text = df.Acteurs;
_movieDirectorTextView.Text = Resources.GetString(Resource.String.By, df.Realisateur);
_movieNoteTextView.Text = $"{df.VoteAverage}/10";
_movieNoteCountTextView.Text = Resources.GetQuantityString(Resource.Plurals.ReviewsCount, df.VoteCount, df.VoteCount);
_movieRuntimeTextView.Text = df.Duree.ToString();
_movieGenresTextView.Text = df.Genres;
if (df.Duree == TimeSpan.Zero)
{
_movieRuntimeTextView.Visibility = ViewStates.Gone;
}
if (df.Realisateur == null)
{
_movieDirectorTextView.Visibility = ViewStates.Gone;
}
_moviePosterImageView.SetUrlDrawable(df.PosterBigImagePath, Android.Resource.Drawable.IcMenuGallery);
_positiveReviewsTextView.Text = Resources.GetString(Resource.String.SaidYes, df.PositiveReviewsCount);
_negativeReviewsTextView.Text = Resources.GetString(Resource.String.SaidNo, df.NegativeReviewsCount);
_percentageTextView.Text = $"{f.YesPercentage}%";
_percentageProgressBar.SetProgress(f.YesPercentage, false);
_percentageProgressBar.ProgressDrawable.SetColorFilter(GetGradientColor(f.YesPercentage), PorterDuff.Mode.SrcIn);
_yepButton.Click += _yepButton_Click;
_nopButton.Click += _nopButton_Click;
GestionAffichageUtilisateur();
base.OnStart();
}
public void Print()
{
Console.WriteLine("User Name: {0}\t Rate:{1}", this.Name, this.UserRate);
if (!UserReview.Equals(""))
{
Console.WriteLine(" Review: " + UserReview);
}
}
public void addReview(User submitter, string review_text, int rating)
{
//How is review_id determined?
int review_id = 0;
UserReview newReview = new UserReview(review_id, submitter.Id, this.Id, review_text, DateTime.Now, rating);
reviews.Add(newReview);
}
public ActionResult DeleteConfirmed(int id)
{
UserReview userReview = db.UserReviews.Find(id);
db.UserReviews.Remove(userReview);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public void removeUserReview(UserReview userReview)
{
if (UserReviewManagerThread != null && UserReviewManagerThread.IsAlive) // Jau vyksta užklausa
{
return;
}
UserReviewManagerThread = new Thread(() => apiLogic(false, userReview)); // There's probably a better way
UserReviewManagerThread.Start();
}
public async Task GetUserReviewsAsync_ValidId_ReturnsValidResult(string id)
{
ITelevisionApi apiUnderTest = new TelevisionApi(_clientWithNoApiKey);
UserReview result = await apiUnderTest.GetUserReviewsAsync(id, apiKey : _userApiKey);
Assert.IsNotNull(result);
Assert.IsNotEmpty(result.Results);
}
public ViewResult Create(int id)
{
var newUserReview = new UserReview()
{
BeerId = id
};
return(View(newUserReview));
}
/// <summary>
/// Update an UserReview.
/// </summary>
/// <param name="userReview">The UserReview.</param>
/// <returns>If UserReview was updated.</returns>
public bool UpdateUserReview(UserReview userReview)
{
if (this.ValidateUserReview(userReview))
{
return(this.userReviewRepository.UpdateUserReview(userReview));
}
return(false);
}
int IUserReviewsDataAdapter.AddNewUserReview(UserReviewDM userReviewDM)
{
IModelBuilder <UserReview, UserReviewDM> domainToEntityModelBuilder = new UserReviewDomainEntityModelBuilder();
AddNewUserReviewOperation addNewUserReviewOperation = new AddNewUserReviewOperation();
UserReview userReviewDataEntity = domainToEntityModelBuilder.Build(userReviewDM);
return(addNewUserReviewOperation.AddNewUserReview(userReviewDataEntity));
}
public void AddOrUpdateReview(UserReviewDto user)
{
var entity = new UserReview();
var document = user.ToTextAnalyticsDocuments();
user.TextAnalyticRespons = GetTextAnalyticsSentiment(document);
entity.FromUserReviewDto(user);
userReviewRepository.Insert(entity);
userReviewRepository.Save();
}
public async Task <IActionResult> Create([Bind("ID,name,game,rating,review")] UserReview userReview)
{
if (ModelState.IsValid)
{
_context.Add(userReview);
await _context.SaveChangesAsync();
return(RedirectToAction("Index"));
}
return(View(userReview));
}
public void addReview(User submitter, string review_text, int rating)
{
//How is review_id determined?
int review_id = 0;
UserReview newReview = new UserReview(review_id, submitter.Id, this.Id, review_text, DateTime.Now, rating);
reviews.Add(newReview);
}
/// <summary>
///
/// </summary>
/// <param name="publicRecipeId"></param>
/// <param name="reviewerUserId"></param>
/// <param name="rating"></param>
/// <param name="comment"></param>
/// <param name="requestUserId"></param>
/// <returns>Any error message. Empty message indicates success</returns>
public string Review(int publicRecipeId, string reviewerUserId, double rating, string comment)
{
var pubR = _publicRecipeRepo.GetById(publicRecipeId);
if (pubR == null) return "Recipe does not exist";
if (pubR.Author == reviewerUserId) return "Recipe author cannot review his/her own recipe";
if (pubR.Reviews != null && pubR.Reviews.Count > 0)
{
foreach (var userReview in pubR.Reviews)
{
if (userReview.ReviewerUserId == reviewerUserId)
{
return $"User {reviewerUserId} already reviewed this recipe";
}
}
}
var review = new UserReview
{
ReviewerUserId = reviewerUserId,
Rating = rating,
Comment = comment,
PublicRecipe = pubR
};
pubR.AddReview(review);
_publicRecipeRepo.Update(pubR); //Save entire graph of data
return string.Empty;
}
public bool AddReview(UserReview review)
{
if (this.Reviews == null) this.Reviews = new List<UserReview>();
this.Reviews.Add(review);
return true;
}
