public HttpResponseMessage Del(int user_id, int choice_id)
{
try
{
using (Entities entities = new Entities())
{
Expression <Func <USER_VOTES, bool> > expr = uv => uv.USER_ID == user_id && uv.VOTING_CHOICE_ID == choice_id;
USER_VOTES userVotes = entities.USER_VOTES.FirstOrDefault(expr);
if (userVotes == null)
{
return(Request.CreateResponse(HttpStatusCode.OK, new Result()
{
statusCode = 404, status = "Not found"
}));
}
entities.USER_VOTES.Remove(userVotes);
entities.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK, new Result()
{
statusCode = 200, status = "Success"
}));
}
}
catch (Exception ex)
{
return(Request.CreateResponse(HttpStatusCode.OK, new Result()
{
statusCode = 400, status = ex.Message
}));
}
}
public HttpResponseMessage Vote(int user_id, int choice_id)
{
try
{
using (Entities entities = new Entities())
{
Expression <Func <USER_VOTES, bool> > expr = uv => uv.USER_ID == user_id && uv.VOTING_CHOICE_ID == choice_id;
var userVotes = entities.USER_VOTES.FirstOrDefault(expr);
if (userVotes != null)
{
return(Request.CreateResponse(HttpStatusCode.OK, new Result()
{
statusCode = 400, status = "Already voted"
}));
}
USER_VOTES newUserVote = new USER_VOTES()
{
USER_VOTE_ID = entities.USER_VOTES.Max(v => v.USER_VOTE_ID) + 1,
USER_ID = user_id,
VOTING_CHOICE_ID = choice_id,
VOTING_DATE = DateTime.Now
};
entities.USER_VOTES.Add(newUserVote);
entities.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK, new Result()
{
statusCode = 200, status = "Success"
}));
}
}
catch (Exception ex)
{
return(Request.CreateResponse(HttpStatusCode.OK, new Result()
{
statusCode = 400, status = ex.Message
}));
}
}
