CapDemo.BL.PlayerBL.GetPlayerByIDplayer C# (CSharp) Метод

        public List<Player> GetPlayerByIDplayer(Player player)
        {
            List<Player> PlayerList = new List<Player>();
            string query = "SELECT [Player_ID],[Contest_ID],[Player_Name],[Player_Score],[Color],[Player_Sequence]"
                        + " FROM [Player]"
                        + " WHERE  [Player_ID] = '"+player.IDPlayer+"'";
            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;
        }