private void button2_Click(object sender, EventArgs e)
{
Userpage u1 = new Userpage(g1);
u1.Show();
this.Hide();
}
private void button1_Click(object sender, EventArgs e)
{
SqlConnection conn = new SqlConnection("Server=.\\SQLEXPRESS; Database= ExamManager;Integrated Security =true");
conn.Open();
query = "'" + textBox1.Text + "'";
SqlCommand cmd = new SqlCommand("select password,status from login where username="******"", conn);
SqlDataReader dr = cmd.ExecuteReader();
if (dr.Read())
{
if ((textBox2.Text.ToString() == dr.GetString(0).ToString()))
{
if ("Approved" == dr.GetString(1).ToString())
{
Userpage s1 = new Userpage(textBox1.Text);
s1.Show();
this.Hide();
}
else
{
MessageBox.Show("Verification Pending!");
}
}
else
{
MessageBox.Show("Incorrect Password");
}
}
conn.Close();
}
public QA(String str, String snr)
{
InitializeComponent();
s1 = "'" + str + "'";
s2 = "'" + snr + "'";
listBox1.Hide();
label3.Hide();
total = counts();
if (i == total)
{
MessageBox.Show("No Questions in this category. please select another!");
SqlConnection conn = new SqlConnection("Server=.\\SQLEXPRESS; Database= ExamManager;Integrated Security =true");
conn.Open();
SqlCommand cmd = new SqlCommand(@"select username from login where name=" + s2 + "", conn);
SqlDataReader dr = cmd.ExecuteReader();
if (dr.Read())
{
z1 = dr.GetString(0).ToString();
}
Userpage u1 = new Userpage(z1);
u1.Show();
this.Hide();
}
else
{
label3.Text = "Score =" + count + "";
SqlConnection conn = new SqlConnection("Server=.\\SQLEXPRESS; Database= ExamManager;Integrated Security =true");
conn.Open();
SqlCommand cmd = new SqlCommand(@"select Qno,question,option1,option2,option3,option4,answer from login where Qno=" + i + "and category=" + s1 + "", conn);
SqlDataReader dr = cmd.ExecuteReader();
if (dr.Read())
{
label1.Text = dr.GetInt32(0).ToString();
label2.Text = dr.GetString(1).ToString();
radioButton1.Text = dr.GetString(2).ToString();
radioButton2.Text = dr.GetString(3).ToString();
radioButton3.Text = dr.GetString(4).ToString();
radioButton4.Text = dr.GetString(5).ToString();
}
conn.Close();
}
}
private void button1_Click(object sender, EventArgs e)
{
if (first == 0)
{
SqlConnection connn = new SqlConnection("Server=.\\SQLEXPRESS; Database= ExamManager;Integrated Security =true");
connn.Open();
SqlCommand cmdn = new SqlCommand("select Qno,question,option1,option2,option3,option4,answer from login where Qno=" + i + "and category=" + s1 + "", connn);
SqlDataReader drr = cmdn.ExecuteReader();
if (drr.Read())
{
label1.Text = drr.GetInt32(0).ToString();
label2.Text = drr.GetString(1).ToString();
radioButton1.Text = drr.GetString(2).ToString();
radioButton2.Text = drr.GetString(3).ToString();
radioButton3.Text = drr.GetString(4).ToString();
radioButton4.Text = drr.GetString(5).ToString();
{
if (radioButton1.Checked == true)
{
if (radioButton1.Text.ToString() == drr.GetString(6).ToString())
{
count++;
label3.Text = "Score =" + count + "";
}
}
if (radioButton2.Checked == true)
{
if (radioButton2.Text.ToString() == drr.GetString(6).ToString())
{
count++;
label3.Text = "Score =" + count + "";
}
}
if (radioButton3.Checked == true)
{
if (radioButton3.Text.ToString() == drr.GetString(6).ToString())
{
count++;
label3.Text = "Score =" + count + "";
}
}
if (radioButton4.Checked == true)
{
if (radioButton4.Text.ToString() == drr.GetString(6).ToString())
{
count++;
label3.Text = "Score =" + count + "";
}
}
}
first++;
i++;
}
}
if (i == total)
{
label3.Show();
MessageBox.Show("Test Completed Successfully!");
SqlConnection conn = new SqlConnection("Server=.\\SQLEXPRESS; Database= ExamManager;Integrated Security =true");
conn.Open();
SqlCommand cmd = new SqlCommand("select ctgr,uname from login where uname=" + s2 + "and ctgr=" + s1 + "", conn);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
if (dt.Rows.Count > 0)
{
cmd.CommandText = "update login set score=" + count + "where uname=" + s2 + "and ctgr=" + s1 + "";
cmd.ExecuteNonQuery();
}
else
{
String f1 = "" + count + "," + s1 + "," + s2 + "";
cmd.CommandText = @"insert into login(score,ctgr,uname) values(" + f1 + ")";
cmd.ExecuteNonQuery();
}
cmd.CommandText = "select username from login where name=" + s2 + "";
SqlDataReader dr = cmd.ExecuteReader();
if (dr.Read())
{
z1 = dr.GetString(0).ToString();
}
Userpage u1 = new Userpage(z1);
u1.Show();
this.Hide();
}
else
{
SqlConnection conn = new SqlConnection("Server=.\\SQLEXPRESS; Database= ExamManager;Integrated Security =true");
conn.Open();
SqlCommand cmd = new SqlCommand("select Qno,question,option1,option2,option3,option4,answer from login where Qno=" + i + "and category=" + s1 + "", conn);
SqlDataReader dr = cmd.ExecuteReader();
if (dr.Read())
{
label1.Text = dr.GetInt32(0).ToString();
label2.Text = dr.GetString(1).ToString();
radioButton1.Text = dr.GetString(2).ToString();
radioButton2.Text = dr.GetString(3).ToString();
radioButton3.Text = dr.GetString(4).ToString();
radioButton4.Text = dr.GetString(5).ToString();
if (radioButton1.Checked == true)
{
if (radioButton1.Text.ToString() == dr.GetString(6).ToString())
{
count++;
label3.Text = "Score =" + count + "";
}
}
if (radioButton2.Checked == true)
{
if (radioButton2.Text.ToString() == dr.GetString(6).ToString())
{
count++;
label3.Text = "Score =" + count + "";
}
}
if (radioButton3.Checked == true)
{
if (radioButton3.Text.ToString() == dr.GetString(6).ToString())
{
count++;
label3.Text = "Score =" + count + "";
}
}
if (radioButton4.Checked == true)
{
if (radioButton4.Text.ToString() == dr.GetString(6).ToString())
{
count++;
label3.Text = "Score =" + count + "";
}
}
i++;
}
conn.Close();
}
}