private void btnConfirmAddingPlayer_Click(object sender, RoutedEventArgs e)
{
ClearTeamsInterface();
var selectedTeam = cbToEditOrAddTeams.SelectedItem;
var selectedPosition = cbToEditOrAddPositions.SelectedItem;
Positions position = selectedPosition as Positions;
Teams team = selectedTeam as Teams;
BasketballPlayers player1 = new BasketballPlayers();
GetPlayerFromForm(player1, team, position);
var errMsg = CombinedPlayerCheck(player1);
player1.CheckPlayerPicture(player1);
if (!string.IsNullOrEmpty(errMsg))
{
ToLog(errMsg, MessageBoxImage.Error);
UpdateInterface();
return;
}
FilePath.Append(player1);
UpdateInterface();
ToLog($"{player1.Name} was successfully added", MessageBoxImage.Information);
ClearPlayersInterface();
}
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();
}
public override BindingList <BasketballPlayers> GetBasketballPlayers()
{
_mysqlDataAdapter = new MySqlDataAdapter("SELECT id, picture, name, age, career_age, height, weight, (SELECT team_name FROM teams WHERE ID = id_team) AS team," +
" (SELECT position FROM positions WHERE ID = id_position) AS position FROM basketballplayers", sqlConnection);
BindingList <BasketballPlayers> playersToReturn = new BindingList <BasketballPlayers>();
_dataset = new DataSet();
_mysqlDataAdapter.Fill(_dataset);
DataTable dt = _dataset.Tables[0];
foreach (DataRow item in dt.Rows)
{
BasketballPlayers player = new BasketballPlayers();
player.ID = Convert.ToInt32(item[0]);
player.Picture = Convert.ToString(item[1]);
player.Name = Convert.ToString(item[2]);
player.Age = Convert.ToInt32(item[3]);
player.Career_age = Convert.ToInt32(item[4]);
player.Height = Convert.ToDouble(item[5]);
player.Weight = Convert.ToInt32(item[6]);
player.Current_team = Convert.ToString(item[7]);
player.Position = Convert.ToString(item[8]);
playersToReturn.Add(player);
}
return(playersToReturn);
}
private void btnSortResults_Click(object sender, RoutedEventArgs e)
{
_toSort = true;
_toCompleteEvent = true;
var team = lvTeamsOutput.SelectedItem as Teams;
var players = team.BasketballPlayers;
BasketballPlayers player = new BasketballPlayers();
Positions temp = new Positions();
if (cbSortPosition.SelectedItem != null)
{
temp = cbSortPosition.SelectedItem as Positions;
}
var pos = temp.Position;
int toSort = 0;
if (!string.IsNullOrEmpty(tbSortByAge.Text))
{
toSort = Convert.ToInt32(tbSortByAge.Text);
}
players = player.SortPlayers(players, pos, tbSortByName.Text, toSort);
lvPlayers.ItemsSource = null;
lvPlayers.ItemsSource = players;
_toCompleteEvent = false;
}
private void lvPlayers_MouseDoubleClickEditing(object sender, MouseButtonEventArgs e)
{
ClearTeamsInterface();
var selectedPlayer = lvPlayers.SelectedItem;
BasketballPlayers player = selectedPlayer as BasketballPlayers;
tbGetAge.Text = player.Age.ToString();
tbGetCareerAge.Text = player.Career_age.ToString();
tbGetHeight.Text = player.Height.ToString();
tbGetWeight.Text = player.Weight.ToString();
tbGetName.Text = player.Name;
tbToShowPlayerPictureFilePath.Text = player.Picture;
_playerIMG = player.Picture;
int teamNameIndex = 0;
int positionIndex = 0;
for (int i = 0; i < _teamsList.Count; i++)
{
if (player.Current_team == _teamsList[i].TeamName)
{
teamNameIndex = i;
}
}
for (int i = 0; i < _positions.Count; i++)
{
if (player.Position == _positions[i].Position)
{
positionIndex = i;
}
}
cbToEditOrAddPositions.SelectedIndex = positionIndex;
cbToEditOrAddTeams.SelectedIndex = teamNameIndex;
gridEditingPlayers.Visibility = Visibility.Visible;
gridBtnsToConfirmEditingPlayers.Visibility = Visibility.Visible;
}
public XmlElement GetXMLPlayer(BasketballPlayers player, XmlDocument xdoc)
{
XmlElement xmlPlayer = xdoc.CreateElement("player");
XmlElement positionElem = xdoc.CreateElement("position");
xmlPlayer.AppendChild(positionElem);
XmlElement nameElem = xdoc.CreateElement("name");
xmlPlayer.AppendChild(nameElem);
XmlElement teamElem = xdoc.CreateElement("current_team");
xmlPlayer.AppendChild(teamElem);
XmlElement ageElem = xdoc.CreateElement("age");
xmlPlayer.AppendChild(ageElem);
XmlElement careerElem = xdoc.CreateElement("career_age");
xmlPlayer.AppendChild(careerElem);
XmlElement heightElem = xdoc.CreateElement("height");
xmlPlayer.AppendChild(heightElem);
XmlElement weightElem = xdoc.CreateElement("weight");
xmlPlayer.AppendChild(weightElem);
XmlElement pictureElem = xdoc.CreateElement("picture");
xmlPlayer.AppendChild(pictureElem);
XmlText positionText = xdoc.CreateTextNode(player.Position);
XmlText nameText = xdoc.CreateTextNode(player.Name);
XmlText teamText = xdoc.CreateTextNode(player.Current_team);
XmlText ageText = xdoc.CreateTextNode(player.Age.ToString());
XmlText careerText = xdoc.CreateTextNode(player.Career_age.ToString());
XmlText heightText = xdoc.CreateTextNode(player.Height.ToString());
XmlText weightText = xdoc.CreateTextNode(player.Weight.ToString());
XmlText pictureText = xdoc.CreateTextNode(player.Picture);
positionElem.AppendChild(positionText);
nameElem.AppendChild(nameText);
teamElem.AppendChild(teamText);
ageElem.AppendChild(ageText);
careerElem.AppendChild(careerText);
heightElem.AppendChild(heightText);
weightElem.AppendChild(weightText);
pictureElem.AppendChild(pictureText);
return(xmlPlayer);
}
//private void UAErrorCallback(Control control)
//{
// control.BorderBrush = Brushes.Red;
// control.Focus();
//}
private string CombinedPlayerCheck(BasketballPlayers player)
{
string check = null;
if (string.IsNullOrEmpty(player.Name))
{
//UAErrorCallback(tbGetName);
check = "Enter NAME, please!";
return(check);
}
if (string.IsNullOrEmpty(player.Position))
{
check = "Select positon, please!";
return(check);
}
if (string.IsNullOrEmpty(player.Current_team))
{
check = "Select team, please!";
return(check);
}
if (string.IsNullOrEmpty(tbGetAge.Text))
{
check = "Enter the age, please!";
return(check);
}
if (string.IsNullOrEmpty(tbGetCareerAge.Text))
{
check = "Enter the career age, please!";
return(check);
}
if (string.IsNullOrEmpty(tbGetHeight.Text))
{
check = "Enter height, please!";
return(check);
}
if (string.IsNullOrEmpty(tbGetWeight.Text))
{
check = "Select weight, please!";
return(check);
}
if (player.Age == -1 || player.Career_age == -1 || player.Height == -1 || player.Weight == -1)
{
check = "Please, enter the number";
ClearPlayersInterface();
return(check);
}
if (player.PlayerAdequacyCheck())
{
check = "The parameters you've entered can not exist";
ClearPlayersInterface();
return(check);
}
return(check);
}
private void btnConfirmDeletingPlayer_Click(object sender, RoutedEventArgs e)
{
var player = lvPlayers.SelectedValue;
BasketballPlayers player1 = player as BasketballPlayers;
string message = player1.Name;
FilePath.Delete(player1);
UpdateInterface();
ToLog($"{message} was successfully removed", MessageBoxImage.Information);
ClearPlayersInterface();
}
public override BindingList <BasketballPlayers> GetPlayersFromFile()
{
XmlDocument xdoc = new XmlDocument();
xdoc.Load(FileProcessingPath);
XmlElement root = xdoc.DocumentElement;
BindingList <BasketballPlayers> playerToReturn = new BindingList <BasketballPlayers>();
foreach (XmlNode item in root)
{
BasketballPlayers player = new BasketballPlayers();
foreach (XmlNode node in item.ChildNodes)
{
if (node.Name == "name")
{
player.Name = node.InnerText;
}
if (node.Name == "position")
{
player.Position = node.InnerText;
}
if (node.Name == "picture")
{
player.Picture = node.InnerText;
}
if (node.Name == "current_team")
{
player.Current_team = node.InnerText;
}
if (node.Name == "age")
{
player.Age = Convert.ToInt32(node.InnerText);
}
if (node.Name == "career_age")
{
player.Career_age = Convert.ToInt32(node.InnerText);
}
if (node.Name == "height")
{
player.Height = Convert.ToDouble(node.InnerText);
}
if (node.Name == "weight")
{
player.Weight = Convert.ToInt32(node.InnerText);
}
}
playerToReturn.Add(player);
}
return(playerToReturn);
}
public int GetPlayersPositionID(BasketballPlayers player)
{
BindingList <Positions> currentPositions = GetPositions();
int id_position = 0;
foreach (var position in currentPositions)
{
if (position.Position == player.Position)
{
id_position = position.ID;
return(id_position);
}
}
return(id_position);
}
public int GetPlayersTeamID(BasketballPlayers player)
{
BindingList <Teams> currentTeams = GetTeams();
int id_team = 0;
foreach (var currentTeam in currentTeams)
{
if (currentTeam.TeamName == player.Current_team)
{
id_team = currentTeam.ID;
return(id_team);
}
}
return(id_team);
}
public override BindingList <BasketballPlayers> GetPlayersFromFile()
{
BindingList <BasketballPlayers> playersToOutput = new BindingList <BasketballPlayers>();
XSSFWorkbook workbook;
using (FileStream fs = new FileStream(FileProcessingPath, FileMode.Open, FileAccess.Read))
{
workbook = new XSSFWorkbook(fs);
}
ISheet sheet = workbook.GetSheet("Sheet0");
for (int row = 1; row <= sheet.LastRowNum; row++)
{
BasketballPlayers player = new BasketballPlayers();
if (sheet.GetRow(row) != null)
{
//if (sheet.GetRow(row).GetCell(1).ToString() != null && sheet.GetRow(row).GetCell(2).ToString() != null && sheet.GetRow(row).GetCell(7).ToString() != null &&
// sheet.GetRow(row).GetCell(3).ToString() != null && sheet.GetRow(row).GetCell(5).ToString() != null && sheet.GetRow(row).GetCell(6).ToString() != null &&
// sheet.GetRow(row).GetCell(4).ToString() != null && sheet.GetRow(row).GetCell(0).ToString() != null)
{
player.Picture = sheet.GetRow(row).GetCell(0).ToString();
player.Name = sheet.GetRow(row).GetCell(1).ToString();
player.Position = sheet.GetRow(row).GetCell(2).ToString();
player.Age = EditingInfo.ConvertNumber(sheet.GetRow(row).GetCell(3).ToString());
player.Career_age = EditingInfo.ConvertNumber(sheet.GetRow(row).GetCell(4).ToString());
player.Height = EditingInfo.ConvertNumberToDouble(sheet.GetRow(row).GetCell(5).ToString());
player.Weight = EditingInfo.ConvertNumber(sheet.GetRow(row).GetCell(6).ToString());
player.Current_team = sheet.GetRow(row).GetCell(7).ToString();
playersToOutput.Add(player);
}
}
}
return(playersToOutput);
}
private void btnConfirmEditingPlayer_Click(object sender, RoutedEventArgs e)
{
var selectedTeam = cbToEditOrAddTeams.SelectedItem;
var selectedPosition = cbToEditOrAddPositions.SelectedItem;
Positions position = selectedPosition as Positions;
Teams team = selectedTeam as Teams;
var player = lvPlayers.SelectedValue;
BasketballPlayers player1 = player as BasketballPlayers;
BindingList <BasketballPlayers> currentPlayers = FilePath.GetBasketballPlayers();
string message = player1.Name;
GetPlayerFromForm(player1, team, position);
var errMsg = CombinedPlayerCheck(player1);
if (!string.IsNullOrEmpty(errMsg))
{
ToLog(errMsg, MessageBoxImage.Error);
UpdateInterface();
return;
}
player1.CheckPlayerPicture(player1);
foreach (var item in currentPlayers)
{
if (player1.ID == item.ID)
{
currentPlayers.Remove(item);
currentPlayers.Add(player1);
break;
}
}
FilePath.SaveData(currentPlayers);
UpdateInterface();
ToLog($"{message} was successfully edited", MessageBoxImage.Information);
ClearPlayersInterface();
}
private void lvTeamsOutput_SelectionChanged(object sender, RoutedEventArgs e)
{
if (_toCompleteEvent)
{
return;
}
var str = lvTeamsOutput.SelectedValue;
Teams str1 = str as Teams;
var players = str1.BasketballPlayers;
if (_toSort)
{
BasketballPlayers player = new BasketballPlayers();
Positions temp = new Positions();
if (cbSortPosition.SelectedItem != null)
{
temp = cbSortPosition.SelectedItem as Positions;
}
var pos = temp.Position;
int toSort = 0;
if (!string.IsNullOrEmpty(tbSortByAge.Text))
{
toSort = Convert.ToInt32(tbSortByAge.Text);
}
players = player.SortPlayers(players, pos, tbSortByName.Text, toSort);
}
lvPlayers.ItemsSource = players;
lvPlayers.Visibility = Visibility.Visible;
gridPlayerButtons.Visibility = Visibility.Visible;
ClearPlayersInterface();
ClearTeamsInterface();
}
private BasketballPlayers GetPlayerFromForm(BasketballPlayers player, Teams team, Positions position)
{
//if (!string.IsNullOrEmpty(team.TeamName))
//{
player.Current_team = team.TeamName;
//}
//if (!string.IsNullOrEmpty(tbGetName.Text))
//{
player.Name = tbGetName.Text;
//}
//if (!string.IsNullOrEmpty(tbGetAge.Text))
//{
player.Age = EditingInfo.ConvertNumber(tbGetAge.Text);
//}
//if (!string.IsNullOrEmpty(tbGetCareerAge.Text))
//{
player.Career_age = EditingInfo.ConvertNumber(tbGetCareerAge.Text);
//}
//if (!string.IsNullOrEmpty(tbGetHeight.Text))
//{
player.Height = EditingInfo.ConvertNumberToDouble(tbGetHeight.Text);
//}
//if (!string.IsNullOrEmpty(tbGetWeight.Text))
//{
player.Weight = EditingInfo.ConvertNumber(tbGetWeight.Text);
//}
//if (!string.IsNullOrEmpty(position.Position))
//{
player.Position = position.Position;
//}
//if (!string.IsNullOrEmpty(_playerIMG))
//{
player.Picture = tbToShowPlayerPictureFilePath.Text;
//}
return(player);
}
public override BindingList <BasketballPlayers> GetPlayersFromFile()
{
BindingList <BasketballPlayers> players = new BindingList <BasketballPlayers>();
List <string> fileContent = new List <string>();
using (StreamReader sr = new StreamReader(FileProcessingPath))
{
string line = null;
while ((line = sr.ReadLine()) != null)
{
if (string.IsNullOrEmpty(line))
{
continue;
}
fileContent.Add(line);
}
}
for (int i = 1; i < fileContent.Count; i++)
{
var array = fileContent[i].Split(",");
BasketballPlayers player = new BasketballPlayers();
//if (!string.IsNullOrEmpty(array[0]) || !string.IsNullOrEmpty(array[1]) || !string.IsNullOrEmpty(array[2]) ||
// !string.IsNullOrEmpty(array[3]) || !string.IsNullOrEmpty(array[4]) || !string.IsNullOrEmpty(array[5]) ||
// !string.IsNullOrEmpty(array[6]) || !string.IsNullOrEmpty(array[7])) {
player.Name = array[0];
player.Current_team = array[1];
player.Picture = array[2];
player.Age = Convert.ToInt32(array[3]);
player.Career_age = Convert.ToInt32(array[4]);
player.Height = Convert.ToDouble(array[5]);
player.Weight = Convert.ToInt32(array[6]);
player.Position = array[7];
players.Add(player);
//}
}
return(players);
}
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;
}
