示例#1
0
 public void GetTest()
 {
     if (TestCode.Text == "")
     {
         MessageBox.Show("Please Enter A Subject Code", "Error", MessageBoxButtons.OK, MessageBoxIcon.Information);
         TestCode.Focus();
         return;
     }
     try
     {
         var test = _testService.GetTestDetails(TestCode.Text);
         if (test != null)
         {
             _stateService.SetTestId(test.Id);
             this.Hide();
             var questionPage = Program.CreateServiceProvider().GetRequiredService <QuestionPage>();
             questionPage.ShowDialog();
         }
         else
         {
             MessageBox.Show("Wrong Passcode", "information!", MessageBoxButtons.OK,
                             MessageBoxIcon.Information);
         }
     }
     catch (SqlException exception)
     {
         MessageBox.Show(exception.Message, "information!", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
     }
 }
示例#2
0
        public void GetTest()
        {
            ConnectionString Dbconnect = new ConnectionString();

            if (TestCode.Text == "")
            {
                MessageBox.Show("Please Enter A Subject Code", "Error", MessageBoxButtons.OK, MessageBoxIcon.Information);
                TestCode.Focus();
                return;
            }
            try
            {
                SqlConnection connection = new SqlConnection();
                connection = new SqlConnection(Dbconnect.Connect());
                connection.Open();

                SqlCommand command = new SqlCommand();
                command = new SqlCommand("SELECT * FROM test WHERE testcode='" + TestCode.Text + "'", connection);
                SqlDataReader datareader = command.ExecuteReader();
                int           count      = 0;
                while (datareader.Read())
                {
                    count = count + 1;
                }
                datareader.Close();
                connection.Close();

                if (count == 1)
                {
                    this.Hide();
                    //QuestionPage questionPage = new QuestionPage();
                    //questionPage.Show();
                    QuestionPage question = new QuestionPage();
                    question.passCode = TestCode.Text.ToString();
                    question.Show();
                }
                else
                {
                    MessageBox.Show("Wrong Passcode", "information!", MessageBoxButtons.OK,
                                    MessageBoxIcon.Information);
                }
            }
            catch (SqlException exception)
            {
                MessageBox.Show(exception.Message, "information!", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
            }
        }