public async Task <IActionResult> AddPlayerHistory(AddPlayerHistoryModel model)
        {
            var history = new PlayerHistory
            {
                PlayerId    = model.PlayerId,
                TeamName    = model.TeamName,
                Season      = model.Season,
                LeagueName  = model.LeagueName,
                RedCards    = model.RedCards,
                YellowCards = model.YellowCards,
                Goals       = model.Goals,
                Position    = model.Position,
                Points      = model.Points
            };
            await _playerHistoryService.Create(history);

            return(RedirectToAction("Index", "Home"));
        }
        public IActionResult Create()
        {
            var model   = new AddPlayerHistoryModel();
            var players = _db.Players.OrderBy(p => p.TeamId)
                          .Select(x => new { Id = x.Id, Value = x.PlayerName });

            model.PlayerList = new SelectList(players, "Id", "Value");
            var leagues = _db.Leagues.OrderBy(c => c.LeagueName)
                          .Select(x => new { Id = x.Id, Value = x.LeagueName });

            model.LeagueList = new SelectList(leagues, "Value", "Value");
            var season = _db.Seasons.OrderBy(s => s.Season)
                         .Select(x => new { Id = x.Id, Value = x.Season });

            model.SeasonList = new SelectList(season, "Value", "Value");
            var team = _db.Teams.OrderBy(s => s.TeamName)
                       .Select(x => new { Id = x.Id, Value = x.TeamName });

            model.TeamList = new SelectList(team, "Value", "Value");

            return(View(model));
        }