public static string GetEssayAnswer(int questionid)
{
MySqlConnection con = new MyConnection().getConnection();
con.Open();
string answer = "";
string query = "SELECT answers.Answer FROM answers WHERE answers.QuestionID=" + questionid + " ";
MySqlDataAdapter da = new MySqlDataAdapter(query, con);
DataTable dt = new DataTable();
da.Fill(dt);
foreach (DataRow dr in dt.Rows)
{
answer = dr[0].ToString();
}
return(answer);
}
public static void GetObjectives(int userId)
{
MySqlConnection con = new MyConnection().getConnection();
con.Open();
string query = "SELECT exam_answers.Answer FROM exam_answers WHERE exam_answers.UserID=" + userId + " ";
MySqlDataAdapter da = new MySqlDataAdapter(query, con);
DataTable dt = new DataTable();
da.Fill(dt);
int x = 0;
foreach (DataRow dr in dt.Rows)
{
x++;
objectives[x] = dr[0].ToString();
}
}
/// <summary>
/// GET THE TOTAL NUMBER OF QUESTIONS THAT WAS LOADED
/// </summary>
/// <returns></returns>
public static int getLast()
{
MySqlConnection con = new MyConnection().getConnection();
string TotalQuestion = "SELECT COUNT(QuestionID) FROM questions";
con.Open();
MySqlDataAdapter adapter = new MySqlDataAdapter(TotalQuestion, con);
DataTable dt = new DataTable();
adapter.Fill(dt);
var last = 0;
int x = dt.Rows.Count;
if (x > 0)
{
foreach (DataRow dr in dt.Rows)
{
last = Int32.Parse(dr[0].ToString());
}
}
return(lastQuestion = last);
}
public static int NumberOfQuestion()
{
MySqlConnection con = new MyConnection().getConnection();
string TotalQuestionNo = "SELECT No_of_questions FROM set_exam";
con.Open();
MySqlDataAdapter adapter = new MySqlDataAdapter(TotalQuestionNo, con);
DataTable dt = new DataTable();
adapter.Fill(dt);
var Number = 0;
int x = dt.Rows.Count;
if (x > 0)
{
foreach (DataRow dr in dt.Rows)
{
Number = Int32.Parse(dr[0].ToString());
}
}
return(Number);
}
