public NewAchievement AddProposedAchievement(ProposedAchievementRequest proposedAchievementRequest) { using (SqlConnection connection = new SqlConnection(_connectionString)) { var newAchievement = new NewAchievement() { GameId = proposedAchievementRequest.GameId, Name = proposedAchievementRequest.Name, Description = proposedAchievementRequest.Description, Image = proposedAchievementRequest.Image, DateSubmitted = DateTime.Now, Difficulty = proposedAchievementRequest.Difficulty }; var queryString = @"Insert into Achievement(GameId, Name, Description, Image, DateSubmitted, IsPending, IsApproved, VotingIsActive, Difficulty) Output inserted.* Values(@GameId, @Name, @Description, @Image, @DateSubmitted, 1, 0, 1, @Difficulty)"; var achievement = connection.QueryFirstOrDefault <NewAchievement>(queryString, newAchievement); return(achievement); } throw new Exception("Could not post new achievement."); }
public ActionResult AddProposedAchievement(ProposedAchievementRequest proposedAchievementRequest) { var achievement = _connection.AddProposedAchievement(proposedAchievementRequest); return(Accepted(achievement)); }