public ActionResult GetProposedAchievementsForGame(int gameId, int userId)
{
var request = new ProposedAchievementsForGameRequest()
{
UserId = userId, GameId = gameId
};
var achievements = _connection.GetProposedAchievementsForGame(request);
return(Accepted(achievements));
}
public IEnumerable <Achievement> GetProposedAchievementsForGame(ProposedAchievementsForGameRequest request)
{
using (SqlConnection connection = new SqlConnection(_connectionString))
{
var queryString = @"Select Achievement.Id as AchievementId, Achievement.DateSubmitted, Difficulty, Description,
Achievement.Image, Achievement.Name as AchievementName, Vote.Id as VoteId
From Achievement
Left Join Vote on Vote.AchievementId = Achievement.Id AND Vote.UserId = @UserId
Where VotingIsActive = 1 AND Achievement.GameId = @GameId
Order by DateSubmitted Desc";
var achievements = connection.Query <Achievement>(queryString, request);
return(achievements);
}
throw new Exception("Could not get achievements.");
}
