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