public IHttpActionResult DeleteUserRatingForPlace([FromBody] UserPlaceRating userRating) { if (this.ratingRepository.DeleteUserRatingForPlace(userRating.UserId, userRating.PlaceId)) { return(Ok()); } return(this.Content(HttpStatusCode.BadRequest, "Something was wrong. Try again")); }
/// <summary> /// set user rating in DataBase /// </summary> /// <param name="userRating">User Place Rating model (user id, place id, rating)</param> /// <returns>bool value(true if success request, false if fail)</returns> public bool SetUserRatingForPlace(UserPlaceRating userRating) { using (SqlConnection connection = new SqlConnection(Constants.Constants.ConnectionStrings.DatabaseConnectionString)) { connection.Open(); SqlCommand command = new SqlCommand("InsertOrUpdateUsersPlaceRating", connection) { CommandType = CommandType.StoredProcedure }; command.Parameters.Add(new SqlParameter("@UserID", userRating.UserId)); command.Parameters.Add(new SqlParameter("@PlaceID", userRating.PlaceId)); command.Parameters.Add(new SqlParameter("@Rating", Convert.ToDecimal(userRating.Rating))); return(command.ExecuteNonQuery() != this.noRowsAffected); } }