public JsonResult AddNewChallenge(int player1Id, int player2Id, string token)
{
if (!base.ValidateToken(token))
{
return(Json(new
{
errMsg = "Invalid token detected - challenge not sent.",
err = "Invalid token.",
invalidToken = true
}));
}
var challenge = new db_Challenge
{
Player_1 = player1Id,
Player_2 = player2Id
};
if (_challengeRepo.AddNewChallenge(challenge))
{
return(Json(new
{
challengeCreated = true
}));
}
return(Json(new
{
errMsg = "Error creating challenge, please try again.",
err = "Challenge not created.",
invalidToken = false
}));
}
/// <summary>
/// Inserts a new challenge into the challenge database.
/// </summary>
/// <param name="challenge"></param>
/// <returns>bool</returns>
public bool AddNewChallenge(db_Challenge challenge)
{
try
{
_context.MySqlDb.Query <db_Challenge>("INSERT INTO challenge " +
"(player_1, player_2) " +
"VALUES (" + challenge.Player_1 + "," + challenge.Player_2 + ");",
commandType: CommandType.Text);
return(true);
}
catch (MySqlException mysqlex)
{
Debug.WriteLine("MYSQL EXCEPTION IN AddNewChallenge");
Debug.WriteLine(mysqlex.InnerException);
return(false);
}
catch (InvalidOperationException ioe)
{
Debug.WriteLine("INVALID OPERATION EXCEPTION IN AddNewChallenge");
Debug.WriteLine(ioe.InnerException);
return(false);
}
catch (Exception e)
{
Debug.WriteLine("EXCEPTION IN AddNewChallenge");
Debug.WriteLine(e.InnerException);
return(false);
}
}
