private void SubmitBtn_Click(object sender, EventArgs e)
{
con = new SqlConnection(@"data source= rafi\SqlExpress;" +
"database= Course;" +
"integrated security= SSPI");
con.Open();
int a = 0;
if (checkBox1.Checked)
{
cmd = new SqlCommand("Insert into preference(pretid, precid) values (@name, @gen)", con);
cmd.Parameters.AddWithValue("@name", i);
cmd.Parameters.AddWithValue("@gen", "Maths101");
cmd.ExecuteNonQuery();
a = 1;
}
if (checkBox2.Checked)
{
cmd = new SqlCommand("Insert into preference(pretid, precid) values (@name, @gen)", con);
cmd.Parameters.AddWithValue("@name", i);
cmd.Parameters.AddWithValue("@gen", "Maths102");
cmd.ExecuteNonQuery();
a = 1;
}
if (checkBox2.Checked)
{
cmd = new SqlCommand("Insert into preference(pretid, precid) values (@name, @gen)", con);
cmd.Parameters.AddWithValue("@name", i);
cmd.Parameters.AddWithValue("@gen", "Maths103");
cmd.ExecuteNonQuery();
a = 1;
}
if (a == 1)
{
MessageBox.Show("Submitted!");
this.Hide();
AvailableForT2 add = new AvailableForT2(id);
add.Show();
}
}
public AvailableForT(string uid)
{
InitializeComponent();
id = uid;
i = Convert.ToInt32(id);
try
{
con1 = new SqlConnection(@"data source= rafi\SqlExpress;" +
"database= Course;" +
"integrated security= SSPI");
cmd = new SqlCommand("SELECT cid from courses where SUBSTRING (cid,1,3) like (Select CASE WHEN " +
"Education= 1 THEN 'Mat' WHEN Education= 3 THEN 'Mat' END AS Education " +
"from Teacher where tid=(@data))", con1);
cmd.Parameters.AddWithValue("@data", i);
con1.Open();
using (SqlDataReader oReader = cmd.ExecuteReader())
{
while (oReader.Read())
{
ch1 = 1;
}
}
if (ch1 != 99)
{
this.Hide();
AvailableForT2 a = new AvailableForT2(id);
a.Show();
}
}
finally
{
}
}
