public void initialize(TournamentEntry tournamentEntry, bool stripedRow, int contributorRank) { if (this.BgImage != null) { this.BgImage.color = !stripedRow ? ConfigUi.LIST_CELL_REGULAR_COLOR : ConfigUi.LIST_CELL_STRIPED_COLOR; } this.m_tournamentEntry = tournamentEntry; this.NameText.text = tournamentEntry.PlayerDisplayName; if (this.TopContributorImage != null) { if (contributorRank == 1) { this.TopContributorImage.enabled = true; this.TopContributorImage.sprite = PlayerView.Binder.SpriteResources.getSprite("Menu", "icon_mini_contributor_gold"); } else if (contributorRank == 2) { this.TopContributorImage.enabled = true; this.TopContributorImage.sprite = PlayerView.Binder.SpriteResources.getSprite("Menu", "icon_mini_contributor_silver"); } else if (contributorRank == 3) { this.TopContributorImage.enabled = true; this.TopContributorImage.sprite = PlayerView.Binder.SpriteResources.getSprite("Menu", "icon_mini_contributor_bronze"); } else { this.TopContributorImage.enabled = false; } } this.refresh(); }
private void buttonGeneratePairingSE_Click(object sender, EventArgs e) { listBoxPairingSE.Items.Clear(); List <Teams> listTeam = TournamentEntry.ReadTeam(FormMenu.selectedTournament, ""); Random rnd = new Random(); for (int i = listTeam.Count() - 1; i > 0; i--) { Teams temp = listTeam[i]; int index = rnd.Next(0, i + 1); listTeam[i] = listTeam[index]; listTeam[index] = temp; } var teamstack = new Stack <Teams>(listTeam); while (teamstack.Count != 0 && teamstack.Count() != 1) { listBoxPairingSE.Items.Add(teamstack.Pop().Name + " vs " + teamstack.Pop().Name); } if (teamstack.Count == 1) { listBoxPairingSE.Items.Add(teamstack.Pop().Name + " vs bye"); } }
private void FormEditPlayer_Load(object sender, EventArgs e) { listTeams = TournamentEntry.ReadTeam(FormMenu.selectedTournament, ""); comboBoxTeam.DataSource = listTeams; comboBoxTeam.DisplayMember = "Name"; comboBoxTeam.DropDownStyle = ComboBoxStyle.DropDownList; Players selectedPlayer = Players.SelectPlayer(selectedPlayerId); int selectedTeamId = selectedPlayer.Team.Id; string teamName = ""; foreach (Teams t in listTeams) { if (t.Id == selectedTeamId) { teamName = t.Name; } } textBoxPlayerId.Text = selectedPlayer.Id.ToString(); textBoxPlayerName.Text = selectedPlayer.Name; textBoxPlayerEmail.Text = selectedPlayer.Email; comboBoxTeam.SelectedIndex = comboBoxTeam.FindStringExact(teamName); }
public void FormPlayerTeam_Load(object sender, EventArgs e) { // Get data from db teamList = TournamentEntry.ReadTeam(FormMenu.selectedTournament); // Show data to datagridteams ShowDataGridTeams(); // Get player data from db playerList = TournamentEntry.ReadPlayer(FormMenu.selectedTournament); // Format datagridplayer FormatDataGridPlayers(); // Show data to datagridplayer ShowDataGridPlayers(); if (FormMenu.buttonPlayerClicked == true) { tabControlTeam.SelectedIndex = 1; FormMenu.buttonPlayerClicked = false; } else { tabControlTeam.SelectedIndex = 0; } }
private void FormPairing_Load(object sender, EventArgs e) { listTeam = TournamentEntry.ReadTeam(FormMenu.selectedTournament); listPair = Pairing.GeneratePairing(listTeam); FormatDataGrid(); AddPairToDataGrid(); }
private void textBoxSearchPlayer_TextChanged(object sender, EventArgs e) { string criteria = textBoxSearchPlayer.Text; playerList = TournamentEntry.ReadPlayer(FormMenu.selectedTournament, criteria); ShowDataGridPlayers(); }
public async Task DeleteTournamentPlayer(int tournamentEntryId) { //var entry = _dbContext.TournamentEntries.Select(e => e.TournamentId == tournamentId && e.PlayerId == playerId); var entry = new TournamentEntry() { Id = tournamentEntryId }; _dbContext.TournamentEntries.Remove(entry); await _dbContext.SaveChangesAsync(); }
private void TextBoxSearchTeam_TextChanged(object sender, EventArgs e) { // Get texboxsearch string teamSearchCriteria = textBoxSearchTeam.Text; // Team search query with criteria teamList = TournamentEntry.ReadTeam(FormMenu.selectedTournament, teamSearchCriteria); // Refresh datagridteam ShowDataGridTeams(); }
private void TextBoxSearchPlayer_TextChanged(object sender, EventArgs e) { // Get texboxsearch string playerSearchCriteria = textBoxSearchPlayer.Text; // Player search query with criteria playerList = TournamentEntry.ReadPlayer(FormMenu.selectedTournament, playerSearchCriteria); // Refresh datagridplayer ShowDataGridPlayers(); }
private void FormDeletePlayer_Load(object sender, EventArgs e) { listTeams = TournamentEntry.ReadTeam(FormMenu.selectedTournament, ""); Players selectedPlayer = Players.SelectPlayer(selectedPlayerId); textBoxPlayerId.Text = selectedPlayer.Id.ToString(); textBoxPlayerName.Text = selectedPlayer.Name; textBoxPlayerEmail.Text = selectedPlayer.Email; comboBoxTeam.Text = selectedPlayer.Team.Name; }
private void textBoxSearchTeam_TextChanged(object sender, EventArgs e) { teamList = TournamentEntry.ReadTeam(FormMenu.selectedTournament, textBoxSearchTeam.Text); if (teamList.Count > 0) { dataGridViewTeam.DataSource = teamList; } else { dataGridViewTeam.DataSource = null; } }
private void FormAddPlayer_Load(object sender, EventArgs e) { listteam = TournamentEntry.ReadTeam(FormMenu.selectedTournament, ""); comboBoxTeam.DataSource = listteam; comboBoxTeam.DisplayMember = "Name"; comboBoxTeam.DropDownStyle = ComboBoxStyle.DropDownList; string newCode = Players.GenerateCode(); textBoxPlayerId.Text = newCode; textBoxPlayerId.Enabled = false; textBoxPlayerName.Focus(); }
private void textBoxPrizePercentage_TextChanged(object sender, EventArgs e) { if (textBoxPrizePercentage.Text != "") { decimal prize = decimal.Parse(textBoxPrizePercentage.Text) * TournamentEntry.CalculateParticipant(FormMenu.selectedTournament) * FormMenu.selectedTournament.Entryfee; textBoxPriceAmount.Text = prize.ToString(); if (double.Parse(textBoxPrizePercentage.Text) > 1) { MessageBox.Show("Please enter a fraction (value from 0-1)"); textBoxPrizePercentage.Clear(); } } }
private void FormDeletePlayer_Load(object sender, EventArgs e) { // Get team for combobox listTeams = TournamentEntry.ReadTeam(FormMenu.selectedTournament, ""); // Get selected player to be deleted Players selectedPlayer = Players.SelectPlayer(selectedPlayerId); // Show selected player to be deleted's data to form textBoxPlayerId.Text = selectedPlayer.Id.ToString(); textBoxPlayerName.Text = selectedPlayer.Name; textBoxPlayerEmail.Text = selectedPlayer.Email; comboBoxTeam.Text = selectedPlayer.Team.Name; }
private void FormEditMatchup_Load(object sender, EventArgs e) { listTeam1 = TournamentEntry.ReadTeam(FormMenu.selectedTournament, ""); listTeam2 = TournamentEntry.ReadTeam(FormMenu.selectedTournament); comboBoxTeam1.DataSource = listTeam1; comboBoxTeam2.DataSource = listTeam2; comboBoxTeam1.DisplayMember = "Name"; comboBoxTeam2.DisplayMember = "Name"; comboBoxTeam1.DropDownStyle = ComboBoxStyle.DropDownList; comboBoxTeam1.DropDownStyle = ComboBoxStyle.DropDownList; // Show Data textBoxId.Text = FormMatch.selectedMatchup.Id; textBoxRound.Text = FormMatch.selectedMatchup.Round.ToString(); dateTimePickerMatchup.Value = FormMatch.selectedMatchup.Date; int team1Id = FormMatch.selectedMatchupEntry1.Team.Id; string team1Name = ""; double team1Score = 0; foreach (Teams team in listTeam1) { if (team.Id == team1Id) { team1Name = team.Name; team1Score = team.TotalScore; } } comboBoxTeam1.SelectedIndex = comboBoxTeam1.FindStringExact(team1Name); textBoxScore1.Text = FormMatch.selectedMatchupEntry1.Score.ToString(); int team2Id = FormMatch.selectedMatchupEntry2.Team.Id; string team2Name = ""; double team2Score = 0; foreach (Teams team in listTeam2) { if (team.Id == team2Id) { team2Name = team.Name; team2Score = team.TotalScore; } } comboBoxTeam2.SelectedIndex = comboBoxTeam2.FindStringExact(team2Name); textBoxScore2.Text = FormMatch.selectedMatchupEntry2.Score.ToString(); }
/// <summary> /// Adds points to a user in a tournament. If this is their first catch /// of the tournament, it will add an entry for them as well. /// </summary> /// <param name="userId">The user to update.</param> /// <param name="points">The amount of points to add.</param> /// <returns>The user's current point total.</returns> public int AddTournamentPoints(string userId, int points) { if (CurrentTournament != null) { var entry = CurrentTournament.Entries.Where(x => x.UserId.Equals(userId, StringComparison.OrdinalIgnoreCase)).FirstOrDefault(); if (entry == null) { entry = new TournamentEntry(userId, 0); CurrentTournament.Entries.Add(entry); } entry.Points += points; return(entry.Points); } return(-1); }
public ActionResult Join(TournamentJoinViewModel viewmodel) { var userId = User.Identity.GetUserId(); var entry = new TournamentEntry { TournamentId = viewmodel.Tournament.TournamentId, PlayerId = userId, PlayerBuyIn = viewmodel.PlayerBuyIn }; context.TournamentEntries.Add(entry); context.SaveChanges(); return(RedirectToAction("Index", "Home")); }
private void button1_Click(object sender, EventArgs e) { listBoxPairingRR.Items.Clear(); List <Teams> listTeam = TournamentEntry.ReadTeam(FormMenu.selectedTournament, ""); int listteamcount = listTeam.Count(); int iterasi = listteamcount - 1; for (int i = 0; i <= iterasi; i++) { for (int j = i + 1; j <= listteamcount - 1; j++) { listBoxPairingRR.Items.Add(listTeam[i].Name + " vs " + listTeam[j].Name); } } }
private void FormAddMatchup_Load(object sender, EventArgs e) { listTeam1 = TournamentEntry.ReadTeam(FormMenu.selectedTournament, ""); listTeam2 = TournamentEntry.ReadTeam(FormMenu.selectedTournament); comboBoxTeam1.DataSource = listTeam1; comboBoxTeam2.DataSource = listTeam2; comboBoxTeam1.DisplayMember = "Name"; comboBoxTeam2.DisplayMember = "Name"; comboBoxTeam1.DropDownStyle = ComboBoxStyle.DropDownList; comboBoxTeam1.DropDownStyle = ComboBoxStyle.DropDownList; string newCode = Matchups.GenerateId(); textBoxId.Text = newCode; }
public void FormPlayerTeam_Load(object sender, EventArgs e) { //Team teamList = TournamentEntry.ReadTeam(FormMenu.selectedTournament, ""); if (teamList.Count > 0) { dataGridViewTeam.DataSource = teamList; } else { dataGridViewTeam.DataSource = null; } //Player FormatDataGridPlayers(); playerList = TournamentEntry.ReadPlayer(FormMenu.selectedTournament, ""); ShowDataGridPlayers(); }
public void initializeWithExternalUpgrades(List <TournamentEntry> tournamentEntries) { this.clear(); this.addPlayerUpgradesToQuickLookup(false); for (int i = 0; i < tournamentEntries.Count; i++) { TournamentEntry entry = tournamentEntries[i]; if (entry.PlayerId != this.Player._id) { foreach (KeyValuePair <string, TournamentUpgradeInstance> pair in entry.NormalUpgrades) { if (!this.ExternalNormalUpgrades.ContainsKey(pair.Key)) { this.ExternalNormalUpgrades.Add(pair.Key, new TournamentUpgradeInstance(pair.Value)); } else { TournamentUpgradeInstance local1 = this.ExternalNormalUpgrades[pair.Key]; local1.TotalCount += pair.Value.TotalCount; TournamentUpgradeInstance local2 = this.ExternalNormalUpgrades[pair.Key]; local2.TotalModifier += pair.Value.TotalModifier; } } foreach (KeyValuePair <string, TournamentUpgradeInstance> pair2 in entry.EpicUpgrades) { if (!this.ExternalEpicUpgrades.ContainsKey(pair2.Key)) { this.ExternalEpicUpgrades.Add(pair2.Key, new TournamentUpgradeInstance(pair2.Value)); } else { TournamentUpgradeInstance local3 = this.ExternalEpicUpgrades[pair2.Key]; local3.TotalCount += pair2.Value.TotalCount; TournamentUpgradeInstance local4 = this.ExternalEpicUpgrades[pair2.Key]; local4.TotalModifier += pair2.Value.TotalModifier; } } } } this.addExternalUpgradesToQuickLookup(false); base.refreshQuickLookup(); }
private void FormAddPlayer_Load(object sender, EventArgs e) { // Get data for teamlist listteam = TournamentEntry.ReadTeam(FormMenu.selectedTournament, ""); // Show available team on combobox comboBoxTeam.DataSource = listteam; comboBoxTeam.DisplayMember = "Name"; comboBoxTeam.DropDownStyle = ComboBoxStyle.DropDownList; // Generate playerid string newCode = Players.GenerateId(); // Fill generated playerid on form textBoxPlayerId.Text = newCode; // Disable editing player id texbox textBoxPlayerId.Enabled = false; // Focus player name textbox textBoxPlayerName.Focus(); }
public static void Initialize(AtaTennisContext context) { context.Database.EnsureCreated(); // Look for any students. if (context.Players.Any() && context.Tournaments.Any() && context.Users.Any() && context.TournamentEntries.Any()) { return; // DB has been seeded } var players = new Player[] { new Player { BirthDate = new DateTime(1988, 5, 5), Name = "Peter", Surname = "Sveter", Points = 450, Backhand = Backhand.oneHanded, FavouritePlayer = "Roger", Forehand = Forehand.rightHanded, Height = 175, Weight = 70, Racquet = "Wilson Blade", Residence = "Spisska Nova Ves", Surface = SurfaceType.clay }, new Player { BirthDate = new DateTime(1994, 3, 8), Name = "Jano", Surname = "Slany", Points = 50, Backhand = Backhand.twoHanded, FavouritePlayer = "Delpo", Forehand = Forehand.rightHanded, Height = 185, Weight = 78, Racquet = "Babolat", Residence = "Nitra", Surface = SurfaceType.grass }, new Player { BirthDate = new DateTime(1978, 4, 7), Name = "Miso", Surname = "Sef", Points = 220, Backhand = Backhand.twoHanded, FavouritePlayer = "Rafa", Forehand = Forehand.rightHanded, Height = 181, Weight = 82, Racquet = "Babolat", Residence = "Blava", Surface = SurfaceType.grass }, new Player { BirthDate = new DateTime(1969, 2, 2), Name = "Jozo", Surname = "Suly", Points = 185, Backhand = Backhand.twoHanded, FavouritePlayer = "Delpo", Forehand = Forehand.rightHanded, Height = 185, Weight = 96, Racquet = "Babolat", Residence = "Nitra", Surface = SurfaceType.grass }, }; foreach (Player p in players) { context.Players.Add(p); } if (context.Tournaments.Any()) { return; } var tournaments = new Tournament[] { new Tournament { Category = TournamentCategory.singles, BallsType = BallsType.slazenger, Description = "wimbledon summer challange dufajme za pekneho letneho pocasia...", DrawType = DrawType.playoff, Name = "Wimbledon Challange", Place = "Kopčany", PlayingSystem = PlayingSystem.prince, TournamentType = TournamentType.challangerSpecial, StartTime = new DateTime(2019, 7, 12), Surface = SurfaceType.grass }, new Tournament { Category = TournamentCategory.singles, BallsType = BallsType.dunlop, Description = "Areal nitrianskeho futbaloveho stadiona", DrawType = DrawType.playoff, Name = "Temprim CUP", Place = "Nitra", PlayingSystem = PlayingSystem.prince, TournamentType = TournamentType.challanger, StartTime = new DateTime(2019, 1, 19), Surface = SurfaceType.clay }, new Tournament { Category = TournamentCategory.singles, BallsType = BallsType.slazenger, Description = "wimbledon summer challange dufajme za pekneho letneho pocasia...", DrawType = DrawType.playoff, Name = "Senica OPEN", Place = "Senica", PlayingSystem = PlayingSystem.prince, TournamentType = TournamentType.ata, StartTime = new DateTime(2019, 8, 2), EndTime = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 3), Surface = SurfaceType.clay }, new Tournament { Category = TournamentCategory.singles, BallsType = BallsType.dunlop, Description = "wimbledon summer challange dufajme za pekneho letneho pocasia...", DrawType = DrawType.playoff, Name = "Summer Cup Open", Place = "Břeclav", PlayingSystem = PlayingSystem.prince, TournamentType = TournamentType.challanger, StartTime = new DateTime(2019, 9, 12), EndTime = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 13), Surface = SurfaceType.clay } }; foreach (var tournament in tournaments) { context.Tournaments.Add(tournament); } if (context.Users.Any()) { return; } var admin = new User { Username = "******", Password = "******", Email = "" }; context.Users.Add(admin); var tournamentEntries = new TournamentEntry[] { new TournamentEntry { PlayerId = 1, TournamentId = 1 }, new TournamentEntry { PlayerId = 2, TournamentId = 1 }, new TournamentEntry { PlayerId = 4, TournamentId = 1 } }; foreach (var tournamentEntry in tournamentEntries) { context.TournamentEntries.Add(tournamentEntry); } context.SaveChanges(); }
public static string GetTournamentInfo(string token, dynamic data, bool isActive) { long userID = GetIDfromToken(token); if (userID == -1) { return("-1"); } using var conSelect = new NpgsqlConnection(ConnectionString); conSelect.Open(); string sqlSelect = $"SELECT DISTINCT tournamentID FROM SEB_History WHERE userid = {userID}"; using var cmdSelect = new NpgsqlCommand(sqlSelect, conSelect); using var reader = cmdSelect.ExecuteReader(); var TournamentInfoList = new List <TournamentInfo>(); while (reader.Read()) { int tempTournamentID = reader.GetInt32(reader.GetOrdinal("tournamentID")); using var conSelect2 = new NpgsqlConnection(ConnectionString); conSelect2.Open(); string sqlSelect2 = $"SELECT username, SUM(count) as count, SUM(duration) as duration FROM SEB_History INNER JOIN SEB_Users ON SEB_History.userID = SEB_Users.userID WHERE tournamentID = {tempTournamentID} GROUP BY username"; using var cmdSelect2 = new NpgsqlCommand(sqlSelect2, conSelect2); using var reader2 = cmdSelect2.ExecuteReader(); var TournamentEntryList = new List <TournamentEntry>(); while (reader2.Read()) { string tempUsername = reader2.GetString(reader2.GetOrdinal("username")); int tempCount = reader2.GetInt32(reader2.GetOrdinal("count")); int tempDuration = reader2.GetInt32(reader2.GetOrdinal("duration")); var tempObject = new TournamentEntry(tempUsername, tempCount, tempDuration); TournamentEntryList.Add(tempObject); } var tempObject2 = new TournamentInfo(TournamentEntryList, false, tempTournamentID); TournamentInfoList.Add(tempObject2); conSelect2.Close(); } conSelect.Close(); if (isActive) { TournamentInfoList.LastOrDefault().isActive = true; } return(JsonConvert.SerializeObject(TournamentInfoList)); }