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."); }