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