Beispiel #1
0
        static void Main()
        {
            var footballEntities = new FootballEntities();
            var footballTeams    = footballEntities.Teams
                                   .Select(t => t.TeamName);

            foreach (var footballTeam in footballTeams)
            {
                Console.WriteLine(footballTeam);
            }
        }
Beispiel #2
0
        static void Main()
        {
            var footballEntities = new FootballEntities();
            var leaguesWithTeams = footballEntities.Leagues
                                   .OrderBy(l => l.LeagueName)
                                   .Select(l => new
            {
                leagueName = l.LeagueName,
                teams      = l.Teams.OrderBy(t => t.TeamName).Select(t => t.TeamName)
            });

            var leaguesWithTeamsJson = JsonConvert.SerializeObject(leaguesWithTeams, Formatting.Indented);

            File.WriteAllText("../../leagues-and-teams.json", leaguesWithTeamsJson);
        }
Beispiel #3
0
        public static void Main()
        {
            var context = new FootballEntities();
            int count   = 0;

            var xmlDocument = XDocument.Load("../../leagues-and-teams.xml");
            var leagueNodes = xmlDocument.XPathSelectElements("/leagues-and-teams/league");

            foreach (var leagueNode in leagueNodes)
            {
                Console.WriteLine("Processing league #{0} ...", ++count);
                League league     = null;
                string leagueName = null;

                if (leagueNode.Element("league-name") != null)
                {
                    leagueName = leagueNode.Element("league-name").Value;

                    league = context.Leagues.Where(l => l.LeagueName == leagueName).FirstOrDefault();

                    if (league == null)
                    {
                        league = new League()
                        {
                            LeagueName = leagueName
                        };
                        context.Leagues.Add(league);
                        context.SaveChanges();

                        Console.WriteLine("Created league: {0}", leagueName);
                    }
                    else
                    {
                        Console.WriteLine("Existing league: {0}", leagueName);
                    }
                }

                var matchNodes = leagueNode.XPathSelectElements("teams/team");
                foreach (var matchNode in matchNodes)
                {
                    string teamName    = matchNode.Attribute("name").Value;
                    string teamCountry = null;

                    if (matchNode.Attribute("country") != null)
                    {
                        teamCountry = matchNode.Attribute("country").Value;
                    }

                    var team = context.Teams.Where(t => t.TeamName == teamName).FirstOrDefault();

                    if (team == null)
                    {
                        team = new Team()
                        {
                            TeamName    = teamName,
                            CountryCode = context.Countries.Where(c => c.CountryName == teamCountry).Select(c => c.CountryCode).FirstOrDefault()
                        };

                        context.Teams.Add(team);
                        context.SaveChanges();

                        Console.WriteLine("Created team: {0} ({1})", teamName, teamCountry);
                    }
                    else
                    {
                        Console.WriteLine("Existing team: {0} ({1})", teamName, teamCountry);
                    }

                    if (leagueName != null)
                    {
                        if (league.Teams.Contains(team))
                        {
                            Console.WriteLine("Existing team in league: {0} belongs to {1}",
                                              leagueName,
                                              teamName);
                        }
                        else
                        {
                            team.Leagues.Add(league);
                            context.SaveChanges();

                            Console.WriteLine("Added team to league: {0} to league {1}",
                                              leagueName,
                                              teamName);
                        }
                    }
                }
            }
        }
        static void Main()
        {
            var footballEntities     = new FootballEntities();
            var internationalMatches = footballEntities.InternationalMatches
                                       .OrderBy(im => im.MatchDate)
                                       .ThenBy(im => im.HomeCountry.CountryName)
                                       .ThenBy(im => im.AwayCountry.CountryName)
                                       .Select(im => new
            {
                homeCountryCode = im.HomeCountryCode,
                homeCountryName = im.HomeCountry.CountryName,
                awayCountryCode = im.AwayCountryCode,
                awayCountryName = im.AwayCountry.CountryName,
                dateTime        = im.MatchDate,
                homeScore       = im.HomeGoals,
                awayScore       = im.AwayGoals,
                leagueName      = im.League.LeagueName
            })
                                       .ToList();

            var      document = new XDocument(new XDeclaration("1.0", "UTF-8", "yes"));
            XElement matches  = new XElement("matches");

            foreach (var internationalMatch in internationalMatches)
            {
                var match = new XElement("match");

                if (internationalMatch.dateTime != null)
                {
                    if (internationalMatch.dateTime.Value.TimeOfDay.TotalMilliseconds == 0)
                    {
                        var dateAttribute = new XAttribute("date", internationalMatch.dateTime.Value.ToString("dd-MM-yyyy"));
                        match.Add(dateAttribute);
                    }
                    else
                    {
                        var datetimeAttribute = new XAttribute("datetime", internationalMatch.dateTime.Value.ToString("dd-MM-yyyy HH:mm:ff"));
                        match.Add(datetimeAttribute);
                    }
                }

                var homeCountry = new XElement("home-country");
                homeCountry.Add(new XAttribute("code", internationalMatch.homeCountryCode));
                homeCountry.Value = internationalMatch.homeCountryName;
                match.Add(homeCountry);

                var awayCountry = new XElement("away-country");
                awayCountry.Add(new XAttribute("code", internationalMatch.awayCountryCode));
                awayCountry.Value = internationalMatch.awayCountryName;
                match.Add(awayCountry);

                if (internationalMatch.homeScore != null && internationalMatch.awayScore != null)
                {
                    var score = new XElement("score");
                    score.Value = string.Format("{0}:{1}",
                                                internationalMatch.homeScore,
                                                internationalMatch.awayScore);

                    match.Add(score);
                }

                if (internationalMatch.leagueName != null)
                {
                    var league = new XElement("league");
                    league.Value = string.Format("{0}", internationalMatch.leagueName);

                    match.Add(league);
                }

                matches.Add(match);
            }

            document.Add(matches);
            document.Save("../../international-matches.xml");
        }
