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