public void ReloadPlayers(string filePath)
{
if (File.Exists(filePath))
{
AllAvailablePlayers.Clear();
ExcelPackage.LicenseContext = OfficeOpenXml.LicenseContext.NonCommercial;
using (var package = new ExcelPackage(new FileInfo(filePath)))
{
ExcelWorkbook workbook = package.Workbook;
if (workbook != null)
{
if (workbook.Worksheets.Count > 0)
{
ExcelWorksheet worksheet = workbook.Worksheets.First();
foreach (Player p in WorksheetToPlayers(worksheet))
{
if (!IsPlayerAlreadyOwned(p))
{
AllAvailablePlayers.Add(p);
}
}
}
}
}
}
}
public void AddPlayerToAvailablePlayers(Player player)
{
AllAvailablePlayers.Add(player);
AllAvailablePlayersView.Refresh();
}