public List <Score> getScore(string Condition) { string sql; DataTable tb = null; List <Score> scores = new List <Score>(); if (Condition == null || Condition.Equals("")) { sql = "SELECT * FROM score"; tb = MysqlHelper.ExecuteDataTable(sql); if (tb.Rows.Count > 0) { foreach (DataRow dr in tb.Rows) { Score score = new Score(); score.Id = dr["ID"].ToString(); int userId = Int32.Parse(dr["UserId"].ToString()); //score.User = (new UserDBHelper()).getUser(userId, (short)RoleType.studentCheckbox); score.SubOne = float.Parse(dr["SubOne"].ToString()); score.SubTwo = float.Parse(dr["SubTwo"].ToString()); score.Score1 = float.Parse(dr["Score"].ToString()); score.Date = DateTime.Parse(dr["date"].ToString()); scores.Add(score); } } } else { UserDBHelper db = new UserDBHelper(); List <User> users = db.getUser(Condition, RoleType.studentCheckbox); foreach (User user in users) { MySqlParameter[] pars = null; sql = "SELECT * FROM score WHERE UserId = @Param1"; MySqlParameter p1 = new MySqlParameter("@Param1", MySqlDbType.String); p1.Value = user.Id; pars = new MySqlParameter[] { p1 }; tb = MysqlHelper.ExecuteDataTable(sql, pars); if (tb.Rows.Count > 0) { foreach (DataRow dr in tb.Rows) { Score score = new Score(); score.Id = dr["ID"].ToString(); score.User = user; score.SubOne = float.Parse(dr["SubOne"].ToString()); score.SubTwo = float.Parse(dr["SubTwo"].ToString()); score.Score1 = float.Parse(dr["Score"].ToString()); score.Date = DateTime.Parse(dr["date"].ToString()); scores.Add(score); } } } } MysqlHelper.CloseConn(); return(scores); }