CapDemo.BL.RecordBL.GetRecordByIDContest C# (CSharp) Метод

        public List<Record> GetRecordByIDContest(Record record)
        {
            List<Record> RecordList = new List<Record>();
            string query = "SELECT [Contest_ID],[Player_ID],[Phase_ID],[NumofCorrect],[NumofIncorrect],[Defy],[Support],[Exist],[PhaseIndex],"
                        + "[PlayerScore],[TotalCorrect],[PlayerSequence],[PM],[Undie],[PlayerTurn],[Turn],[Done],[First],[Sub]"
                        + " FROM [Record]"
                        + " WHERE [Contest_ID] = '" + record.IDContest + "' ORDER BY [PlayerSequence] ASC";
            DataTable dt = DA.SelectDatabase(query);
            //int i = 1;
            if (dt != null)
            {
                foreach (DataRow item in dt.Rows)
                {
                    Record Record = new Record();
                    Record.IDContest = Convert.ToInt32(item["Contest_ID"].ToString());
                    Record.IDPlayer = Convert.ToInt32(item["Player_ID"].ToString());
                    Record.IDPhase = Convert.ToInt32(item["Phase_ID"].ToString());
                    Record.NumPass = Convert.ToInt32(item["NumofCorrect"].ToString());
                    Record.NumFail = Convert.ToInt32(item["NumofIncorrect"].ToString());
                    Record.Defy = (bool)(item["Defy"]);
                    Record.Support = (bool)(item["Support"]);
                    Record.Exist = (bool)(item["Exist"]);
                    Record.PhaseIndex = Convert.ToInt32(item["PhaseIndex"].ToString());
                    Record.TeamScore = Convert.ToInt32(item["PlayerScore"].ToString());
                    Record.TotalPass = Convert.ToInt32(item["TotalCorrect"].ToString());
                    Record.SequecePlayer = Convert.ToInt32(item["PlayerSequence"].ToString());
                    Record.PM = (bool)(item["PM"]);
                    Record.Undie = (bool)(item["Undie"]);
                    Record.PlayerTurn = (bool)(item["PlayerTurn"]);
                    Record.Turn = Convert.ToInt32(item["Turn"].ToString());
                    //
                    Record.Done = (bool)(item["Done"]);
                    Record.First = (bool)(item["First"]);
                    Record.Sub = Convert.ToInt32(item["Sub"].ToString());

                    RecordList.Add(Record);
                }
            }
            return RecordList;
        }