static void Main(string[] args)
{
var context = new FootballExamEntities();
var leagues = context.Leagues.OrderBy(l => l.LeagueName).Select(l => new
{
leagueName = l.LeagueName,
teams = l.Teams.OrderBy(t => t.TeamName).Select(t => t.TeamName)
}).ToList();
var json = new JavaScriptSerializer().Serialize(leagues);
File.WriteAllText("../../leagues-and-teams.json", json);
/*
* foreach (var league in leagues)
* {
* Console.WriteLine(league.Name);
*
* foreach (var teams in league.LeagueTeams)
* {
* Console.WriteLine(teams);
* }
* }
*/
}
static void Main(string[] args)
{
var context = new FootballExamEntities();
var internationalMatches = context.InternationalMatches
.
}
static void Main(string[] args)
{
var context = new FootballExamEntities();
var internationalMatches = context.InternationalMatches
.OrderBy(im => im.MatchDate)
.ThenBy(im => im.CountryHome.CountryName)
.ThenBy(im => im.CountryAway.CountryName)
.Select(im => new
{
HomeScore = im.HomeGoals,
AwayScore = im.AwayGoals,
HomeCodeCountry = im.HomeCountryCode,
AwayCodeCountry = im.AwayCountryCode,
Date = im.MatchDate,
HomeCountryName = im.CountryHome.CountryName,
AwayCountryName = im.CountryAway.CountryName,
MatchLeagueName = im.League.LeagueName
}).ToList();
XElement matches = new XElement("matches");
foreach (var match in internationalMatches)
{
XElement xmlMatch = new XElement("match",
new XElement("home-country", new XAttribute("code", match.HomeCodeCountry), match.HomeCountryName),
new XElement("away-country", new XAttribute("code", match.AwayCodeCountry), match.AwayCountryName)
);
if (match.MatchLeagueName != null)
{
xmlMatch.Add(new XElement("league", match.MatchLeagueName));
}
if (match.HomeScore != null && match.AwayScore != null)
{
xmlMatch.Add(new XElement("score", match.HomeScore + "-" + match.AwayScore));
}
if (match.Date != null)
{
DateTime dateTime;
DateTime.TryParse(match.Date.ToString(), out dateTime);
if (dateTime.TimeOfDay.TotalSeconds == 0)
{
xmlMatch.Add(new XAttribute("date", dateTime.Day + "-" + dateTime.ToString("MMM") + "-" + dateTime.Year)); // ili dateTime.toString("dd-MMM-yyyy");
}
else if (dateTime.TimeOfDay.TotalSeconds != 0)
{
xmlMatch.Add(new XAttribute("date-time", dateTime.ToString("dd-MMM-yyyy hh:mm"))); // s dateTime.Minute dostupvam minutite dateTIme.Hour dostupvam chasovete
}
}
matches.Add(xmlMatch);
}
//Console.WriteLine(matches.ToString());
matches.Save("../../international-matches.xml");
}
static void Main(string[] args)
{
var context = new FootballExamEntities();
XmlDocument doc = new XmlDocument();
doc.Load("../../leagues-and-teams.xml");
var root = doc.DocumentElement;
int id = 1;
foreach (XmlNode xmlLeague in root.ChildNodes)
{
Console.WriteLine("Processing league #{0} ...", id++);
XmlNode leagueNameNode = xmlLeague.SelectSingleNode("league-name");
League league = null;
if (leagueNameNode != null)
{
string leagueName = leagueNameNode.InnerText;
league = context.Leagues.FirstOrDefault(l => l.LeagueName == leagueName);
if (league != null)
{
Console.WriteLine("Existing league: {0}", leagueName);
}
else
{
league = new League()
{
LeagueName = leagueName
};
context.Leagues.Add(league);
Console.WriteLine("Creating league: {0}", leagueName);
}
}
XmlNode teamsNode = xmlLeague.SelectSingleNode("teams");
if (teamsNode != null)
{
foreach (XmlNode xmlTeam in teamsNode.ChildNodes)
{
Team team = null;
string teamName = xmlTeam.Attributes["name"].InnerText;
string countryName = "";
if (xmlTeam.Attributes["country"] != null)
{
countryName = xmlTeam.Attributes["country"].InnerText;
}
team = context.Teams.FirstOrDefault(t => t.TeamName == teamName && t.Country.CountryName == countryName);
if (team != null)
{
Console.WriteLine("Existing team: {0} ({1})", teamName, countryName ?? "no country");
}
else
{
Country country = context.Countries.FirstOrDefault(c => c.CountryName == countryName);
team = new Team()
{
TeamName = teamName,
Country = country
};
context.Teams.Add(team);
Console.WriteLine("Created team: {0} ({1})", teamName, countryName ?? "no country");
}
if (league != null)
{
if (league.Teams.Contains(team))
{
Console.WriteLine("Existing team in league: {0} belongs to {1}", teamName, league.LeagueName);
}
else
{
league.Teams.Add(team);
Console.WriteLine("Added team to league: {0} to league {1}", teamName, league.LeagueName);
}
}
}
}
context.SaveChanges();
}
}
