// This class is NOT COMPLETE.
        // Todo: Complete the class according to the requirements

        /// <summary>
        /// Adds a new player to the player table
        /// </summary>
        /// <param name="newPlayer">Player to add</param>
        /// <returns>Player after it has been added to the DB</returns>
        public async Task <Player> AddPlayer(Player newPlayer)
        {
            await Players.AddAsync(newPlayer);

            await SaveChangesAsync();

            return(newPlayer);
        }
Exemple #2
0
        public async void Seed()
        {
            Random rnd = new Random();

            if (!Players.Any() && !FootballPlayers.Any() && !Sports.Any())
            {
                Sport Football = new Football();
                Sports.Add(Football);

                var Andrew = new Player()
                {
                    FirstName = "Andrew",
                    LastName  = "Sharrock",
                };
                var Stuart = new Player()
                {
                    FirstName = "Stuart",
                    LastName  = "Sharrock",
                };
                var Jim = new Player()
                {
                    FirstName = "Jim",
                    LastName  = "Sharrock",
                };
                var Gill = new Player()
                {
                    FirstName = "Gill",
                    LastName  = "Sharrock",
                };
                var Stevie = new Player()
                {
                    FirstName = "Stevie",
                    LastName  = "Sharrock",
                };
                var Carly = new Player()
                {
                    FirstName = "Carly",
                    LastName  = "Richardson"
                };
                var Timme = new Player()
                {
                    FirstName = "Timme",
                    LastName  = "Martin",
                };
                var Pete = new Player()
                {
                    FirstName = "Pete",
                    LastName  = "Skipp",
                };
                var Paul = new Player()
                {
                    FirstName = "Paul",
                    LastName  = "French",
                };
                var Leeroy = new Player()
                {
                    FirstName = "Leeroy",
                    LastName  = "Jenkins",
                };

                await Players.AddAsync(Andrew);

                await Players.AddAsync(Stuart);

                await Players.AddAsync(Jim);

                await Players.AddAsync(Gill);

                await Players.AddAsync(Stevie);

                await Players.AddAsync(Carly);

                await Players.AddAsync(Timme);

                await Players.AddAsync(Pete);

                await Players.AddAsync(Paul);

                await Players.AddAsync(Leeroy);

                SaveChanges();

                var AndrewFootballPlayer = new FootballPlayer()
                {
                    PlayerId       = Andrew.Id,
                    CentreBack     = rnd.Next(1, 101),
                    CentreMidfield = rnd.Next(1, 101),
                    Forward        = rnd.Next(1, 101)
                };
                var StuartFootballPlayer = new FootballPlayer()
                {
                    PlayerId       = Stuart.Id,
                    CentreBack     = rnd.Next(1, 101),
                    CentreMidfield = rnd.Next(1, 101),
                    Forward        = rnd.Next(1, 101)
                };
                var JimFootballPlayer = new FootballPlayer()
                {
                    PlayerId       = Jim.Id,
                    CentreBack     = rnd.Next(1, 101),
                    CentreMidfield = rnd.Next(1, 101),
                    Forward        = rnd.Next(1, 101)
                };
                var GillFootballPlayer = new FootballPlayer()
                {
                    PlayerId       = Gill.Id,
                    CentreBack     = rnd.Next(1, 101),
                    CentreMidfield = rnd.Next(1, 101),
                    Forward        = rnd.Next(1, 101)
                };
                var StevieFootballPlayer = new FootballPlayer()
                {
                    PlayerId       = Stevie.Id,
                    CentreBack     = rnd.Next(1, 101),
                    CentreMidfield = rnd.Next(1, 101),
                    Forward        = rnd.Next(1, 101)
                };
                var CarlyFootballPlayer = new FootballPlayer()
                {
                    PlayerId       = Carly.Id,
                    CentreBack     = rnd.Next(1, 101),
                    CentreMidfield = rnd.Next(1, 101),
                    Forward        = rnd.Next(1, 101)
                };
                var TimmeFootballPlayer = new FootballPlayer()
                {
                    PlayerId       = Timme.Id,
                    CentreBack     = rnd.Next(1, 101),
                    CentreMidfield = rnd.Next(1, 101),
                    Forward        = rnd.Next(1, 101)
                };;
                var PeteFootballPlayer = new FootballPlayer()
                {
                    PlayerId       = Pete.Id,
                    CentreBack     = rnd.Next(1, 101),
                    CentreMidfield = rnd.Next(1, 101),
                    Forward        = rnd.Next(1, 101)
                };
                var PaulFootballPlayer = new FootballPlayer()
                {
                    PlayerId       = Paul.Id,
                    CentreBack     = rnd.Next(1, 101),
                    CentreMidfield = rnd.Next(1, 101),
                    Forward        = rnd.Next(1, 101)
                };
                var LeeroyFootballPlayer = new FootballPlayer()
                {
                    PlayerId       = Leeroy.Id,
                    CentreBack     = rnd.Next(1, 101),
                    CentreMidfield = rnd.Next(1, 101),
                    Forward        = rnd.Next(1, 101)
                };

                AndrewFootballPlayer.SetRating(); StuartFootballPlayer.SetRating(); JimFootballPlayer.SetRating();
                GillFootballPlayer.SetRating(); StevieFootballPlayer.SetRating(); CarlyFootballPlayer.SetRating();
                TimmeFootballPlayer.SetRating(); PeteFootballPlayer.SetRating(); PaulFootballPlayer.SetRating();
                LeeroyFootballPlayer.SetRating();

                await FootballPlayers.AddAsync(AndrewFootballPlayer);

                await FootballPlayers.AddAsync(StuartFootballPlayer);

                await FootballPlayers.AddAsync(JimFootballPlayer);

                await FootballPlayers.AddAsync(GillFootballPlayer);

                await FootballPlayers.AddAsync(StevieFootballPlayer);

                await FootballPlayers.AddAsync(CarlyFootballPlayer);

                await FootballPlayers.AddAsync(TimmeFootballPlayer);

                await FootballPlayers.AddAsync(PeteFootballPlayer);

                await FootballPlayers.AddAsync(PaulFootballPlayer);

                await FootballPlayers.AddAsync(LeeroyFootballPlayer);

                SaveChanges();

                await PlayerSports.AddAsync(new PlayerSports()
                {
                    PlayerId = Andrew.Id,
                    SportId  = Football.Id,
                });

                await PlayerSports.AddAsync(new PlayerSports()
                {
                    PlayerId = Stuart.Id,
                    SportId  = Football.Id,
                });

                await PlayerSports.AddAsync(new PlayerSports()
                {
                    PlayerId = Jim.Id,
                    SportId  = Football.Id,
                });

                await PlayerSports.AddAsync(new PlayerSports()
                {
                    PlayerId = Gill.Id,
                    SportId  = Football.Id,
                });

                await PlayerSports.AddAsync(new PlayerSports()
                {
                    PlayerId = Stevie.Id,
                    SportId  = Football.Id,
                });

                await PlayerSports.AddAsync(new PlayerSports()
                {
                    PlayerId = Carly.Id,
                    SportId  = Football.Id,
                });

                await PlayerSports.AddAsync(new PlayerSports()
                {
                    PlayerId = Timme.Id,
                    SportId  = Football.Id,
                });

                await PlayerSports.AddAsync(new PlayerSports()
                {
                    PlayerId = Pete.Id,
                    SportId  = Football.Id,
                });

                await PlayerSports.AddAsync(new PlayerSports()
                {
                    PlayerId = Paul.Id,
                    SportId  = Football.Id,
                });

                await PlayerSports.AddAsync(new PlayerSports()
                {
                    PlayerId = Leeroy.Id,
                    SportId  = Football.Id,
                });


                SaveChanges();
            }
        }