private void MainMenuButton_Click(object sender, EventArgs e)
{
StudentMainMenu smm = new StudentMainMenu();
this.Hide();
smm.Show();
}
private void Conformbutton_Click(object sender, EventArgs e)
{
Connection obj = new Connection();
obj.con.ConnectionString = obj.locate;
obj.con.Open();
SqlCommand cmd = obj.con.CreateCommand();
cmd.CommandType = CommandType.Text;
if (EnterOldUsernamStudentetextBox.Text.Length > 0)
{
cmd.CommandText = "UPDATE Students SET Username ='******',Passward ='" + StudentsEditPasswardtextBox.Text + "',Email ='" + StudentsEditEmailtextBox.Text + "',Department ='" + StudentsEditDepartmenttextBox.Text + "'WHERE Username='******'";
cmd.ExecuteNonQuery();
DataTable dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dt);
MessageBox.Show("Successfully Updated!");
StudentsEditUsernametextBox.Text = "";
StudentsEditPasswardtextBox.Text = "";
StudentsEditEmailtextBox.Text = "";
StudentsEditDepartmenttextBox.Text = "";
}
else
{
MessageBox.Show("Not Updated!");
}
StudentMainMenu mainMenu = new StudentMainMenu();
this.Hide();
mainMenu.Show();
obj.con.Close();
}
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);
}
}
}
}
