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