/// <summary> /// Inserts gamer into bracket /// </summary> /// /// <param name="gamer"> /// Gamer object to be inserted /// </param> /// /// <param name="bracketID"> /// BracketID associated with bracket, where the gamer will be inserted /// </param> /// /// <returns> /// BracketPlayer object if insertion successful; null if not /// </returns> public BracketPlayer InsertGamerToBracket(GamerInfo gamer, BracketInfo bracket) { try { DatabaseQuery databaseQuery = new DatabaseQuery(); TournamentBracketDatabaseQuery tournamentBracketDatabaseQuery = new TournamentBracketDatabaseQuery(); GamerInfo tempGamer = databaseQuery.GetGamerInfo(gamer); BracketPlayer bracketPlayer = new BracketPlayer(); bracketPlayer.BracketID = bracket.BracketID; bracketPlayer.HashedUserID = tempGamer.HashedUserID; bracketPlayer.StatusCode = 1; bracketPlayer.Claim = null; bracketPlayer.Reason = null; bool insertionResult = tournamentBracketDatabaseQuery.InsertBracketPlayer(bracketPlayer); if (insertionResult) { tournamentBracketDatabaseQuery.UpdateBracketPlayerCount(bracket.BracketID, 1); return(bracketPlayer); } return(null); } catch (Exception e) { Console.WriteLine(e); return(null); } }
public List <BracketCompetitor> GetCompetitorListByBracketID(int bracketID) { TournamentBracketDatabaseQuery tournamentBracketDatabaseQuery = new TournamentBracketDatabaseQuery(); var listOfCompetitors = tournamentBracketDatabaseQuery.GetCompetitorListByBracketID(bracketID); return(listOfCompetitors); }
public bool UpdateBracketStanding(int bracketID, BracketCompetitor bracketCompetitor) { TournamentBracketDatabaseQuery tournamentBracketDatabaseQuery = new TournamentBracketDatabaseQuery(); bool result = tournamentBracketDatabaseQuery.UpdateBracketStandings(bracketID, bracketCompetitor); return(result); }
/// <summary> /// Unregisters gamer from bracket /// </summary> /// /// <param name="systemID"> /// System ID associated with user /// </param> /// /// <param name="bracketID"> /// Bracket ID associated with bracket /// </param> /// /// <returns> /// Boolean indicated success or fail in unregistration /// </returns> public bool UnregisterGamerFromBracket(int systemID, int bracketID) { /* * Status codes * * 2 - bracket is in progress * 1 - bracket not in progress and has already completed * 0 - bracket not in progress and has not begun */ try { DatabaseQuery databaseQuery = new DatabaseQuery(); TournamentBracketDatabaseQuery tournamentBracketDatabaseQuery = new TournamentBracketDatabaseQuery(); string hashedUserID = databaseQuery.GetHashedUserID(systemID); BracketInfo bracket = tournamentBracketDatabaseQuery.GetBracketInfo(bracketID); if (bracket.StatusCode == 2) { return(tournamentBracketDatabaseQuery.DisqualifyGamerFromBracket(bracketID, hashedUserID)); } else if (bracket.StatusCode == 0) { bool removeResult = tournamentBracketDatabaseQuery.RemoveGamerFromBracket(hashedUserID, bracketID); bool updateResult = tournamentBracketDatabaseQuery.UpdateBracketPlayerCount(bracketID, 0); if (removeResult && updateResult) { return(true); } } return(false); } catch { return(false); } }
/// <summary> /// Gets bracket player info by user's email /// </summary> /// /// <param name="email"> /// Email associated with user /// </param> /// /// <returns> /// List of user's BracketPlayer info /// </returns> public List <BracketPlayer> GetBracketPlayerInfo(string email) { DatabaseQuery databaseQuery = new DatabaseQuery(); TournamentBracketDatabaseQuery tournamentBracketDatabaseQuery = new TournamentBracketDatabaseQuery(); User user = databaseQuery.GetUserInfo(email); if (user != null) { string hashedUserID = databaseQuery.GetHashedUserID(user.SystemID); List <BracketPlayer> bracketPlayers = tournamentBracketDatabaseQuery.GetBracketPlayerInfo(hashedUserID); return(bracketPlayers); } return(null); }
/// <summary> /// Gets a specific bracket by its ID /// </summary> /// /// <param name="bracketID"> /// Bracket ID to be used to fetch bracket objectr /// </param> /// /// <returns> /// Bracket object associated with bracket ID /// </returns> public BracketInfo GetBracketByID(int bracketID) { bool bracketStatus = CheckBracketExistenceByID(bracketID); if (!bracketStatus) { return(null); } else { TournamentBracketDatabaseQuery tournamentBracketDatabaseQuery = new TournamentBracketDatabaseQuery(); BracketInfo bracket = tournamentBracketDatabaseQuery.GetBracketInfo(bracketID); return(bracket); } }
/// <summary> /// Returns all brackets stored in the database /// </summary> /// /// <returns> /// All brackets stored in the database /// </returns> public List <BracketInfo> GetAllBrackets() { TournamentBracketDatabaseQuery tournamentBracketDatabaseQuery = new TournamentBracketDatabaseQuery(); return(tournamentBracketDatabaseQuery.GetAllBrackets()); }