private void buttonSubmit_Click(object sender, EventArgs e)
{
if (selectQuestionNoSystem == "Online")
{
if (radioButtonOptionA.Checked)
{
user_Answer = OptionA.ToLower().Replace(" ", "");
}
else if (radioButtonOptionB.Checked)
{
user_Answer = OptionB.ToLower().Replace(" ", "");
}
else if (radioButtonOptionC.Checked)
{
user_Answer = OptionC.ToLower().Replace(" ", "");
}
else if (radioButtonOptionD.Checked)
{
user_Answer = OptionD.ToLower().Replace(" ", "");
}
else
{
user_Answer = "";
}
//user_Answer = textBoxAnswer.Text.ToLower().Replace(" ", "");
right_Answer = right_Answer.ToLower().Replace(" ", "");
if (user_Answer == right_Answer)
{
point = 5;
UserInformation.setQuestionNO(QSN);
makeSolve.makeSolveStatus();
}
else if (user_Answer == "")
{
point = 0;
}
else if (user_Answer != right_Answer)
{
point = -2;
}
this.Hide();
InformationAnalysis ia = new InformationAnalysis();
ia.removeForm(point);
}
else if (selectQuestionNoSystem == "Offline")
{
if (radioButtonOptionA.Checked)
{
user_Answer = OptionA.ToLower().Replace(" ", "");
}
else if (radioButtonOptionB.Checked)
{
user_Answer = OptionB.ToLower().Replace(" ", "");
}
else if (radioButtonOptionC.Checked)
{
user_Answer = OptionC.ToLower().Replace(" ", "");
}
else if (radioButtonOptionD.Checked)
{
user_Answer = OptionD.ToLower().Replace(" ", "");
}
else
{
user_Answer = "";
}
//user_Answer = textBoxAnswer.Text.ToLower().Replace(" ", "");
right_Answer = right_Answer.ToLower().Replace(" ", "");
if (user_Answer == right_Answer)
{
UserInformation.setQuestionNO(QSN);
makeSolve.makeSolveStatus();
MessageBox.Show("Right Answer!");
this.Hide();
offlineInformationAnalysis oia = new offlineInformationAnalysis();
oia.removeForm();
}
else if (user_Answer == "")
{
MessageBox.Show("Answer is blank!");
}
else if (user_Answer != right_Answer)
{
MessageBox.Show("Wrong Answer!!");
}
}
}
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);
}
}
