private void buttonQuit_Click(object sender, EventArgs e) { this.Hide(); Question q = new Question(); q.ShowDialog(); }
private void button2_Click(object sender, EventArgs e) { timerKnowledge.Stop(); timerPicture.Stop(); this.Hide(); Question Q = new Question(); // OnlineQuestionImagePattern Q = new OnlineQuestionImagePattern(); Q.ShowDialog(); }
private void infoFileDownloadComplete(object sender, AsyncCompletedEventArgs e) { if (e.Error != null) { MessageBox.Show("Problem while Downloading!\nOr no internet connection.."); this.Hide(); Question q = new Question(); q.ShowDialog(); } }
public void OnetimeQuizChecker() { try { // step 1: Create a connection var result = Path.GetFullPath("InformationDatabase.mdf"); string strConnection = "Data Source=.\\sqlexpress;AttachDbFilename=" + result + ";User Instance=true;Integrated Security=True;Pooling=False"; SqlConnection objConnection = new SqlConnection(strConnection); objConnection.Open(); // step 2: fire a command string username = UserInformation.getUserName(); string quizno = onlineQuizSerialNo; string strCommand = "select QuizNo, userID from IndividualOnlineQuizTracker where QuizNo=@QN and userID=@UI"; SqlCommand objCommand = new SqlCommand(strCommand, objConnection); objCommand.Parameters.Add(new SqlParameter("@QN", quizno)); objCommand.Parameters.Add(new SqlParameter("@UI", username)); // step 3: bind the result data with user interface SqlDataReader reader = objCommand.ExecuteReader(); if (reader.Read()) { MessageBox.Show("You participated this quiz once! \n Please wait for the next round.."); this.Hide(); Question q = new Question(); q.ShowDialog(); } else { } reader.Close(); objConnection.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
public void removeForm() { ///total_score = total_score + point; myForm.RemoveAt(Form_track); myQuestionNo.RemoveAt(Form_track); if (myForm.Count == 0) { Question q = new Question(); q.ShowDialog(); } else if (Form_track >= myForm.Count) { Form_track = 0; callForm(); } else { callForm(); } }
private void buttonQuit_Click(object sender, EventArgs e) { this.Hide(); Question q = new Question(); q.ShowDialog(); }
private void button2_Click(object sender, EventArgs e) { timerKnowledge.Stop(); timerPicture.Stop(); this.Hide(); Question Q = new Question(); // OnlineQuestionImagePattern Q = new OnlineQuestionImagePattern(); Q.ShowDialog(); }
public void selectQuestionNo() { try { // step 1: Create a connection var result = Path.GetFullPath("InformationDatabase.mdf"); string strConnection = "Data Source=.\\sqlexpress;AttachDbFilename=" + result + ";User Instance=true;Integrated Security=True;Pooling=False;MultipleActiveResultSets=true"; SqlConnection objConnection = new SqlConnection(strConnection); objConnection.Open(); // step 2: fire a command string username = UserInformation.getUserName(); // string quizno = onlineQuizSerialNo; AllorUnsolved = UserInformation.getAllorSolved(); string strCommand = ""; if (AllorUnsolved == "Unsolved") { Unsolved = true; strCommand = "SELECT QSN FROM Question EXCEPT SELECT QSN FROM Solve WHERE userID=@UN"; } else if (AllorUnsolved == "All") { All = true; strCommand = "SELECT QSN FROM Question"; } SqlCommand objCommand = new SqlCommand(strCommand, objConnection); objCommand.Parameters.Add(new SqlParameter("@UN", username)); // step 3: bind the result data with user interface SqlDataReader reader = objCommand.ExecuteReader(); while (reader.Read()) { for (int i = 0; i < reader.FieldCount; i++) { unsolvedQuestion.Add(reader[i].ToString()); } } reader.Close(); objConnection.Close(); if (unsolvedQuestion.Count == 0 && Unsolved == true) { MessageBox.Show("You have no unsolved Questions!"); Unsolved = false; Question q = new Question(); q.ShowDialog(); } else if (unsolvedQuestion.Count == 0 && All == true) { MessageBox.Show("Please Update Questions!\nDatabase is empty."); All = false; Question q = new Question(); q.ShowDialog(); } makeValue(unsolvedQuestion); } catch (Exception ex) { MessageBox.Show(ex.Message); Question q = new Question(); q.ShowDialog(); //MessageBox.Show(ex.Message); } }
public void makeValue(List <string> QNo) { myQuestionNoTemp.Add(-5); try { for (int i = 0; i < QNo.Count; i++) { myQuestion.Add(QNo[i]); } // step 1: var result = Path.GetFullPath("InformationDatabase.mdf"); string strConnection = "Data Source=.\\sqlexpress;AttachDbFilename=" + result + ";User Instance=true;Integrated Security=True;Pooling=False"; SqlConnection objConnection = new SqlConnection(strConnection); objConnection.Open(); for (int i = 0; i < QNo.Count; i++) { int j = int.Parse(QNo[i]); string strCommand = "select QuestionType from Question where QSN=" + j + ""; SqlCommand objCommand = new SqlCommand(strCommand, objConnection); SqlDataReader reader = objCommand.ExecuteReader(); // myFormTemp.Enqueue(reader[0].ToString()); reader.Read(); var nextItem = reader[0].ToString(); reader.Close(); // MessageBox.Show(nextItem.ToString()); if (nextItem == "Picture Question") { // PictureQuestion pq = new PictureQuestion(); // myForm.Add(pq); myForm.Add(nextItem); myQuestionNo.Add(j); } else if (nextItem == "Picture Question Objective Type") { // ObjectiveImageQuestion oiq = new ObjectiveImageQuestion(); // myForm.Add(oiq); myForm.Add(nextItem); myQuestionNo.Add(j); } else if (nextItem == "Normal Question") { // NormalQuestion nq = new NormalQuestion(); //myForm.Add(nq); myForm.Add(nextItem); myQuestionNo.Add(j); } else if (nextItem == "Normal Question Objective Type") { // NormalObjectiveQuestion noq = new NormalObjectiveQuestion(); // myForm.Add(noq); myForm.Add(nextItem); myQuestionNo.Add(j); } else if (nextItem == "Descriptive Question (No Image)") { // MathNormalQuestion mnq = new MathNormalQuestion(); //myForm.Add(mnq); myForm.Add(nextItem); myQuestionNo.Add(j); } else if (nextItem == "Descriptive Question Objective Type (No Image)") { // MathObjectiveQuestion moq = new MathObjectiveQuestion(); // myForm.Add(moq); myForm.Add(nextItem); myQuestionNo.Add(j); } else if (nextItem == "Flash Question") { // FlashImageQuestion fiq = new FlashImageQuestion(); //myForm.Add(fiq); myForm.Add(nextItem); myQuestionNo.Add(j); } } objConnection.Close(); /* for (int i = 0; i < QNo.Length; i++) * { * Form newForm = myForm[i]; * newForm.Show(); * * }*/ Form_track = -1; total_score = 0; nextForm(); } catch (Exception ex) { MessageBox.Show(ex.Message); Question q = new Question(); q.ShowDialog(); } }
private void textFileDownloadComplete(object sender, AsyncCompletedEventArgs e) { if (e.Error != null) { MessageBox.Show("Problem while Downloading!\nOr no internet connection.."); this.Hide(); Question q = new Question(); q.ShowDialog(); } QuestionTextDownload(); }
public void OnetimeQuizChecker() { try { // step 1: Create a connection var result = Path.GetFullPath("InformationDatabase.mdf"); string strConnection = "Data Source=.\\sqlexpress;AttachDbFilename=" + result + ";User Instance=true;Integrated Security=True;Pooling=False"; SqlConnection objConnection = new SqlConnection(strConnection); objConnection.Open(); // step 2: fire a command string username = UserInformation.getUserName(); string quizno = onlineQuizSerialNo; string strCommand = "select QuizNo, userID from IndividualOnlineQuizTracker where QuizNo=@QN and userID=@UI"; SqlCommand objCommand = new SqlCommand(strCommand, objConnection); objCommand.Parameters.Add(new SqlParameter("@QN", quizno)); objCommand.Parameters.Add(new SqlParameter("@UI", username)); // step 3: bind the result data with user interface SqlDataReader reader = objCommand.ExecuteReader(); if (reader.Read()) { MessageBox.Show("You participated this quiz once! \n Please wait for the next round.."); this.Hide(); Question q = new Question(); q.ShowDialog(); } else { } reader.Close(); objConnection.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
public void selectQuestionNo() { try { // step 1: Create a connection var result = Path.GetFullPath("InformationDatabase.mdf"); string strConnection = "Data Source=.\\sqlexpress;AttachDbFilename=" + result + ";User Instance=true;Integrated Security=True;Pooling=False;MultipleActiveResultSets=true"; SqlConnection objConnection = new SqlConnection(strConnection); objConnection.Open(); // step 2: fire a command string username = UserInformation.getUserName(); // string quizno = onlineQuizSerialNo; AllorUnsolved = UserInformation.getAllorSolved(); string strCommand = ""; if (AllorUnsolved == "Unsolved") { Unsolved = true; strCommand = "SELECT QSN FROM Question EXCEPT SELECT QSN FROM Solve WHERE userID=@UN"; } else if (AllorUnsolved == "All") { All = true; strCommand = "SELECT QSN FROM Question"; } SqlCommand objCommand = new SqlCommand(strCommand, objConnection); objCommand.Parameters.Add(new SqlParameter("@UN", username)); // step 3: bind the result data with user interface SqlDataReader reader = objCommand.ExecuteReader(); while(reader.Read()) { for (int i = 0; i < reader.FieldCount; i++) { unsolvedQuestion.Add( reader[i].ToString()); } } reader.Close(); objConnection.Close(); if (unsolvedQuestion.Count == 0 && Unsolved == true) { MessageBox.Show("You have no unsolved Questions!"); Unsolved = false; Question q = new Question(); q.ShowDialog(); } else if (unsolvedQuestion.Count == 0 && All == true) { MessageBox.Show("Please Update Questions!\nDatabase is empty."); All = false; Question q = new Question(); q.ShowDialog(); } makeValue(unsolvedQuestion); } catch (Exception ex) { MessageBox.Show(ex.Message); Question q = new Question(); q.ShowDialog(); //MessageBox.Show(ex.Message); } }
public void removeForm() { ///total_score = total_score + point; myForm.RemoveAt(Form_track); myQuestionNo.RemoveAt(Form_track); if (myForm.Count == 0) { Question q = new Question(); q.ShowDialog(); } else if (Form_track >= myForm.Count) { Form_track = 0; callForm(); } else { callForm(); } }
public void makeValue(List<string> QNo) { myQuestionNoTemp.Add(-5); try { for (int i = 0; i < QNo.Count; i++) { myQuestion.Add(QNo[i]); } // step 1: var result = Path.GetFullPath("InformationDatabase.mdf"); string strConnection = "Data Source=.\\sqlexpress;AttachDbFilename=" + result + ";User Instance=true;Integrated Security=True;Pooling=False"; SqlConnection objConnection = new SqlConnection(strConnection); objConnection.Open(); for (int i = 0; i < QNo.Count; i++) { int j = int.Parse(QNo[i]); string strCommand = "select QuestionType from Question where QSN=" + j + ""; SqlCommand objCommand = new SqlCommand(strCommand, objConnection); SqlDataReader reader = objCommand.ExecuteReader(); // myFormTemp.Enqueue(reader[0].ToString()); reader.Read(); var nextItem = reader[0].ToString(); reader.Close(); // MessageBox.Show(nextItem.ToString()); if (nextItem == "Picture Question") { // PictureQuestion pq = new PictureQuestion(); // myForm.Add(pq); myForm.Add(nextItem); myQuestionNo.Add(j); } else if (nextItem == "Picture Question Objective Type") { // ObjectiveImageQuestion oiq = new ObjectiveImageQuestion(); // myForm.Add(oiq); myForm.Add(nextItem); myQuestionNo.Add(j); } else if (nextItem == "Normal Question") { // NormalQuestion nq = new NormalQuestion(); //myForm.Add(nq); myForm.Add(nextItem); myQuestionNo.Add(j); } else if (nextItem == "Normal Question Objective Type") { // NormalObjectiveQuestion noq = new NormalObjectiveQuestion(); // myForm.Add(noq); myForm.Add(nextItem); myQuestionNo.Add(j); } else if (nextItem == "Descriptive Question (No Image)") { // MathNormalQuestion mnq = new MathNormalQuestion(); //myForm.Add(mnq); myForm.Add(nextItem); myQuestionNo.Add(j); } else if (nextItem == "Descriptive Question Objective Type (No Image)") { // MathObjectiveQuestion moq = new MathObjectiveQuestion(); // myForm.Add(moq); myForm.Add(nextItem); myQuestionNo.Add(j); } else if (nextItem == "Flash Question") { // FlashImageQuestion fiq = new FlashImageQuestion(); //myForm.Add(fiq); myForm.Add(nextItem); myQuestionNo.Add(j); } } objConnection.Close(); /* for (int i = 0; i < QNo.Length; i++) { Form newForm = myForm[i]; newForm.Show(); }*/ Form_track = -1; total_score = 0; nextForm(); } catch (Exception ex) { MessageBox.Show(ex.Message); Question q = new Question(); q.ShowDialog(); } }