CapDemo.BL.RecordBL.GetDoneGameByIDContest C# (CSharp) Method

        public List<Record> GetDoneGameByIDContest(Record record)
        {
            List<Record> RecordList = new List<Record>();
            string query = "SELECT [First]"
                        + " FROM [Record]"
                        + " WHERE [Contest_ID] = '" + record.IDContest + "' AND [Player_ID] = '" + record.IDPlayer + "'";
            DataTable dt = DA.SelectDatabase(query);
            //int i = 1;
            if (dt != null)
            {
                foreach (DataRow item in dt.Rows)
                {
                    Record Record = new Record();
                    Record.First = (bool)(item["First"]);
                    RecordList.Add(Record);
                }
            }
            return RecordList;
        }