private void loadReq() { int[] reqIds = StudentModel.getReq_ids(); foreach (int id in reqIds) { requirementmodel req = schoolRequirementsController.getRequirementModel(id); listModel.Add(req); } LoadListParams(); }
public requirementmodel getRequirementModel(int id) { string sql = String.Format(@"SELECT * FROM school_requirements WHERE req_id = {0}", id); MySqlDataReader reader = null; cs.RetrieveRecords(sql, ref reader); requirementmodel req = new requirementmodel(); while (reader.Read()) { req.name = reader["requirement_name"].ToString(); req.id = int.Parse(reader["req_id"].ToString()); req.type = reader["type_of_student"].ToString(); } cs.CloseConnection(); return(req); }