public static StudentCourse FindById(int searchId) { int id = 0; int studentId = 0; int courseId = 0; MySqlConnection conn = DB.Connection(); conn.Open(); MySqlCommand cmd = conn.CreateCommand() as MySqlCommand; cmd.CommandText = @"SELECT * FROM students_courses WHERE id = @idMatch;"; MySqlParameter parameterId = new MySqlParameter(); parameterId.ParameterName = "@idMatch"; parameterId.Value = searchId; cmd.Parameters.Add(parameterId); MySqlDataReader rdr = cmd.ExecuteReader() as MySqlDataReader; while (rdr.Read()) { id = rdr.GetInt32(0); studentId = rdr.GetInt32(1); courseId = rdr.GetInt32(2); } StudentCourse foundStudentCourse = new StudentCourse(studentId, courseId, id); conn.Close(); if (conn != null) { conn.Dispose(); } return(foundStudentCourse); }
public static List <StudentCourse> GetAll() { List <StudentCourse> newStudentCourses = new List <StudentCourse> { }; MySqlConnection conn = DB.Connection(); conn.Open(); MySqlCommand cmd = conn.CreateCommand() as MySqlCommand; cmd.CommandText = @"SELECT * FROM students_courses;"; MySqlDataReader rdr = cmd.ExecuteReader() as MySqlDataReader; while (rdr.Read()) { int id = rdr.GetInt32(0); int studentId = rdr.GetInt32(1); int courseId = rdr.GetInt32(2); StudentCourse newStudentCourse = new StudentCourse(studentId, courseId, id); newStudentCourses.Add(newStudentCourse); } conn.Close(); if (conn != null) { conn.Dispose(); } return(newStudentCourses); }
public override bool Equals(System.Object otherStudentCourse) { if (!(otherStudentCourse is StudentCourse)) { return(false); } else { StudentCourse newStudentCourse = (StudentCourse)otherStudentCourse; bool idEquality = (this.GetId() == newStudentCourse.GetId()); bool studentIDEquality = (this.GetStudentID() == newStudentCourse.GetStudentID()); bool courseIDEquality = (this.GetCourseID() == newStudentCourse.GetCourseID()); return(idEquality && studentIDEquality && courseIDEquality); } }