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);
}
