public void UploadResults(Result_tblDTO result_tbldto)
{
string approve = "NO";
string query = "INSERT INTO result_tbl (quiz_number,attendance_number,final,number,grade,year,student_id,course_id,approved,semester) VALUES('" + result_tbldto.QUIZ_NO + "','"
+ result_tbldto.ATTENDENCE_NO + "','"
+ result_tbldto.FINAL + "','"
+ result_tbldto.NUMBER + "','"
+ result_tbldto.GRADE + "','"
+ result_tbldto.YEAR + "','"
+ result_tbldto.STUDENT_ID + "','"
+ result_tbldto.COURSE_ID + "','"
+ approve + "','"
+ result_tbldto.SEMESTER + "')";
//open connection
if (dbconnect.OpenConnection() == true)
{
//create command and assign the query and connection from the constructor
MySqlCommand cmd = new MySqlCommand(query, dbconnect.connection);
//Execute command
cmd.ExecuteNonQuery();
//close connection
dbconnect.CloseConnection();
}
}
public DataSet getAllResults(Result_tblDTO result_tbldto)
{
string approved = "YES";
string query = "SELECT * FROM result_tbl WHERE student_id='" + result_tbldto.STUDENT_ID + "' and approved ='" + approved + "'";
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);
}
}
