public async Task <IEnumerable <DraftPlayerDto> > GetInitialDraftPlayerPool(int page) { List <DraftPlayerDto> draftPool = new List <DraftPlayerDto>(); // Get players int start = (page * 50) - 50; int end = (page * 50); var players = await _context.Players.OrderBy(x => x.Surname).ToListAsync(); int total = players.Count; if (end > total) { end = total; } // foreach (var player in players)- 1; for (int i = start; i < end; i++) { var player = players[i]; // NEED TO CHECK WHETHER THE PLAYER HAS BEEN DRAFTED var playerTeamForPlayerId = await _context.PlayerTeams.FirstOrDefaultAsync(x => x.PlayerId == player.Id); if (playerTeamForPlayerId.TeamId == 31) { var playerGrade = await _context.PlayerGradings.FirstOrDefaultAsync(x => x.PlayerId == player.Id); // Now create the Dto DraftPlayerDto newPlayer = new DraftPlayerDto(); newPlayer.PlayerId = player.Id; newPlayer.BlockGrade = playerGrade.BlockGrade; newPlayer.CPosition = player.CPosition; newPlayer.Age = player.Age; newPlayer.DRebGrade = playerGrade.DRebGrade; newPlayer.FirstName = player.FirstName; newPlayer.FTGrade = playerGrade.FTGrade; newPlayer.HandlingGrade = playerGrade.HandlingGrade; newPlayer.IntangiblesGrade = playerGrade.IntangiblesGrade; newPlayer.ORebGrade = playerGrade.ORebGrade; newPlayer.PassingGrade = playerGrade.PassingGrade; newPlayer.PFPosition = player.PFPosition; newPlayer.PGPosition = player.PGPosition; newPlayer.SFPosition = player.SFPosition; newPlayer.SGPosition = player.SGPosition; newPlayer.StaminaGrade = playerGrade.StaminaGrade; newPlayer.StealGrade = playerGrade.StealGrade; newPlayer.Surname = player.Surname; newPlayer.ThreeGrade = playerGrade.ThreeGrade; newPlayer.TwoGrade = playerGrade.TwoGrade; draftPool.Add(newPlayer); } } return(draftPool); }
public async Task <IEnumerable <DraftPlayerDto> > FilterInitialDraftPlayerPool(string value) { List <DraftPlayerDto> draftPool = new List <DraftPlayerDto>(); var query = String.Format("SELECT * FROM Players where Surname like '%" + value + "%' or FirstName like '%" + value + "%'"); var players = await _context.Players.FromSqlRaw(query).ToListAsync(); for (int i = 0; i < players.Count; i++) { var player = players[i]; // NEED TO CHECK WHETHER THE PLAYER HAS BEEN DRAFTED var playerTeamForPlayerId = await _context.PlayerTeams.FirstOrDefaultAsync(x => x.PlayerId == player.Id); if (playerTeamForPlayerId.TeamId == 31) { var playerGrade = await _context.PlayerGradings.FirstOrDefaultAsync(x => x.PlayerId == player.Id); // Now create the Dto DraftPlayerDto newPlayer = new DraftPlayerDto(); newPlayer.PlayerId = player.Id; newPlayer.BlockGrade = playerGrade.BlockGrade; newPlayer.CPosition = player.CPosition; newPlayer.Age = player.Age; newPlayer.DRebGrade = playerGrade.DRebGrade; newPlayer.FirstName = player.FirstName; newPlayer.FTGrade = playerGrade.FTGrade; newPlayer.HandlingGrade = playerGrade.HandlingGrade; newPlayer.IntangiblesGrade = playerGrade.IntangiblesGrade; newPlayer.ORebGrade = playerGrade.ORebGrade; newPlayer.PassingGrade = playerGrade.PassingGrade; newPlayer.PFPosition = player.PFPosition; newPlayer.PGPosition = player.PGPosition; newPlayer.SFPosition = player.SFPosition; newPlayer.SGPosition = player.SGPosition; newPlayer.StaminaGrade = playerGrade.StaminaGrade; newPlayer.StealGrade = playerGrade.StealGrade; newPlayer.Surname = player.Surname; newPlayer.ThreeGrade = playerGrade.ThreeGrade; newPlayer.TwoGrade = playerGrade.TwoGrade; draftPool.Add(newPlayer); } } return(draftPool); }
public async Task <IEnumerable <DraftPlayerDto> > GetDraftBoardForTeamId(int teamId) { List <DraftPlayerDto> draftboardPlayers = new List <DraftPlayerDto>(); var draftRankings = await _context.DraftRankings.Where(x => x.TeamId == teamId).OrderBy(x => x.Rank).ToListAsync(); foreach (var player in draftRankings) { var playerRecord = await _context.Players.FirstOrDefaultAsync(x => x.Id == player.PlayerId); var playerGrades = await _context.PlayerGradings.FirstOrDefaultAsync(x => x.PlayerId == player.PlayerId); DraftPlayerDto newPlayer = new DraftPlayerDto(); newPlayer.PlayerId = playerRecord.Id; newPlayer.BlockGrade = playerGrades.BlockGrade; newPlayer.CPosition = playerRecord.CPosition; newPlayer.Age = playerRecord.Age; newPlayer.DRebGrade = playerGrades.DRebGrade; newPlayer.FirstName = playerRecord.FirstName; newPlayer.FTGrade = playerGrades.FTGrade; newPlayer.HandlingGrade = playerGrades.HandlingGrade; newPlayer.IntangiblesGrade = playerGrades.IntangiblesGrade; newPlayer.ORebGrade = playerGrades.ORebGrade; newPlayer.PassingGrade = playerGrades.PassingGrade; newPlayer.PFPosition = playerRecord.PFPosition; newPlayer.PGPosition = playerRecord.PGPosition; newPlayer.SFPosition = playerRecord.SFPosition; newPlayer.SGPosition = playerRecord.SGPosition; newPlayer.StaminaGrade = playerGrades.StaminaGrade; newPlayer.StealGrade = playerGrades.StealGrade; newPlayer.Surname = playerRecord.Surname; newPlayer.ThreeGrade = playerGrades.ThreeGrade; newPlayer.TwoGrade = playerGrades.TwoGrade; draftboardPlayers.Add(newPlayer); } return(draftboardPlayers); }
public async Task <IEnumerable <DraftPlayerDto> > DraftPoolFilterByPosition(int pos) { List <DraftPlayerDto> draftPool = new List <DraftPlayerDto>(); List <Player> players = new List <Player>(); // Get players if (pos == 1) { players = await _context.Players.Where(x => x.PGPosition == 1).OrderBy(x => x.Surname).ToListAsync(); } else if (pos == 2) { players = await _context.Players.Where(x => x.SGPosition == 1).OrderBy(x => x.Surname).ToListAsync(); } else if (pos == 3) { players = await _context.Players.Where(x => x.SFPosition == 1).OrderBy(x => x.Surname).ToListAsync(); } else if (pos == 4) { players = await _context.Players.Where(x => x.PFPosition == 1).OrderBy(x => x.Surname).ToListAsync(); } else if (pos == 5) { players = await _context.Players.Where(x => x.CPosition == 1).OrderBy(x => x.Surname).ToListAsync(); } int total = players.Count; foreach (var player in players) { // NEED TO CHECK WHETHER THE PLAYER HAS BEEN DRAFTED var playerTeamForPlayerId = await _context.PlayerTeams.FirstOrDefaultAsync(x => x.PlayerId == player.Id); if (playerTeamForPlayerId.TeamId == 31) { var playerGrade = await _context.PlayerGradings.FirstOrDefaultAsync(x => x.PlayerId == player.Id); // Now create the Dto DraftPlayerDto newPlayer = new DraftPlayerDto(); newPlayer.PlayerId = player.Id; newPlayer.BlockGrade = playerGrade.BlockGrade; newPlayer.CPosition = player.CPosition; newPlayer.Age = player.Age; newPlayer.DRebGrade = playerGrade.DRebGrade; newPlayer.FirstName = player.FirstName; newPlayer.FTGrade = playerGrade.FTGrade; newPlayer.HandlingGrade = playerGrade.HandlingGrade; newPlayer.IntangiblesGrade = playerGrade.IntangiblesGrade; newPlayer.ORebGrade = playerGrade.ORebGrade; newPlayer.PassingGrade = playerGrade.PassingGrade; newPlayer.PFPosition = player.PFPosition; newPlayer.PGPosition = player.PGPosition; newPlayer.SFPosition = player.SFPosition; newPlayer.SGPosition = player.SGPosition; newPlayer.StaminaGrade = playerGrade.StaminaGrade; newPlayer.StealGrade = playerGrade.StealGrade; newPlayer.Surname = player.Surname; newPlayer.ThreeGrade = playerGrade.ThreeGrade; newPlayer.TwoGrade = playerGrade.TwoGrade; draftPool.Add(newPlayer); } } return(draftPool); }