public MainWindow() { InitializeComponent(); FilePath = new DBProcessing(_myConnectionString); var teams = FilePath.GetTeams(); var players = FilePath.GetBasketballPlayers(); var image = new MenuImagesProcessing(); foreach (var item in teams) { item.BasketballPlayers = players; } var basketballPlayer = new BasketballPlayers(); var team = new Teams(); foreach (var item in players) { basketballPlayer.CheckPlayerPicture(item); } foreach (var item in teams) { team.CheckTeamPicture(item); } foreach (var item in teams) { item.BasketballPlayers = basketballPlayer.RelatePlayerToATeam(item, players);; } _teamsList = teams; _teamsToSort = teams; connection = new MySqlConnection(_myConnectionString); _positions = FilePath.GetPositions(); //_menuImages = image.GetImagesFromFile(); }
private void UpdateInterface() { _toCompleteEvent = true; var teams = FilePath.GetTeams(); var players = FilePath.GetBasketballPlayers(); foreach (var item in players) { item.CheckPlayerPicture(item); } foreach (var item in teams) { item.BasketballPlayers = players; } var basketballPlayer = new BasketballPlayers(); foreach (var item in teams) { item.BasketballPlayers = basketballPlayer.RelatePlayerToATeam(item, players);; } lvTeamsOutput.ItemsSource = null; lvTeamsOutput.ItemsSource = teams; _toCompleteEvent = false; }
public void ImportTeamDataToDB() { BindingList <Teams> teamsToImport = _storage.GetTeamFromFIle(); _connection.Open(); var currentTeams = DBPath.GetTeams(); var refer = new MainWindow(); for (int i = teamsToImport.Count - 1; i != -1; i--) { foreach (var item1 in currentTeams) { if (teamsToImport[i].TeamName == item1.TeamName && teamsToImport[i].City == item1.City) { teamsToImport.Remove(teamsToImport[i]); break; } } } DBPath.Append(teamsToImport.ToArray()); refer.ToLog($"{teamsToImport.Count} teams were inserted into database", MessageBoxImage.Information); _connection.Close(); }