public static QuizInfo GetInformation()
{
OleDbCommand cmd;
OleDbDataReader reader;
QuizInfo quizInfo = new QuizInfo();
cmd = new OleDbCommand("SELECT * FROM QGEN_DATA;", conn);
reader = cmd.ExecuteReader();
while(reader.Read()) {
quizInfo.Name = reader.GetString(0);
quizInfo.Date = reader.GetDateTime(1);
quizInfo.Number = int.Parse(reader.GetValue(2).ToString());
string strQuizTime = reader.GetValue(3).ToString();
string[] quizTime = strQuizTime.Substring(strQuizTime.IndexOf(' ') + 1).Split(':');
quizInfo.Time = new TimeSpan(int.Parse(quizTime[0]), int.Parse(quizTime[1]), 0);
quizInfo.PassingGrade = float.Parse(reader.GetValue(4).ToString());
quizInfo.Subject = reader.GetString(5);
quizInfo.Instructor = reader.GetString(6);
quizInfo.Class = reader.GetString(7);
quizInfo.School = reader.GetString(8);
}
return quizInfo;
}
public static QuizInfo GetInformation()
{
OleDbCommand cmd;
OleDbDataReader reader;
QuizInfo quizInfo = new QuizInfo();
cmd = new OleDbCommand("SELECT * FROM QGEN_DATA;", conn);
reader = cmd.ExecuteReader();
while (reader.Read())
{
quizInfo.Name = reader.GetString(0);
quizInfo.Date = reader.GetDateTime(1);
quizInfo.Number = int.Parse(reader.GetValue(2).ToString());
string strQuizTime = reader.GetValue(3).ToString();
string[] quizTime = strQuizTime.Substring(strQuizTime.IndexOf(' ') + 1).Split(':');
quizInfo.Time = new TimeSpan(int.Parse(quizTime[0]), int.Parse(quizTime[1]), 0);
quizInfo.PassingGrade = float.Parse(reader.GetValue(4).ToString());
quizInfo.Subject = reader.GetString(5);
quizInfo.Instructor = reader.GetString(6);
quizInfo.Class = reader.GetString(7);
quizInfo.School = reader.GetString(8);
}
return(quizInfo);
}
public static void SetInformation(QuizInfo info)
{
OleDbCommand cmd;
cmd = new OleDbCommand("DELETE * FROM QGEN_DATA;", conn);
cmd.ExecuteNonQuery();
cmd = new OleDbCommand(
String.Format("INSERT INTO QGEN_DATA VALUES('{0}', '{1}', {2}, '{3}', '{4}', '{5}', '{6}', '{7}', '{8}');",
info.Name.Replace("'", "''"),
info.Date,
info.Number,
info.Time.ToString(),
info.PassingGrade,
info.Subject.Replace("'", "''"),
info.Instructor.Replace("'", "''"),
info.Class.Replace("'", "''"),
info.School.Replace("'", "''")
), conn);
cmd.ExecuteNonQuery();
}
public static void SetInformation(QuizInfo info)
{
OleDbCommand cmd;
cmd = new OleDbCommand("DELETE * FROM QGEN_DATA;", conn);
cmd.ExecuteNonQuery();
cmd = new OleDbCommand(
String.Format("INSERT INTO QGEN_DATA VALUES('{0}', '{1}', {2}, '{3}', '{4}', '{5}', '{6}', '{7}', '{8}');",
info.Name.Replace("'", "''"),
info.Date,
info.Number,
info.Time.ToString(),
info.PassingGrade,
info.Subject.Replace("'", "''"),
info.Instructor.Replace("'", "''"),
info.Class.Replace("'", "''"),
info.School.Replace("'", "''")
), conn);
cmd.ExecuteNonQuery();
}
/// <summary>
/// Opens a quiz file.
/// </summary>
private void OpenQuiz()
{
QGenDB.Connect(this.filename);
object[] row;
ClearAllLists();
for(int i = 0; i < QGenDB.GetNumberOfRows("MC"); i++) {
row = QGenDB.RetrieveQuestion(i)["MC"];
AddToList(
i,
row[0].ToString(),
row[1].ToString(),
row[2].ToString(),
row[3].ToString(),
row[4].ToString(),
row[5].ToString()
);
}
for(int i = 0; i < QGenDB.GetNumberOfRows("TF"); i++) {
row = QGenDB.RetrieveQuestion(i)["TF"];
AddToList(
i,
row[0].ToString(),
bool.Parse(row[1].ToString())
);
}
quizInfo = QGenDB.GetInformation();
UpdateQuizInformation();
this.tabTest.SelectedIndex = 0;
UpdateLength();
UpdateEditPanel();
ShowLastQuestion();
QGenDB.Disconnect();
}
