private void MapTeams(TeamSheetTeam team, int managerId)
{
var leagueTeams = db.Teams.ToList();
foreach (var goalKeeper in team.GoalKeepers)
{
string matchText = goalKeeper.Team.Replace(" ", string.Empty).ToUpper();
int bestDistance = -1;
int bestTeamId = -1;
foreach (var leagueTeam in leagueTeams)
{
var distance = LevenshteinDistance.Compute(matchText, leagueTeam.Alias.Replace(" ", string.Empty).ToUpper());
if (bestDistance == -1 || distance < bestDistance)
{
bestDistance = distance;
bestTeamId = leagueTeam.TeamId;
}
}
if (bestTeamId != -1)
{
db.ManagerGoalKeepers.Add(new ManagerGoalKeeper(bestTeamId, managerId, goalKeeper.Substitute));
}
}
}
private void MapPlayers(TeamSheetTeam team, int managerId)
{
var leaguePlayers = db.Players.ToList();
foreach (var player in team.Players)
{
string matchText = player.Name.Replace(" ", string.Empty).ToUpper();
int bestDistance = -1;
int bestPlayerId = -1;
foreach (var leaguePlayer in leaguePlayers.Where(x => x.Position == player.Position))
{
var distance = LevenshteinDistance.Compute(matchText, string.Format("{0}-{1}", leaguePlayer.LastName, leaguePlayer.Team.Alias).Replace(" ", string.Empty).ToUpper());
if ((bestDistance == -1 || distance < bestDistance) || (distance == bestDistance && leaguePlayer.LastName.Contains(player.Name)))
{
bestDistance = distance;
bestPlayerId = leaguePlayer.PlayerId;
}
}
if (bestPlayerId != -1)
{
db.ManagerPlayers.Add(new ManagerPlayer(bestPlayerId, managerId, player.Substitute));
}
}
}
private void AddTeam(string manager, int row, int column)
{
const int increment = 2;
row += 3;
TeamSheetTeam teamSheetTeam = new TeamSheetTeam(manager);
var goalkeeper1 = sheet1.Cells[row, column].Value;
if (goalkeeper1 != null)
{
TeamSheetGoalKeeper teamsheetGoalKeeper = new TeamSheetGoalKeeper(goalkeeper1.ToString());
teamSheetTeam.GoalKeepers.Add(teamsheetGoalKeeper);
}
row += increment;
var goalkeeper2 = sheet1.Cells[row, column].Value;
if (goalkeeper2 != null)
{
TeamSheetGoalKeeper teamsheetGoalKeeper = new TeamSheetGoalKeeper(goalkeeper2.ToString(), true);
teamSheetTeam.GoalKeepers.Add(teamsheetGoalKeeper);
}
row += increment;
var player1 = sheet1.Cells[row, column].Value;
if (player1 != null)
{
TeamSheetPlayer teamsheetPlayer = new TeamSheetPlayer(player1.ToString(), Position.Defender);
teamSheetTeam.Players.Add(teamsheetPlayer);
}
row += increment;
var player2 = sheet1.Cells[row, column].Value;
if (player2 != null)
{
TeamSheetPlayer teamsheetPlayer = new TeamSheetPlayer(player2.ToString(), Position.Defender);
teamSheetTeam.Players.Add(teamsheetPlayer);
}
row += increment;
var player3 = sheet1.Cells[row, column].Value;
if (player3 != null)
{
TeamSheetPlayer teamsheetPlayer = new TeamSheetPlayer(player3.ToString(), Position.Defender, true);
teamSheetTeam.Players.Add(teamsheetPlayer);
}
row += increment;
var player4 = sheet1.Cells[row, column].Value;
if (player4 != null)
{
TeamSheetPlayer teamsheetPlayer = new TeamSheetPlayer(player4.ToString(), Position.Midfielder);
teamSheetTeam.Players.Add(teamsheetPlayer);
}
row += increment;
var player5 = sheet1.Cells[row, column].Value;
if (player5 != null)
{
TeamSheetPlayer teamsheetPlayer = new TeamSheetPlayer(player5.ToString(), Position.Midfielder);
teamSheetTeam.Players.Add(teamsheetPlayer);
}
row += increment;
var player6 = sheet1.Cells[row, column].Value;
if (player6 != null)
{
TeamSheetPlayer teamsheetPlayer = new TeamSheetPlayer(player6.ToString(), Position.Midfielder);
teamSheetTeam.Players.Add(teamsheetPlayer);
}
row += increment;
var player7 = sheet1.Cells[row, column].Value;
if (player7 != null)
{
TeamSheetPlayer teamsheetPlayer = new TeamSheetPlayer(player7.ToString(), Position.Midfielder, true);
teamSheetTeam.Players.Add(teamsheetPlayer);
}
row += increment;
var player8 = sheet1.Cells[row, column].Value;
if (player8 != null)
{
TeamSheetPlayer teamsheetPlayer = new TeamSheetPlayer(player8.ToString(), Position.Forward);
teamSheetTeam.Players.Add(teamsheetPlayer);
}
row += increment;
var player9 = sheet1.Cells[row, column].Value;
if (player9 != null)
{
TeamSheetPlayer teamsheetPlayer = new TeamSheetPlayer(player9.ToString(), Position.Forward);
teamSheetTeam.Players.Add(teamsheetPlayer);
}
row += increment;
var player10 = sheet1.Cells[row, column].Value;
if (player10 != null)
{
TeamSheetPlayer teamsheetPlayer = new TeamSheetPlayer(player10.ToString(), Position.Forward);
teamSheetTeam.Players.Add(teamsheetPlayer);
}
row += increment;
var player11 = sheet1.Cells[row, column].Value;
if (player11 != null)
{
TeamSheetPlayer teamsheetPlayer = new TeamSheetPlayer(player11.ToString(), Position.Forward);
teamSheetTeam.Players.Add(teamsheetPlayer);
}
row += increment;
var player12 = sheet1.Cells[row, column].Value;
if (player12 != null)
{
TeamSheetPlayer teamsheetPlayer = new TeamSheetPlayer(player12.ToString(), Position.Forward);
teamSheetTeam.Players.Add(teamsheetPlayer);
}
row += increment;
var player13 = sheet1.Cells[row, column].Value;
if (player13 != null)
{
TeamSheetPlayer teamsheetPlayer = new TeamSheetPlayer(player13.ToString(), Position.Forward, true);
teamSheetTeam.Players.Add(teamsheetPlayer);
}
teamSheet.Teams.Add(teamSheetTeam);
}
