public DataSet getAllCourses(Course_tblDTO course_tbldto)
{
string query = "SELECT * FROM teacher_takes,course_tbl,teacher_tbl WHERE teacher_tbl.teacher_id=teacher_takes.teacher_id and teacher_takes.course_id=course_tbl.course_id and teacher_tbl.email='" + course_tbldto.EMAIL + "'";
if (dbconnect.OpenConnection() == true)
{
MySqlCommand cmd = new MySqlCommand(query, dbconnect.connection);
mysqlAdapter = new MySqlDataAdapter(cmd);
dataSet = new DataSet();
mysqlAdapter.Fill(dataSet);
dbconnect.CloseConnection();
return(dataSet);
}
else
{
return(dataSet);
}
}
public DataSet getStuId(Course_tblDTO course_tbldto)
{
string query = "SELECT * FROM student_takes WHERE year ='" + course_tbldto.YEAR + "' and semester ='" + course_tbldto.SEMESTER + "' and course_id ='" + course_tbldto.COURSE_ID + "'";
if (dbconnect.OpenConnection() == true)
{
MySqlCommand cmd = new MySqlCommand(query, dbconnect.connection);
mysqlAdapter = new MySqlDataAdapter(cmd);
dataSet = new DataSet();
mysqlAdapter.Fill(dataSet);
dbconnect.CloseConnection();
return(dataSet);
}
else
{
return(dataSet);
}
}
public DataSet getSem(Course_tblDTO course_tbldto)
{
//string query = "select distinct on year * from student_takes WHERE course_id ='" + course_tbldto.COURSE_ID + "'";
string query = "SELECT * from student_takes GROUP BY semester";
if (dbconnect.OpenConnection() == true)
{
MySqlCommand cmd = new MySqlCommand(query, dbconnect.connection);
mysqlAdapter = new MySqlDataAdapter(cmd);
dataSet = new DataSet();
mysqlAdapter.Fill(dataSet);
dbconnect.CloseConnection();
return(dataSet);
}
else
{
return(dataSet);
}
}
