CapDemo.BL.LogBL.GetLogByIdContest C# (CSharp) Метод

        public List<Log> GetLogByIdContest(Log log)
        {
            List<Log> LogList = new List<Log>();
            string query = "SELECT [Contest_ID],[Player_ID],[Phase_ID],[Player_Score],[True],[False],[Exist]"
                        + " FROM [Log]"
                        + " WHERE Contest_ID = '"+log.ContestID+"'";
            DataTable dt = DA.SelectDatabase(query);
            if (dt != null)
            {
                foreach (DataRow item in dt.Rows)
                {
                    Log Log = new Log();
                    Log.ContestID = Convert.ToInt32(item["Contest_ID"].ToString());
                    Log.PlayerID = Convert.ToInt32(item["Player_ID"].ToString());
                    Log.PhaseID = Convert.ToInt32(item["Phase_ID"].ToString());
                    Log.PlayerScore = Convert.ToInt32(item["Player_Score"].ToString());
                    Log.CurrentNumofTrue = Convert.ToInt32(item["True"].ToString());
                    Log.CurrentNumofFalse = Convert.ToInt32(item["False"].ToString());
                    Log.Exist = (bool)item["Exist"];

                    LogList.Add(Log);
                }
            }
            return LogList;
        }