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