public static List <CourseClass> FindById(int id)
{
List <CourseClass> currentCourse = new List <CourseClass> {
};
MySqlConnection conn = DB.Connection();
conn.Open();
MySqlCommand cmd = conn.CreateCommand() as MySqlCommand;
cmd.CommandText = @"SELECT * FROM courses WHERE id = " + id + ";";
MySqlDataReader rdr = cmd.ExecuteReader() as MySqlDataReader;
while (rdr.Read())
{
int idz = rdr.GetInt32(0);
string name = rdr.GetString(1);
string code = rdr.GetString(2);
CourseClass newCourse = new CourseClass(name, code, idz);
currentCourse.Add(newCourse);
}
conn.Close();
if (conn != null)
{
conn.Dispose();
}
return(currentCourse);
}
public static List <CourseClass> GetAll()
{
List <CourseClass> allCourses = new List <CourseClass> {
};
MySqlConnection conn = DB.Connection();
conn.Open();
var cmd = conn.CreateCommand() as MySqlCommand;
cmd.CommandText = @"SELECT * FROM courses;";
MySqlDataReader rdr = cmd.ExecuteReader() as MySqlDataReader;
while (rdr.Read())
{
int id = rdr.GetInt32(0);
string name = rdr.GetString(1);
string code = rdr.GetString(2);
CourseClass newCourse = new CourseClass(name, code, id);
allCourses.Add(newCourse);
}
conn.Close();
if (conn != null)
{
conn.Dispose();
}
return(allCourses);
}
public static List <CourseClass> GetCoursesByStudentId(int studentId)
{
List <CourseClass> allCourses = new List <CourseClass> {
};
MySqlConnection conn = DB.Connection();
conn.Open();
var cmd = conn.CreateCommand() as MySqlCommand;
cmd.CommandText = @"SELECT courses.* FROM
courses JOIN students_courses ON (courses.id = students_courses.course_id)
JOIN students ON (students_courses.student_id = students.id)
WHERE students.id = " + studentId + ";";
MySqlDataReader rdr = cmd.ExecuteReader() as MySqlDataReader;
while (rdr.Read())
{
int id = rdr.GetInt32(0);
string name = rdr.GetString(1);
string code = rdr.GetString(2);
CourseClass newCourse = new CourseClass(name, code, id);
allCourses.Add(newCourse);
}
conn.Close();
if (conn != null)
{
conn.Dispose();
}
return(allCourses);
}