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