static void Main(string[] args)
{
var db = new BocceeBallContext();
//var game1 = new Models.Game()
//{
// HomeScore = 0,
// AwayScore = 10,
// Notes = "Total curbstomp",
// DateHappened = new DateTime(2008, 10, 20)
//};
//var game2 = new Models.Game()
//{
// HomeScore = 10,
// AwayScore = 0,
// Notes = "GO HOME!!!",
// DateHappened = new DateTime(2080, 05, 23),
//};
//var game3 = new Models.Game()
//{
// HomeScore = 5,
// AwayScore = 10,
// Notes = "Closer!",
// DateHappened = new DateTime(2011, 02, 14)
//};
//var team3 = new Models.Team()
//{
// Mascot = "HoneyBadger",
// Color = "Orange"
//};
//var player3 = new Models.Player()
//{
// FullName = "Chris",
// NickName = "Sabrina Consuelo",
// ThrowingArm = "Yes"
//};
//player3.Team = team3;
//game3.HomeTeam = team3;
//game3.Winner = team3;
//var team2 = db.Teams.First(x => x.ID == 2);
//game3.AwayTeam = team2;
//db.Games.Add(game3);
//db.Teams.Add(team3);
//db.Players.Add(player3);
//db.Games.Add(game1);
//db.Games.Add(game2);
// Creating some players.
//var newPlayer = new Models.Player()
//{
// FullName = "Ricardo",
// NickName = "Ricky",
// ThrowingArm = "Right"
//};
//var newPlayer2 = new Models.Player()
//{
// FullName = "Stephanie",
// NickName = "Steph",
// ThrowingArm = "Both"
//};
//db.Players.Add(newPlayer);
//db.Players.Add(newPlayer2);
// Creating some teams.
//var team1 = new Models.Team()
//{
// Mascot = "Wolves",
// Color = "Gray"
//};
//var team2 = new Models.Team()
//{
// Mascot = "Warriors",
// Color = "Gold"
//};
//db.Teams.Add(team1);
//db.Teams.Add(team2);
//var playerSteph = db.Players.First(p => p.FullName == "Stephanie");
//var stephTeam = db.Teams.First(t => t.Mascot == "Wolves");
//playerSteph.Team = stephTeam;
//var allTeams = db.Teams.Include(x => x.Game.Where(y => y.WinnerID == x.ID));
//foreach(var Team in allTeams)
//{
// Console.WriteLine(Team.Game);
//}
var allTeams = db.Teams;
var allGames = db.Games;
var teamsWithGames = db.Teams.Include(i => i.Game).ToList();
foreach (var team in teamsWithGames)
{
int WinCount = team.Game.Count(x => x.WinnerID == team.ID);
int TotalCount = team.Game.Count();
Console.WriteLine(team.Game.Count(x => x.WinnerID == team.ID));
Console.WriteLine($"The {team.Color} {team.Mascot} won {WinCount} games and lost {TotalCount - WinCount} games");
}
//var joined = from t1 in db.Teams
// join t2 in db.Games on t1.ID equals t2.WinnerID
// select new { t1.ID, t1.Mascot, t2.WinnerID };
//foreach(var game in joined)
//{
// Console.WriteLine(game.WinnerID);
// Console.WriteLine($"team {game.ID} has played{joined.Count()} games");
//}
//foreach(var team in allTeams)
//{
// var teamID = team.ID;
// Console.WriteLine(team.ID);
// Console.WriteLine(allGames.Count());
// var count = allGames.Count(g => teamID > 0);
// Console.WriteLine($"{count} games won by team {team.ID}");
//}
Console.ReadLine();
var playerRicky = db.Players.First(p => p.FullName == "Ricardo");
var rickTeam = db.Teams.First(t => t.Mascot == "Warriors");
playerRicky.Team = rickTeam;
// Get all games that happened in the past.
var pastGames = db.Games.Where(x => x.DateHappened < DateTime.Today);
foreach (var game in pastGames)
{
Console.WriteLine($"game {game.ID} happened on {game.DateHappened}");
}
// Get all games that will happen in the future.
var futureGames = db.Games.Where(x => x.DateHappened > DateTime.Today);
foreach (var game in futureGames)
{
Console.WriteLine($"game {game.ID} happens on {game.DateHappened}");
}
// Get all players and their team.
var players = db.Players;
foreach (var player in players)
{
Console.WriteLine($"{player.FullName} is on team {(player.TeamID != null ? player.TeamID.ToString() : "No team")}");
}
Console.ReadLine();
db.SaveChanges();
}
static void Main(string[] args)
{
var db = new BocceeBallContext();
var Teams = db.Teams;
//var team1 = db.Teams.Single(t => t.ID == 2);
//var team2 = db.Teams.Single(t => t.ID == 3);
//var firstGame = new Models.Game
//{
// HomeTeamID = team1.ID,
// AwayTeamID = team2.ID,
// HomeScore = 10,
// AwayScore = 20,
// DateHappened = DateTime.Now,
// Notes = "The away team kicked butt!!!",
//};
//var secondGame = new Models.Game
//{
// HomeTeamID = 2,
// AwayTeamID = 3,
// HomeScore = 10,
// AwayScore = 20,
// DateHappened = new DateTime(2010, 05, 19),
// Notes = "Keep an eye out for no. 9",
//};
//var thirdGame = new Models.Game
//{
// HomeTeamID = 1,
// AwayTeamID = 3,
// HomeScore = 10,
// AwayScore = 20,
// DateHappened = new DateTime(2013, 12, 24),
// Notes = "Ten points to Gryffindor!!!",
//};
//db.Games.Add(firstGame);
//db.Games.Add(secondGame);
//db.Games.Add(thirdGame);
// Creating a bunch of teams.
//var teamA = new Models.Team
//{
// Mascot = "Honeybadgers",
// Color = "Dark Gray"
//};
//var teamB = new Models.Team
//{
// Mascot = "Warriors",
// Color = "Gold"
//};
//var teamC = new Models.Team
//{
// Mascot = "Snakes",
// Color = "Green"
//};
//var teamD = new Models.Team
//{
// Mascot = "Eagles",
// Color = "Brown"
//};
//var teamE = new Models.Team
//{
// Mascot = "Griffins",
// Color = "Silver"
//};
//var teamF = new Models.Team
//{
// Mascot = "Tigers",
// Color = "Orange"
//};
//db.Teams.Add(teamA);
//db.Teams.Add(teamB);
//db.Teams.Add(teamC);
//db.Teams.Add(teamD);
//db.Teams.Add(teamE);
//db.Teams.Add(teamF);
foreach (var team in Teams)
{
Console.WriteLine(team.Mascot);
}
Console.ReadLine();
db.SaveChanges();
}