public bool UpdateBracketStandings(int bracketID, BracketCompetitor bracketCompetitor) { try { var DB = new Database(); using (MySqlConnection conn = new MySqlConnection(DB.GetConnString())) { using (MySqlCommand comm = conn.CreateCommand()) { comm.CommandText = "UPDATE bracket_player_info SET score=score+1 WHERE bracketID=@BracketID AND hashedUserID=@HashedUserID"; comm.Parameters.AddWithValue("@BracketID", bracketID); comm.Parameters.AddWithValue("@HashedUserID", bracketCompetitor.HashedUserID); conn.Open(); comm.ExecuteNonQuery(); conn.Close(); return(true); } } } catch (Exception e) { return(false); } }
public bool UpdateBracketStanding(int bracketID, BracketCompetitor bracketCompetitor) { TournamentBracketDatabaseQuery tournamentBracketDatabaseQuery = new TournamentBracketDatabaseQuery(); bool result = tournamentBracketDatabaseQuery.UpdateBracketStandings(bracketID, bracketCompetitor); return(result); }
public bool UpdateBracketStanding(int bracketID, BracketCompetitor bracketCompetitor) { try { bool result = _tournamentBracketService.UpdateBracketStanding(bracketID, bracketCompetitor); _loggingManager.Log("Bracket Update", ""); return(result); } catch (Exception e) { _loggingManager.Log("Bracket Update", ""); throw e; } }
public IActionResult UpdateBracketStanding(int bracketID, BracketCompetitor bracketCompetitor) { try { return(Ok(TournamentBracketManager.UpdateBracketStanding(bracketID, bracketCompetitor))); } catch (ArgumentException) { return(StatusCode(StatusCodes.Status404NotFound)); } catch { return(StatusCode(StatusCodes.Status500InternalServerError)); } }
public List <BracketCompetitor> GetCompetitorListByBracketID(int bracketID) { try { var DB = new Database(); using (MySqlConnection conn = new MySqlConnection(DB.GetConnString())) { string selectQuery2 = string.Format("SELECT " + "bracket_player_info.bracketID, " + "bracket_player_info.score, " + "bracket_player_info.placement, " + "bracket_player_info.hashedUserID," + "gamer_info.gamerTag " + "FROM " + "((bracket_player_info INNER JOIN gamer_info ON bracket_player_info.hashedUserID = gamer_info.hashedUserID)) " + "WHERE bracket_player_info.bracketID='{0}'", bracketID); MySqlCommand selectCmd = new MySqlCommand(selectQuery2, conn); conn.Open(); using (MySqlDataReader reader = selectCmd.ExecuteReader()) { List <BracketCompetitor> listBracketCompetitors = new List <BracketCompetitor>(); while (reader.Read()) { BracketCompetitor bracketPlayer = new BracketCompetitor(bracketID, reader.GetInt32("score"), reader.GetInt32("placement"), reader.GetString("gamerTag"), reader.GetString("hashedUserID")); listBracketCompetitors.Add(bracketPlayer); } conn.Close(); return(listBracketCompetitors); } } } catch (Exception e) { return(null); } }
public bool UpdateBracketStanding(int bracketID, BracketCompetitor bracketCompetitor) { return(_tournamentBracketDataAccess.UpdateBracketStanding(bracketID, bracketCompetitor)); }