static void Main(string[] args)
{
var context = new FootballEntities();
var leaguesTeams = context.Leagues
.OrderBy(l => l.LeagueName)
.Select(l => new
{
leagueName = l.LeagueName,
teams = l.Teams.OrderBy(t => t.TeamName).Select(t => t.TeamName)
});
//foreach (var league in leaguesTeams)
//{
// Console.WriteLine(league.leagueName);
// foreach (var team in league.teams)
// {
// Console.WriteLine(team);
// }
//}
var JSerializer = new JavaScriptSerializer();
var jsonleaguesTeams = JSerializer.Serialize(leaguesTeams);
File.WriteAllText("../../leagues-and-teams.json", jsonleaguesTeams);
}
static void Main()
{
//To test your EF data model, list all team names.
// The rest of problem 1 is in separate project.
var context = new FootballEntities();
foreach (var team in context.Teams)
{
Console.WriteLine(team.TeamName);
}
}
static void Main(string[] args)
{
var contetx = new FootballEntities();
var teamNames = contetx.Teams
.Select(t => t.TeamName)
.ToList();
foreach (var team in teamNames)
{
Console.WriteLine(team);
}
}
static void Main(string[] args)
{
var contetx = new FootballEntities();
var teamNames = contetx.Teams
.Select(t => t.TeamName)
.ToList();
foreach (var team in teamNames)
{
Console.WriteLine(team);
}
}
static void Main(string[] args)
{
var context = new FootballEntities();
XDocument xmlDoc = XDocument.Load("../../leagues-and-teams.xml");
int leagueNumber = 1;
var leagueNodes = xmlDoc.XPathSelectElements("/leagues-and-teams/league");
foreach (var xmlLeague in leagueNodes)
{
Console.WriteLine("Processing league #{0} ...", leagueNumber++);
League leagueToAdd = null;
if (xmlLeague.Element("league-name") != null)
{
var leagueName = xmlLeague.Element("league-name").Value;
leagueToAdd = context.Leagues.FirstOrDefault(l => l.LeagueName == leagueName);
if (leagueToAdd != null)
{
Console.WriteLine("Existing league: {0}", leagueName);
}
else
{
leagueToAdd = new League() { LeagueName = leagueName };
context.Leagues.Add(leagueToAdd);
Console.WriteLine("Created league: {0}", leagueName);
}
}
var teamNodes = xmlLeague.XPathSelectElements("teams/team");
foreach (var t in teamNodes)
{
Team teamToAdd = null;
var teamName = t.Attribute("name").Value;
var countryAtt = t.Attribute("country");
string countryName = null;
if (countryAtt != null)
{
countryName = countryAtt.Value;
}
teamToAdd = context.Teams.FirstOrDefault(team => team.TeamName == teamName && team.Country.CountryName == countryName);
if (teamToAdd != null)
{
Console.WriteLine("Existing team: {0} ({1})", teamName, countryName);
}
else
{
var counrty = context.Countries.FirstOrDefault(c => c.CountryName == countryName);
teamToAdd = new Team()
{
TeamName = teamName,
Country = counrty
};
context.Teams.Add(teamToAdd);
Console.WriteLine("Created team: {0} ({1})", teamName, countryName ?? "no counrty");
}
//add teamToAdd in leagues
if (leagueToAdd != null)
{
leagueToAdd.Teams.Add(teamToAdd);
}
}
}
context.SaveChanges();
}
static void Main(string[] args)
{
var context = new FootballEntities();
var mateches = context.InternationalMatches
.OrderBy(im => im.MatchDate)
.ThenBy(im => im.CountryHome)
.ThenBy(im => im.CountryAway)
.Select(im => new
{
homeCountry = im.CountryHome.CountryName,
awayCountry = im.CountryAway.CountryName,
homeCountryCode = im.CountryHome.CountryCode,
awayCountryCode = im.CountryAway.CountryCode,
league = im.League.LeagueName,
matchDate = im.MatchDate,
homeScore = im.HomeGoals,
awayScore = im.AwayGoals
});
XElement xmlMatches = new XElement("matches");
foreach (var m in mateches)
{
XElement match = new XElement("match");
var homeCountry = new XElement("home-country", m.homeCountry);
homeCountry.Add(new XAttribute("code", m.homeCountryCode));
var awayCountry = new XElement("away-country", m.awayCountry);
awayCountry.Add(new XAttribute("code", m.awayCountryCode));
match.Add(homeCountry);
match.Add(awayCountry);
if (m.league != null)
{
var league = new XElement("league", m.league);
match.Add(league);
}
if (m.homeScore != null && m.awayScore != null)
{
var score = new XElement("score", m.homeScore + "-" + m.awayScore);
match.Add(score);
}
if (m.matchDate != null)
{
if (m.matchDate.Value.TimeOfDay == TimeSpan.Zero )
{
var date = new XAttribute("date", m.matchDate.Value.ToString("dd-MMM-yyyy"));
match.Add(date);
}
else
{
var datetime = new XAttribute("date-time", m.matchDate.Value.ToString("dd-MMM-yyyy hh:mm"));
match.Add(datetime);
}
}
xmlMatches.Add(match);
}
var xmlDoc = new XDocument(xmlMatches);
xmlDoc.Save("../../international-matches.xml");
}