public JsonResult DownVote(int?id, string userName)
{
SuggestionUpvoteJsonReturnView json = new SuggestionUpvoteJsonReturnView();
if (id == null)
{
json.Success = false;
return(Json(json));
}
Suggestion suggestion = db.Suggestions.Find(id);
if (suggestion == null)
{
json.Success = false;
return(Json(json));
}
SuggestionUpvote upvote = db.SuggestionUpvotes.Where(s => s.SuggestionId == id).Where(s => s.FirstName == userName).Single();
db.SuggestionUpvotes.Remove(upvote);
suggestion.Vote = suggestion.SuggestionUpvotes.Count;
db.SaveChanges();
json.Upvotes = db.SuggestionUpvotes.Where(s => s.SuggestionId == suggestion.SuggestionId).Count();
json.Success = true;
return(Json(json));
}
public JsonResult Upvote(int?id)
{
SuggestionUpvoteJsonReturnView json = new SuggestionUpvoteJsonReturnView();
SuggestionUpvote upvote = new SuggestionUpvote();
if (id == null)
{
json.Success = false;
return(Json(json));
}
Suggestion suggestion = db.Suggestions.Find(id);
if (suggestion == null)
{
json.Success = false;
return(Json(json));
}
upvote.SuggestionId = suggestion.SuggestionId;
upvote.FirstName = User.Identity.Name;
db.SuggestionUpvotes.Add(upvote);
suggestion.Vote = suggestion.SuggestionUpvotes.Count;
db.SaveChanges();
json.Success = true;
json.Upvotes = suggestion.Vote;
return(Json(json));
}
