public IActionResult PlayerTeam(int id)
{
var teamName = _db.Teams.Where(t => t.Id == id).FirstOrDefault().TeamName;
var playerPosition = (from player in _db.Players
.Where(p => p.TeamId == id)
.OrderBy(p => p.Position)
join Position in _db.Positions on player.PositionId equals Position.PositionId
join c in _db.Countries on player.CountryId equals c.Id
select new PlayerListingModel
{
Id = player.Id,
TeamId = player.TeamId,
TeamName = teamName,
PlayerName = player.PlayerName,
DoB = player.DoB,
PlayerImageUrl = player.PlayerImageUrl,
PositionId = Position.PositionId,
Position = Position.Position,
FlagUrl = c.FlagUrl
}).ToList();
var model = new PlayerIndexModel
{
PlayerList = playerPosition
};
return(View(model));
}
public ActionResult Index(string searchString, int?teamID, int?playerID, int?page)
{
ViewBag.teamID = teamID;
ViewBag.playerID = playerID;
ViewBag.CurrentFilter = searchString;
PlayerIndexModel playerIndexModel = new PlayerIndexModel();
if (teamID != null && teamID > 0)
{
playerIndexModel = _playerIndexModelSelectLogic.GetPlayerIndexModel(teamID, page);
}
else if (!string.IsNullOrEmpty(searchString))
{
playerIndexModel = _playerIndexModelSelectLogic.GetPlayerIndexModel(searchString, page);
}
return(View(playerIndexModel));
}
public ActionResult Delete(int playerID,
int teamID,
PlayerModel playerModel)
{
string message = string.Empty;
PlayerIndexModel playerIndexModel = new PlayerIndexModel();
//IList<PlayerModel> playerModelList = new List<PlayerModel>();
_playerModelDeleteLogic.PlayerModelDelete(playerID, teamID, ref message);
if (string.IsNullOrEmpty(message))
{
return(View("Index", playerIndexModel));
}
else
{
playerModel = _playerModelSelect.GetPlayerModel(playerID, teamID);
return(View(playerModel));
}
}
public IActionResult List()
{
var players = _playerService.GetAll()
.OrderBy(player => player.PlayerName)
.Select(c => new PlayerListingModel
{
Id = c.Id,
PlayerName = c.PlayerName,
DoB = c.DoB,
PlayerImageUrl = c.PlayerImageUrl,
Birthplace = c.Birthplace,
});
var model = new PlayerIndexModel
{
PlayerList = players
};
return(View(model));
}
public PlayerIndexModel GetPlayerIndexModel(string playerName, int?page)
{
PlayerIndexModel playerIndexModel = new PlayerIndexModel();
using (NetballEntities context = new NetballEntities())
{
playerIndexModel = context.TeamPlayers
.Include(t => t.Person)
.Include(t => t.Team)
.Select(t => new PlayerIndexModel
{
teamID = t.TeamID,
teamName = t.Team.TeamName
})
.FirstOrDefault();
}
if (playerIndexModel != null)
{
playerIndexModel.PlayerPagedList = GetPagedList(playerName, page);
}
return(playerIndexModel);
}
