}//End of Load public List <Grading> LoadSubjects() { try { //prepare connection string using (MySqlConnection con = new MySqlConnection(GOCSystem2018.Config.GetConnectionString())) { //try to open connection con.Open(); //prepare sql query string sql = "SELECT subject_code FROM grading "; //IDNo = @studentId and grading WHERE subject_Code=@subjectCode and term=@term and grade_level=@gradeLevel, section=@section MySqlCommand cmd = new MySqlCommand(sql, con); //cmd.Parameters.AddWithValue("studentId", studentId); //cmd.Parameters.AddWithValue("subjectCode", subjectCode); //cmd.Parameters.AddWithValue("term", term); //cmd.Parameters.AddWithValue("gradeLevel", gradeLevel); //cmd.Parameters.AddWithValue("section", section); //cmd.Parameters.AddWithValue("strand", strand); MySqlDataReader reader = cmd.ExecuteReader(); //loop while have record while (reader.Read()) { //instantiate model Grading grade = new Grading(); //prepare properties grade.id = Convert.ToInt32(reader["id"].ToString()); grade.studentId = reader["IDNo"].ToString(); //grade.fullName = reader["full_name"].ToString(); grade.subjectCode = reader["subject_code"].ToString(); //grade.subjectDesc = reader["subject_desc"].ToString(); //grade.units = reader["units"].ToString(); //grade.firstQ = Convert.ToDouble(reader["1stQ"].ToString()); //grade.secondQ = Convert.ToDouble(reader["2ndQ"].ToString()); //grade.average = Convert.ToDouble(reader["average"].ToString()); //grade.remarks = reader["remarks"].ToString(); //grade.term = reader["term"].ToString(); //grade.gradeLevel = reader["grade_level"].ToString(); //grade.section = reader["section"].ToString(); //grade.strand = reader["strand"].ToString(); grades.Add(grade); } } } catch (MySqlException ex) { MessageBox.Show("ERROR : " + ex.ToString(), "System Message", MessageBoxButtons.OK, MessageBoxIcon.Error); } return(grades); }//End of Load
public List <Grading> Load() { try { using (MySqlConnection con = new MySqlConnection(GOCSystem2018.Config.GetConnectionString())) { con.Open(); string sql = "SELECT * FROM grading"; MySqlCommand cmd = new MySqlCommand(sql, con); MySqlDataReader reader = cmd.ExecuteReader(); //loop while have record while (reader.Read()) { //instantiate model Grading grade = new Grading(); //prepare properties grade.id = Convert.ToInt32(reader["id"].ToString()); grade.studentId = reader["IDNo"].ToString(); grade.fullName = reader["full_name"].ToString(); grade.subjectCode = reader["subject_code"].ToString(); grade.subjectDesc = reader["subject_desc"].ToString(); grade.units = reader["units"].ToString(); grade.firstQ = Convert.ToDouble(reader["1stQ"].ToString()); grade.secondQ = Convert.ToDouble(reader["2ndQ"].ToString()); grade.average = Convert.ToDouble(reader["average"].ToString()); grade.remarks = reader["remarks"].ToString(); grade.term = reader["term"].ToString(); grade.gradeLevel = reader["grade_level"].ToString(); grade.section = reader["section"].ToString(); grade.strand = reader["strand"].ToString(); grades.Add(grade); } } } catch (MySqlException ex) { MessageBox.Show("ERROR : " + ex.ToString(), "GOCINFOSYS", MessageBoxButtons.OK, MessageBoxIcon.Error); } return(grades); }//End of Load