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(); } }