public HttpResponseMessage UpdateVotes(IncidentVotesRequest model)
{
try
{
if (ModelState.IsValid)
{
var resp = new SuccessResponse();
_incidentService.Votes(model);
return(Request.CreateResponse(HttpStatusCode.OK, resp));
}
else
{
return(Request.CreateResponse(HttpStatusCode.BadRequest, ModelState));
}
}
catch (Exception ex)
{
return(Request.CreateResponse(HttpStatusCode.BadRequest, ex));
}
}
public void Votes(IncidentVotesRequest incidentVotesRequest)
{
var upvotes = SqlInt32.Null;
var downvotes = SqlInt32.Null;
if (incidentVotesRequest.Upvotes > 0)
{
upvotes = incidentVotesRequest.Upvotes;
}
if (incidentVotesRequest.Downvotes > 0)
{
downvotes = incidentVotesRequest.Downvotes;
}
_dataProvider.ExecuteNonQuery(
"incidents_votes",
inputParamMapper : delegate(SqlParameterCollection paramCol)
{
paramCol.AddWithValue("@Id", incidentVotesRequest.Id);
paramCol.AddWithValue("@Upvotes", upvotes);
paramCol.AddWithValue("@Downvotes", downvotes);
}
);
}
