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