Beispiel #5
0
        static void Main()
        {
            var    footballContext = new FootballEntities();
            Random random          = new Random();
            int    count           = 0;

            List <Team>   allTeams   = footballContext.Teams.Include("Leagues").ToList();
            List <League> allLeagues = footballContext.Leagues.ToList();

            XDocument xmlDocument = XDocument.Load("../../generate-matches.xml");
            IEnumerable <XElement> generateNodes = xmlDocument.XPathSelectElements("/generate-random-matches/generate");

            foreach (XElement generateNode in generateNodes)
            {
                Console.WriteLine("\r\nProcessing request #{0} ...", ++count);

                int      generateCount = 10;
                int      maxGoals      = 5;
                DateTime startDate     = Convert.ToDateTime("1-Jan-2000");
                DateTime endDate       = Convert.ToDateTime("31-Dec-2015");
                League   league        = null;
                string   leagueName    = null;
                int?     leagueId      = null;

                if (generateNode.Attribute("generate-count") != null)
                {
                    generateCount = int.Parse(generateNode.Attribute("generate-count").Value);
                }

                if (generateNode.Attribute("max-goals") != null)
                {
                    maxGoals = int.Parse(generateNode.Attribute("max-goals").Value);
                }

                if (generateNode.Element("league") != null)
                {
                    leagueName = generateNode.Element("league").Value;
                    league     = allLeagues.Where(l => l.LeagueName == leagueName).FirstOrDefault();

                    if (league != null)
                    {
                        leagueId = league.Id;
                    }
                }

                if (generateNode.Element("start-date") != null)
                {
                    startDate = Convert.ToDateTime(generateNode.Element("start-date").Value);
                }

                if (generateNode.Element("end-date") != null)
                {
                    endDate = Convert.ToDateTime(generateNode.Element("end-date").Value);
                }

                for (int i = 0; i < generateCount; i++)
                {
                    TimeSpan timeSpan    = endDate - startDate;
                    TimeSpan newSpan     = new TimeSpan(0, random.Next(0, (int)timeSpan.TotalMinutes), 0);
                    DateTime currentDate = startDate + newSpan;

                    var possibleTeams = allTeams;

                    if (league != null)
                    {
                        possibleTeams = possibleTeams
                                        .Where(t => t.Leagues.Select(l => l.Id).Contains(league.Id))
                                        .ToList();
                    }

                    var homeTeam = possibleTeams[random.Next(possibleTeams.Count())];
                    var awayTeam = possibleTeams[random.Next(possibleTeams.Count())];

                    var homeGoals = random.Next(maxGoals);
                    var awayGoals = random.Next(maxGoals);

                    TeamMatch currentTeamMatch = new TeamMatch()
                    {
                        HomeTeamId = homeTeam.Id,
                        AwayTeamId = awayTeam.Id,
                        HomeGoals  = homeGoals,
                        AwayGoals  = awayGoals,
                        MatchDate  = currentDate,
                        LeagueId   = leagueId
                    };

                    footballContext.TeamMatches.Add(currentTeamMatch);

                    Console.WriteLine("{0} {1}: - {2}: {3}-{4} ({5})",
                                      currentDate.ToString("dd-MMM-yyyy"),
                                      homeTeam.TeamName,
                                      awayTeam.TeamName,
                                      homeGoals,
                                      awayGoals,
                                      leagueName ?? "no league");
                }
            }

            footballContext.SaveChanges();
        }