private void MainMenuButton_Click(object sender, EventArgs e)
{
TeacherMainMenu tmm = new TeacherMainMenu();
this.Hide();
tmm.Show();
}
private void SignInbutton_Click(object sender, EventArgs e)
{
if (StudentLoginradioButton.Checked)
{
if (UsernametextBox.Text != null && PasswardtextBox.Text != null)
{
try
{
Connection obj = new Connection();
obj.con.ConnectionString = obj.locate;
obj.con.Open();
SqlDataAdapter adapter = new SqlDataAdapter("Select COUNT (*) FROM Students where Username ='******' and Passward ='" + PasswardtextBox.Text + "'", obj.con);
DataTable dt = new DataTable();
adapter.Fill(dt);
if (dt.Rows[0][0].ToString() == "1")
{
StudentMainMenu smm = new StudentMainMenu();
this.Hide();
smm.Show();
}
else
{
MessageBox.Show("Username or Passward is incorrect");
}
obj.con.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
if (TeacherLoginradioButton.Checked)
{
if (UsernametextBox.Text != null && PasswardtextBox.Text != null)
{
try
{
Connection obj = new Connection();
obj.con.ConnectionString = obj.locate;
obj.con.Open();
SqlDataAdapter adapter = new SqlDataAdapter("Select COUNT (*) FROM Teachers where Username ='******' and Passward ='" + PasswardtextBox.Text + "'", obj.con);
DataTable dt = new DataTable();
adapter.Fill(dt);
if (dt.Rows[0][0].ToString() == "1")
{
TeacherMainMenu tmm = new TeacherMainMenu();
this.Hide();
tmm.Show();
}
else
{
MessageBox.Show("Username or Passward is incorrect");
}
obj.con.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
}
