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