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