private void b_r_keluarga_Click(object sender, EventArgs e)
{
Riwayat_Keluarga rk = new Riwayat_Keluarga(t_nip_nrp.Text);
rk.Show();
this.Hide();
}
private void btn_login_Click(object sender, EventArgs e)
{
SqlCommand perintahLogin = new SqlCommand();
conn = Connection.connect();
perintahLogin.Connection = conn;
perintahLogin.CommandType = CommandType.Text;
perintahLogin.CommandText = "select * from dbo.personil where nip_nrp=@nip_nrp and password=@password and role=@role";
perintahLogin.Parameters.Add("@nip_nrp", SqlDbType.VarChar);
perintahLogin.Parameters.Add("@password", SqlDbType.VarChar);
perintahLogin.Parameters.Add("@role", SqlDbType.VarChar);
perintahLogin.Parameters["@nip_nrp"].Value = t_nip_nrp.Text.Trim();
perintahLogin.Parameters["@password"].Value = t_password.Text.Trim();
perintahLogin.Parameters["@role"].Value = cb_role.Text.Trim();
conn.Open();
dr = perintahLogin.ExecuteReader();
if (dr.Read() == true)
{
MessageBox.Show("Berhasil Login");
Riwayat_Keluarga rk = new Riwayat_Keluarga(t_nip_nrp.Text);
rk.Show();
this.Hide();
}
else
{
MessageBox.Show("Maaf tidak dapat login silahkan cek username dan password anda.!");
}
conn.Close();
}
