public static void SubmitTeam(string teamName, List <Players> selectedPlayers)
{
using var db = new FootballContext();
Teams newTeam = new Teams
{
TeamName = teamName
};
db.Teams.Add(newTeam);
db.SaveChanges();
foreach (var selectedplayer in selectedPlayers)
{
PlayerTeams newEntry = new PlayerTeams
{
TeamId = newTeam.TeamId,
PlayerId = selectedplayer.PlayerId
};
db.PlayerTeams.Add(newEntry);
}
TeamStatistics newStatistics = new TeamStatistics
{
TeamId = newTeam.TeamId,
MatchesPlayed = 0,
Wins = 0,
Draws = 0,
Losses = 0,
GoalsScored = 0,
GoalsConceded = 0
};
db.TeamStatistics.Add(newStatistics);
db.SaveChanges();
}
public static void SavePlayer(string firstName, string lastName, string nationality, DateTime dob,
Positions pos, Players selectedPlayer, List <Teams> teams)
{
using var db = new FootballContext();
var findPlayer =
db.Players.Where(o => o.PlayerId == selectedPlayer.PlayerId).First();
findPlayer.FirstName = firstName;
findPlayer.LastName = lastName;
findPlayer.Nationality = nationality;
findPlayer.DateOfBirth = dob;
findPlayer.PositionId = pos.PositionId;
var removeEntries =
db.PlayerTeams.Where(o => o.PlayerId == selectedPlayer.PlayerId);
foreach (var rEntry in removeEntries)
{
db.PlayerTeams.Remove(rEntry);
}
foreach (var team in teams)
{
PlayerTeams newEntry = new PlayerTeams
{
PlayerId = selectedPlayer.PlayerId,
TeamId = team.TeamId
};
db.PlayerTeams.Add(newEntry);
}
db.SaveChanges();
}
public static void SaveTeam(Teams team, string teamName, int matchesPlayed, int wins, int draws, int losses, int goalsScored,
int goalsConceded, List <Players> players)
{
using var db = new FootballContext();
var findTeam =
db.Teams.Where(o => o.TeamId == team.TeamId).FirstOrDefault();
var findstats =
db.TeamStatistics.Where(o => o.TeamId == team.TeamId).FirstOrDefault();
findTeam.TeamName = teamName;
findstats.MatchesPlayed = matchesPlayed;
findstats.Wins = wins;
findstats.Draws = draws;
findstats.Losses = losses;
findstats.GoalsScored = goalsScored;
findstats.GoalsConceded = goalsConceded;
var removeEntries =
db.PlayerTeams.Where(o => o.TeamId == team.TeamId);
foreach (var rEntry in removeEntries)
{
db.PlayerTeams.Remove(rEntry);
}
foreach (var player in players)
{
PlayerTeams newEntry = new PlayerTeams
{
PlayerId = player.PlayerId,
TeamId = team.TeamId
};
db.PlayerTeams.Add(newEntry);
}
db.SaveChanges();
}
public static void SubmitPlayer(string firstName, string lastName, string nationality, DateTime dob,
List <Teams> selectedTeams, Positions pos)
{
using var db = new FootballContext();
Players newPlayer = new Players
{
FirstName = firstName,
LastName = lastName,
Nationality = nationality,
DateOfBirth = dob,
PositionId = pos.PositionId
};
db.Players.Add(newPlayer);
db.SaveChanges();
foreach (var team in selectedTeams)
{
PlayerTeams newEntry = new PlayerTeams
{
PlayerId = newPlayer.PlayerId,
TeamId = team.TeamId
};
db.PlayerTeams.Add(newEntry);
}
db.SaveChanges();
}
public static Players GetPlayer(PlayerTeams player)
{
using var db = new FootballContext();
var playerQuery =
db.Players.Where(o => o.PlayerId == player.PlayerId).FirstOrDefault();
return(playerQuery);
}
