public List<Player> GetPlayerByIDContest(Player player)
{
List<Player> PlayerList = new List<Player>();
string query = "SELECT pl.[Player_ID],pl.[Contest_ID],pl.[Player_Name],pl.[Player_Score],pl.[Color],pl.[Player_Sequence]"
+ " FROM [Player]pl"
+ " INNER JOIN Contest c ON c.Contest_ID = pl.Contest_ID"
//+ " INNER JOIN Phase ph ON ph.Contest_ID = c.Contest_ID"
+ " WHERE pl.[Contest_ID] = '" + player.IDContest + "' ORDER BY [Player_Sequence] ASC";
//ORDER BY [Player_Sequence] ASC
DataTable dt = DA.SelectDatabase(query);
if (dt != null)
{
foreach (DataRow item in dt.Rows)
{
Player Player = new Player();
Player.IDPlayer = Convert.ToInt32(item["Player_ID"].ToString());
Player.IDContest = Convert.ToInt32(item["Contest_ID"].ToString());
Player.PlayerName = item["Player_Name"].ToString();
Player.PlayerScore = Convert.ToInt32(item["Player_Score"].ToString());
Player.Color = item["Color"].ToString();
Player.Sequence = Convert.ToInt32(item["Player_Sequence"].ToString());
PlayerList.Add(Player);
}
}
return PlayerList;
}