public void GetPlayerByID(int playerID) { List <FFPlayers> listPlayers = new List <FFPlayers>(); DataTable dt = (DataTable)Session["tempTable"]; var results = from row in dt.AsEnumerable() where row.Field <int>("PlayerId") == playerID select new { PlayerId = row.Field <int>("PlayerId"), PositionId = row.Field <int>("PositionId"), Position = row.Field <string>("Position"), FirstName = row.Field <string>("FirstName"), LastName = row.Field <string>("LastName"), TeamId = row.Field <int>("TeamId"), Team = row.Field <string>("Team") }; foreach (var result in results) { FFPlayers player = new FFPlayers(); player.PlayerId = result.PlayerId; player.PositionId = result.PositionId; player.Position = result.Position; player.FirstName = result.FirstName; player.LastName = result.LastName; player.TeamId = result.TeamId; player.Team = result.Team; listPlayers.Add(player); } JavaScriptSerializer js = new JavaScriptSerializer(); Context.Response.Write(js.Serialize(listPlayers)); }
public void GetAllPlayers() { List <FFPlayers> listPlayers = new List <FFPlayers>(); PopulateDataTable(); var results = from row in dt.AsEnumerable() select new { PlayerId = row.Field <int>("PlayerId"), LastName = row.Field <string>("LastName"), FirstName = row.Field <string>("FirstName"), FullName = row.Field <string>("FullName"), JerseyNumber = row.Field <int>("JerseyNumber"), PositionId = row.Field <int>("PositionId"), Position = row.Field <string>("Position"), TeamId = row.Field <int>("TeamId"), Team = row.Field <string>("Team"), ByeWeek = row.Field <int>("ByeWeek"), PositionRank = row.Field <int>("PositionRank"), OverallRank = row.Field <int>("OverallRank") }; foreach (var result in results) { FFPlayers player = new FFPlayers(); player.PlayerId = result.PlayerId; player.LastName = result.LastName; player.FirstName = result.FirstName; player.FullName = result.FullName; player.JerseyNumber = result.JerseyNumber; player.PositionId = result.PositionId; player.Position = result.Position; player.TeamId = result.TeamId; player.Team = result.Team; player.ByeWeek = result.ByeWeek; player.PositionRank = result.PositionRank; player.OverallRank = result.OverallRank; listPlayers.Add(player); } JavaScriptSerializer js = new JavaScriptSerializer(); Context.Response.Write(js.Serialize(listPlayers)); }