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