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 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 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();
}
private static League CreateLeagueIfNotExists(FootballContext context, XElement xLeague)
{
League league = null;
var xElementLeagueName = xLeague.Element("league-name");
if (xElementLeagueName != null)
{
string leagueName = xElementLeagueName.Value;
league = context.Leagues.FirstOrDefault(l => l.LeagueName == leagueName);
if (league != null)
{
Console.WriteLine("Existing league: {0}", leagueName);
}
else
{
// Create a new league in the DB
league = new League()
{
LeagueName = leagueName
};
context.Leagues.Add(league);
context.SaveChanges();
Console.WriteLine("Created league: {0}", leagueName);
}
}
return(league);
}
public ActionResult Post(Player player)
{
var response = footballContext.Players.Add(player).Entity;
footballContext.SaveChanges();
return(this.CreatedAtAction(nameof(Get), response.Id, response));
}
public void addPlayer(PlayerReq p, int tId)
{
var team = _context.Teams.Where(a => a.IdTeam == tId).FirstOrDefault();
var man = _context.Players.Where(e => e.FirstName.Equals(p.firstName) && e.LastName.Equals(p.lastName) && e.DateOfBirth == p.birthdate).FirstOrDefault();
if (team == null)
{
throw new Exception();//nie zrobilem swojego
}
if (man == null)
{
throw new Exception();//nie zrobilem swojego
}
var player = _context.PlayerTeams.Where(t => t.IdPlayer == man.IdPlayer).FirstOrDefault();
PlayerTeaM nowyGracz = new PlayerTeaM()
{
IdPlayer = player.IdPlayer
};
_context.PlayerTeams.Add(nowyGracz);
_context.SaveChanges();
}
public void EditTeam()
{
string expected = "Changed";
string result;
Teams NewTeam;
using (var db = new FootballContext())
{
Teams newTeam = new Teams
{
TeamName = "Test"
};
db.Teams.Add(newTeam);
NewTeam = newTeam;
db.SaveChanges();
}
CRUDManager.Program.SaveTeam(NewTeam, NewTeam.TeamName, 0, 0, 0, 0, 0, 0, new List <Players>());
using (var db = new FootballContext())
{
var newTeam =
db.Teams.Where(o => o.TeamId == NewTeam.TeamId).FirstOrDefault();
var teamStats =
db.TeamStatistics.Where(o => o.TeamId == NewTeam.TeamId).FirstOrDefault();
result = newTeam.TeamName;
db.Remove(teamStats);
db.Remove(newTeam);
db.SaveChanges();
}
Assert.AreEqual(result, expected);
}
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 void Execute()
{
_contextOptions = new DbContextOptionsBuilder <FootballContext>()
.UseSqlServer(@"Server=tcp:qdijnzq4jx.database.windows.net,1433;Initial Catalog=Football;Persist Security Info=False;User ID=lordpiti@qdijnzq4jx;Password=Kidswast1;MultipleActiveResultSets=False;Encrypt=True;TrustServerCertificate=False;Connection Timeout=30;")
.Options;
var context = new FootballContext((DbContextOptions <FootballContext>)_contextOptions);
var b = context.Calendario;
foreach (var item in b)
{
var matchFound = context.Partido.FirstOrDefault(x => x.CodCompeticion == item.CodCompeticion &&
x.Jornada == item.Jornada && x.CodLocal == item.CodLocal && x.CodVisitante == item.CodVisitante);
if (matchFound != null)
{
item.MatchCodPartidoNavigation = matchFound;
}
}
try
{
context.SaveChanges();
}
catch (Exception ex)
{
}
}
static void Main(string[] args)
{
FootballContext ctx = new FootballContext();
var aarena = new Arena();
Console.WriteLine("Enter an Arnea name");
var name = Console.ReadLine();
aarena.Name = name;
Console.WriteLine("Enter an Arnea address name");
var address = Console.ReadLine();
aarena.Address = address;
ctx.Arenas.Add(aarena);
var ateam = new Team();
Console.WriteLine("Enter an Team name");
var teamname = Console.ReadLine();
ateam.Name = teamname;
Console.WriteLine("Enter an Team Email name");
ateam.Email = teamname + "di.com";
ctx.Teams.Add(ateam);
ctx.SaveChanges();
// list of Arena
Console.WriteLine("List of Arena name------");
foreach (var listarena in ctx.Arenas)
{
Console.WriteLine(listarena.Name);
}
// list of Team
Console.WriteLine("List of Team name------");
foreach (var alist in ctx.Teams)
{
Console.WriteLine(alist.Name);
}
Console.ReadKey();
}
public void Setup()
{
using (var context = new FootballContext())
{
context.RemoveRange(context.Player);
context.RemoveRange(context.Team);
context.SaveChanges();
}
}
public void AddTeam()
{
int expected;
int result;
using (var db = new FootballContext())
{
expected = db.Teams.Count() + 1;
Teams newTeam = new Teams
{
TeamName = "Test"
};
db.Teams.Add(newTeam);
db.SaveChanges();
result = db.Teams.Count();
db.Remove(newTeam);
db.SaveChanges();
}
Assert.AreEqual(result, expected);
}
public void AddCardsToPlayers(int cardId, int playerId)
{
using (var ctx = new FootballContext("Default"))
{
var players = ctx.Players.FirstOrDefault(x => x.Id == playerId);
var card = ctx.Cards.FirstOrDefault(x => x.Id == cardId);
players.Cards.Add(card);
ctx.SaveChanges();
}
}
public static void RemovePlayer(Players selectedPlayer)
{
using var db = new FootballContext();
var getPlayerTeams =
db.PlayerTeams.Where(o => o.PlayerId == selectedPlayer.PlayerId);
foreach (var playerteam in getPlayerTeams)
{
db.PlayerTeams.Remove(playerteam);
}
db.Players.Remove(selectedPlayer);
db.SaveChanges();
}
public void RemovePlayer()
{
int expected;
int result;
using (var db = new FootballContext())
{
Players newplayer = new Players
{
FirstName = "Test",
PositionId = 1,
LastName = "Test",
DateOfBirth = DateTime.Parse("1111/11/11"),
Nationality = "Test"
};
db.Players.Add(newplayer);
db.SaveChanges();
expected = db.Players.Count() - 1;
db.Remove(newplayer);
db.SaveChanges();
result = db.Players.Count();
}
Assert.AreEqual(result, expected);
}
public static void RemoveTeam(Teams selectedTeam)
{
using var db = new FootballContext();
var getPlayerTeams =
db.PlayerTeams.Where(o => o.TeamId == selectedTeam.TeamId);
foreach (var playerteam in getPlayerTeams)
{
db.PlayerTeams.Remove(playerteam);
}
var getTeamstats =
db.TeamStatistics.Where(o => o.TeamId == selectedTeam.TeamId).FirstOrDefault();
db.TeamStatistics.Remove(getTeamstats);
db.Teams.Remove(selectedTeam);
db.SaveChanges();
}
private static void AddTeamToLeague(FootballContext context, Team team, League league)
{
if (league != null)
{
if (team.Leagues.Contains(league))
{
Console.WriteLine("Existing team in league: {0} belongs to {1}",
team.TeamName, league.LeagueName);
}
else
{
team.Leagues.Add(league);
context.SaveChanges();
Console.WriteLine("Added team to league: {0} to league {1}",
team.TeamName, league.LeagueName);
}
}
}
private static void CreateTeamsIfNotExists(
FootballContext context, IEnumerable <XElement> xTeams, League league)
{
foreach (var xTeam in xTeams)
{
// Find the team by team name and country name (if exists)
var teamName = xTeam.Attribute("name").Value;
var xCountry = xTeam.Attribute("country");
string countryName = null;
if (xCountry != null)
{
countryName = xCountry.Value;
}
var team = context.Teams
.Include(t => t.Leagues)
.FirstOrDefault(
t => t.TeamName == teamName &&
t.Country.CountryName == countryName);
// Create the team if it does not exists
if (team != null)
{
Console.WriteLine("Existing team: {0} ({1})",
team.TeamName, countryName ?? "no country");
}
else
{
// Create a new team in the DB
team = new Team()
{
TeamName = teamName,
Country = context.Countries.FirstOrDefault(
c => c.CountryName == countryName),
};
context.Teams.Add(team);
context.SaveChanges();
Console.WriteLine("Created team: {0} ({1})",
team.TeamName, countryName ?? "no country");
}
AddTeamToLeague(context, team, league);
}
}
private static void ProcessRequest(Request request)
{
var context = new FootballContext();
var teamsForMatchesQuery = context.Teams.AsQueryable();
var league = context.Leagues.FirstOrDefault(l => l.LeagueName == request.LeagueName);
if (request.LeagueName != null)
{
teamsForMatchesQuery = teamsForMatchesQuery.Where(
t => t.Leagues.Select(l => l.Id).Contains(league.Id));
}
var teams = teamsForMatchesQuery.ToList();
var rnd = new Random();
var diffDays = (request.EndDate - request.StartDate).Days;
for (int i = 0; i < request.GenerateCount; i++)
{
var match = new TeamMatch();
match.TeamHome = teams[rnd.Next(teams.Count)];
match.TeamAway = teams[rnd.Next(teams.Count)];
match.HomeGoals = rnd.Next(request.MaxGoals + 1);
match.AwayGoals = rnd.Next(request.MaxGoals + 1);
match.MatchDate = request.StartDate.AddDays(rnd.Next(diffDays + 1));
match.League = league;
context.TeamMatches.Add(match);
context.SaveChanges();
Console.WriteLine("{0}: {1} - {2}: {3}-{4} ({5})",
match.MatchDate.Value.ToString("dd-MMM-yyyy"),
match.TeamHome.TeamName,
match.TeamAway.TeamName,
match.HomeGoals,
match.AwayGoals,
match.League != null ? match.League.LeagueName : "no league");
}
}
public void EditPlayer()
{
string expected;
string result;
Players newPlayer;
Positions newPlayerPos;
using (var db = new FootballContext())
{
expected = "Changed";
Players newplayer = new Players
{
FirstName = "Test",
PositionId = 1,
LastName = "Test",
DateOfBirth = DateTime.Parse("1111/11/11"),
Nationality = "Test"
};
Positions pos =
db.Positions.Where(o => o.PositionId == newplayer.PositionId).FirstOrDefault();
db.Players.Add(newplayer);
newPlayer = newplayer;
newPlayerPos = pos;
db.SaveChanges();
}
CRUDManager.Program.SavePlayer("Changed", "Test", "Test", DateTime.Parse("1111/11/11"), newPlayerPos, newPlayer,
new List <Teams>());
using (var db = new FootballContext())
{
var newplayer =
db.Players.Where(o => o.PlayerId == newPlayer.PlayerId).FirstOrDefault();
result = newplayer.FirstName;
db.Remove(newplayer);
db.SaveChanges();
}
Assert.AreEqual(result, expected);
}
public int Save()
{
return(context.SaveChanges());
}
public void Update(Team team)
{
var getTeam = _db.Team.FirstOrDefault(x => x.Id == team.Id);
_db.SaveChanges();
}
public void Save()
{
_db.SaveChanges();
}
public int Commit()
{
return(_context.SaveChanges());
}
public static Tuple <string, string, string> Simulate(Teams team1, List <Players> team1Squad, Teams team2, List <Players> team2Squad)
{
Random rnd = new Random();
int clock = 1;
int team1goals = 0;
int team2goals = 0;
string Output = "";
string Score = "";
string Events = "";
Output += $"The of lineup of {team1.TeamName}:" + "\n";
foreach (var player in team1Squad)
{
Output += $"{player}" + "\n";
}
Output += "\n";
Output += $"The of lineup of {team2.TeamName}:" + "\n";
foreach (var player in team2Squad)
{
Output += $"{player}" + "\n";
}
Events += "FULL TIME!!!";
Events += "\n" + "\n";
Output += "\n";
Output += "KICK OFF!!!";
Output += "\n";
while (clock <= 90)
{
int eventOdds = rnd.Next(2, 51);
if (clock == 45)
{
Output += $"{clock} MINUTES" + "\n";
Output += "HALF TIME!!!" + "\n";
Output += "\n";
clock += 1;
}
if (clock == 90)
{
Output += $"{clock} MINUTES" + "\n";
Output += "FULL TIME!!!" + "\n";
Output += "\n";
clock += 1;
}
if (Enumerable.Range(0, 7).Contains(eventOdds))
{
Output += $"{clock} MINUTES" + "\n";
if (eventOdds < 4)
{
var result = ShotAttempt(team1Squad, team1);
Output += result.Item1;
Output += "\n";
if (result.Item3 == true)
{
team1goals += 1;
Events += $"{result.Item2} ({team1.TeamName}) {clock}' ⚽" + "\n";
}
}
else
{
var result = ShotAttempt(team2Squad, team2);
Output += result.Item1;
Output += "\n";
if (result.Item3 == true)
{
team2goals += 1;
Events += $"{result.Item2} ({team2.TeamName}) {clock}' ⚽" + "\n";
}
}
clock += 1;
}
else
{
clock += 1;
}
}
Score = $"{team1goals} - {team2goals}";
using (var db = new FootballContext())
{
var getteam1stats =
db.TeamStatistics.Where(o => o.TeamId == team1.TeamId).FirstOrDefault();
var getteam2stats =
db.TeamStatistics.Where(o => o.TeamId == team2.TeamId).FirstOrDefault();
if (team1goals == team2goals)
{
getteam1stats.Draws += 1;
getteam2stats.Draws += 1;
getteam1stats.GoalsScored += team1goals;
getteam2stats.GoalsScored += team2goals;
getteam1stats.GoalsConceded += team2goals;
getteam2stats.GoalsConceded += team1goals;
}
else if (team1goals > team2goals)
{
getteam1stats.Wins += 1;
getteam2stats.Losses += 1;
getteam1stats.GoalsScored += team1goals;
getteam2stats.GoalsScored += team2goals;
getteam1stats.GoalsConceded += team2goals;
getteam2stats.GoalsConceded += team1goals;
}
else if (team1goals < team2goals)
{
getteam2stats.Wins += 1;
getteam1stats.Losses += 1;
getteam1stats.GoalsScored += team1goals;
getteam2stats.GoalsScored += team2goals;
getteam1stats.GoalsConceded += team2goals;
getteam2stats.GoalsConceded += team1goals;
}
db.SaveChanges();
}
return(new Tuple <string, string, string>(Output, Score, Events));
}
public void Commit()
{
context.SaveChanges();
}
public static void Initialize(FootballContext context)
{
context.Database.EnsureDeleted();
context.Database.EnsureCreated();
if (!context.Lookups.Any())
{
Lookup[] lookups = new Lookup[] {
new Lookup {
SetName = "CSVHeader", Code = "Div", Value = "Competition", ShortValue = "Competition"
},
new Lookup {
SetName = "CSVHeader", Code = "Date", Value = "Date", ShortValue = "DateTime"
},
new Lookup {
SetName = "CSVHeader", Code = "Time", Value = "Time", ShortValue = "TimeSpan"
},
new Lookup {
SetName = "CSVHeader", Code = "HomeTeam", Value = "HomeTeam", ShortValue = "Team"
},
new Lookup {
SetName = "CSVHeader", Code = "AwayTeam", Value = "AwayTeam", ShortValue = "Team"
},
new Lookup {
SetName = "CSVHeader", Code = "FTHG", Value = "FullTimeHomeGoals", ShortValue = "int"
},
new Lookup {
SetName = "CSVHeader", Code = "FTAG", Value = "FullTimeAwayGoals", ShortValue = "int"
},
new Lookup {
SetName = "CSVHeader", Code = "FTR", Value = "FullTimeResult", ShortValue = "string"
},
new Lookup {
SetName = "CSVHeader", Code = "HTHG", Value = "HalfTimeHomeGoals", ShortValue = "int"
},
new Lookup {
SetName = "CSVHeader", Code = "HTAG", Value = "HalfTimeAwayGoals", ShortValue = "int"
},
new Lookup {
SetName = "CSVHeader", Code = "Referee", Value = "Referee", ShortValue = "string"
},
new Lookup {
SetName = "CSVHeader", Code = "HS", Value = "HomeTeamShots", ShortValue = "int"
},
new Lookup {
SetName = "CSVHeader", Code = "AS", Value = "AwayTeamShots", ShortValue = "int"
},
new Lookup {
SetName = "CSVHeader", Code = "HST", Value = "HomeTeamShotsOnTarget", ShortValue = "int"
},
new Lookup {
SetName = "CSVHeader", Code = "AST", Value = "AwayTeamShotsOnTarget", ShortValue = "int"
},
new Lookup {
SetName = "CSVHeader", Code = "HF", Value = "HomeTeamFouls", ShortValue = "int"
},
new Lookup {
SetName = "CSVHeader", Code = "AF", Value = "AwayTeamFouls", ShortValue = "int"
},
new Lookup {
SetName = "CSVHeader", Code = "HC", Value = "HomeTeamCorners", ShortValue = "int"
},
new Lookup {
SetName = "CSVHeader", Code = "AC", Value = "AwayTeamCorners", ShortValue = "int"
},
new Lookup {
SetName = "CSVHeader", Code = "HY", Value = "HomeTeamYellowCards", ShortValue = "int"
},
new Lookup {
SetName = "CSVHeader", Code = "AY", Value = "AwayTeamYellowCards", ShortValue = "int"
},
new Lookup {
SetName = "CSVHeader", Code = "HR", Value = "HomeTeamRedCards", ShortValue = "int"
},
new Lookup {
SetName = "CSVHeader", Code = "AR", Value = "AwayTeamRedCards", ShortValue = "int"
},
};
context.Lookups.AddRange(lookups);
}
if (!context.Countries.Any())
{
context.Countries.Add(
new Country()
{
Code = "ENG",
Name = "England"
}
);
context.SaveChanges();
}
if (!context.Competitions.Any())
{
Country country = context.Countries.Where(c => c.Code == "ENG").FirstOrDefault();
Competition[] competitions = new Competition[] {
new Competition {
Code = "E0", Name = "English Premier League", Country = country
},
new Competition {
Code = "E1", Name = "English Championship", Country = country
}
};
context.Competitions.AddRange(competitions);
context.SaveChanges();
}
}
/// <summary>
/// Aktualizacja danych rekordu
/// </summary>
/// <param name="entity"></param>
public void Update(T entity)
{
_context.Entry(entity).CurrentValues.SetValues(entity);
_context.SaveChanges();
}
public void SaveChanges()
{
context.SaveChanges();
}
public void Update(Player player)
{
var getPlayer = _db.Player.FirstOrDefault(x => x.Id == player.Id);
_db.SaveChanges();
}