public List <TeamDetails> GetTeam(int id) { using (FintellixPremierLeagueEntities FplDbEntities = new FintellixPremierLeagueEntities()) { var data = FplDbEntities.getTeamDetailsByTeamID(id).ToList(); var groupedTeam = data.GroupBy(m => m.TeamID).Select(m => new { TeamID = m.Key, PlayersInTeam = m.ToList(), TeamName = m.FirstOrDefault().TeamName, OwnerName = m.FirstOrDefault().OwnerName, CaptainID = m.FirstOrDefault().CaptainID, CaptainName = m.FirstOrDefault().CaptainName }); List <TeamDetails> allTeams = new List <TeamDetails>(); foreach (var team in groupedTeam) { TeamDetails teamData = new TeamDetails(); teamData.PlayersInTeam = new List <PlayerInfo>(); teamData.TeamID = team.TeamID; teamData.TeamName = team.TeamName; teamData.OwnerName = team.OwnerName; teamData.CaptainID = team.CaptainID; teamData.CaptainName = team.CaptainName; foreach (var player in team.PlayersInTeam) { PlayerInfo playerDetails = new PlayerInfo(); playerDetails.PlayerID = player.PlayerID; playerDetails.PlayerName = player.PlayerName; playerDetails.BattingStyle = player.BattingStyle; playerDetails.BowlingStyle = player.BowlingStyle; playerDetails.Bio = player.Bio; playerDetails.AuctionedPrice = player.AuctionedPrice ?? default(int); teamData.PlayersInTeam.Add(playerDetails); } allTeams.Add(teamData); } return(allTeams); } }
public IEnumerable <TeamDetails> GetAllTeam() { using (FintellixPremierLeagueEntities FplDbEntities = new FintellixPremierLeagueEntities()) { var data = FplDbEntities.getAllTeamDetails().ToList(); var groupedTeams = data.GroupBy(m => m.TeamID).Select(m => new { TeamID = m.Key, PlayersInTeam = m.ToList(), TeamName = m.FirstOrDefault().TeamName, OwnerName = m.FirstOrDefault().OwnerName, CaptainID = m.FirstOrDefault().CaptainID, CaptainName = m.FirstOrDefault().CaptainName }); List <TeamDetails> allTeams = new List <TeamDetails>(); foreach (var team in groupedTeams) { TeamDetails teamData = new TeamDetails(); teamData.PlayersInTeam = new List <PlayerInfo>(); teamData.TeamID = team.TeamID; teamData.TeamName = team.TeamName; teamData.OwnerName = team.OwnerName; teamData.CaptainID = team.CaptainID; teamData.CaptainName = team.CaptainName; foreach (var player in team.PlayersInTeam) { PlayerInfo playerDetails = new PlayerInfo(); playerDetails.PlayerID = player.PlayerID; playerDetails.PlayerName = player.PlayerName; teamData.PlayersInTeam.Add(playerDetails); } allTeams.Add(teamData); } return(allTeams); } }
public IEnumerable <getAllTeamList_Result> getTeamList() { using (FintellixPremierLeagueEntities FplDbEntities = new FintellixPremierLeagueEntities()) { return(FplDbEntities.getAllTeamList().ToList()); } }
public PlayerInfo Get(int id) { using (FintellixPremierLeagueEntities FplDbEntities = new FintellixPremierLeagueEntities()) { var data = FplDbEntities.getAuctionablePlayerById(id).ToList(); PlayerInfo player = new PlayerInfo(); player.AuctionID = data[0].AuctionID; player.PlayerID = data[0].PlayerID; player.PlayerName = data[0].PlayerName; player.BattingStyle = data[0].BattingStyle; player.BowlingStyle = data[0].BowlingStyle; player.BasePrice = data[0].BasePrice; player.AuctionedPrice = data[0].AuctionedPrice ?? default(int); return(player); } }
// DELETE api/values/5 public HttpResponseMessage RemovePlayer([FromBody] AddPlayerViewModel model) { try { using (FintellixPremierLeagueEntities FplDbEntities = new FintellixPremierLeagueEntities()) { FplDbEntities.removePlayer(model.TeamID, model.PlayerID, model.Year); var msg = Request.CreateResponse(HttpStatusCode.OK, model); msg.Headers.Location = new Uri(Request.RequestUri + model.ToString()); return(msg); } } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex)); } }
public IEnumerable <PlayerInfo> Get() { using (FintellixPremierLeagueEntities FplDbEntities = new FintellixPremierLeagueEntities()) { var data = FplDbEntities.GetAllAuctionablePlayersDetails().ToList(); List <PlayerInfo> allPlayers = new List <PlayerInfo>(); foreach (var player in data) { PlayerInfo playerData = new PlayerInfo(); playerData.AuctionID = player.AuctionID; playerData.PlayerID = player.PlayerID; playerData.PlayerName = player.PlayerName; playerData.BattingStyle = player.BattingStyle; playerData.BowlingStyle = player.BowlingStyle; playerData.BasePrice = player.BasePrice; playerData.AuctionedPrice = player.AuctionedPrice ?? default(int); allPlayers.Add(playerData); } return(allPlayers); } }