//SP logs individual vote
public static string VoteInsert(InsertVoteRequest model)
{
string userName = "";
DataProvider.ExecuteNonQuery(GetConnection, "dbo.PointScore_InsertVote"
, inputParamMapper : delegate(SqlParameterCollection paramCollection)
{
paramCollection.AddWithValue("@UserName", model.UserName);
paramCollection.AddWithValue("@NetVote", model.NetVote);
paramCollection.AddWithValue("@VoteType", model.VoteType);
paramCollection.AddWithValue("@ContentId", model.ContentId);
paramCollection.AddWithValue("@VoterId", model.VoterId);
paramCollection.AddWithValue("@PlacesId", model.PlacesId);
paramCollection.AddWithValue("@UserId", model.UserId);
}, returnParameters : delegate(SqlParameterCollection param)
{
userName = (string)param["@UserName"].Value;
});
return(userName);
}
public HttpResponseMessage InsertVote(InsertVoteRequest model)
{
if (!ModelState.IsValid)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState));
}
//get current logged-in user
model.VoterId = UserService.GetCurrentUserId();
//insert new row into dbo.PointScore, this creates a log for each vote casted
VoteService.VoteInsert(model);
//updates overall point score for each username
_userProfileService.UpdateUserPointScore(model.UserName, model.NetVote);
//updates the review's individual point score
if (model.isMedia)
{
_RatingService.UpdateReviewPointScoreForMedia(model.ContentId, model.NetVote);
}
else
{
_RatingService.UpdateReviewPointScore(model.ContentId, model.NetVote);
}
SystemEventService.AddSystemEvent(new AddSystemEventModel
{
ActorUserId = model.VoterId,
ActorType = ActorType.User,
EventType = SystemEventType.UserVote,
TargetId = model.ContentId,
TargetType = TargetType.Review
});
return(Request.CreateResponse(HttpStatusCode.OK, model));
}