private void btn_login_Click(object sender, EventArgs e)
{
if (textBox_username.Text.Trim().Equals("") || textBox_password.Text.Trim().Equals(""))
{
MessageBox.Show("Isi username dan password", "Error Message");
}
else
{
connection.Open();
string login_admin = "SELECT * FROM tbl_login WHERE username = '******'and password = '******'";
string login_dosen = "SELECT nama_dosen FROM tbl_dosen WHERE id_dosen = '" + textBox_username.Text.Trim() + "'and birth_dosen = '" + textBox_password.Text.Trim() + "'";
string login_mhs = "SELECT nama_mhs FROM tbl_mhs WHERE id_mhs = '" + textBox_username.Text.Trim() + "'and birth_mhs = '" + textBox_password.Text.Trim() + "'";
// ngambil string namanya
MySqlCommand cmd = connection.CreateCommand();
MySqlDataReader reader;
//mahasiswa
/*MySqlDataAdapter mhs = new MySqlDataAdapter(login_mhs, connection);
* DataTable dt_mhs = new DataTable();
* mhs.Fill(dt_mhs);*/
////////////////////////////
cmd.CommandText = login_mhs;
reader = cmd.ExecuteReader();
////////////////////////////
if (reader.Read())// && reader.RecordsAffected == 1)//dt_mhs.Rows.Count == 1)
{
/*cmd.CommandText = login_mhs;
* reader = cmd.ExecuteReader();*/
login_mhs = reader[0].ToString();
reader.Close();
DashboardMhs dashboard_mhs = new DashboardMhs(textBox_username.Text, login_mhs);
this.Hide();
dashboard_mhs.Show();
}
else
{
//dosen
/*MySqlDataAdapter dosen = new MySqlDataAdapter(login_dosen, connection);
* DataTable dt_dosen = new DataTable();
* dosen.Fill(dt_dosen);*/
//////////////////
reader.Close();
cmd.CommandText = login_dosen;
reader = cmd.ExecuteReader();
//////////////////
if (reader.Read())// && reader.RecordsAffected == 1)//dt_dosen.Rows.Count == 1)
{
/*cmd.CommandText = login_dosen;
* reader = cmd.ExecuteReader();*/
login_dosen = reader[0].ToString();
reader.Close();
DashboardDosen dashboard_dosen = new DashboardDosen(textBox_username.Text, login_dosen);
this.Hide();
dashboard_dosen.Show();
/*if(reader.Read())
* {
*
* login_dosen = reader[0].ToString();
* DashboardDosen dashboard_dosen = new DashboardDosen(textBox_username.Text, login_dosen);
* this.Hide();
* dashboard_dosen.Show();
* }*/
}
else
{
//admin
reader.Close();
MySqlDataAdapter admin = new MySqlDataAdapter(login_admin, connection);
DataTable dt_admin = new DataTable();
admin.Fill(dt_admin);
if (dt_admin.Rows.Count == 1)
{
DashboardAdmin dashboard_admin = new DashboardAdmin();
this.Hide();
dashboard_admin.Show();
}
else
{
MessageBox.Show("Username or Password is wrong !", "WARNING !!");
}
}
}
connection.Close();
}
}
private void MhsNilai_FormClosed(object sender, FormClosedEventArgs e)
{
DashboardMhs dashboard = new DashboardMhs(lbl_nim.Text, lbl_nama.Text);
dashboard.Show();
}
private void JadwalMhs_FormClosed(object sender, FormClosedEventArgs e)
{
DashboardMhs dashboardmhs = new DashboardMhs(lbl_nim.Text, lbl_nama.Text);
dashboardmhs.Show();
}