private void b_login_Click(object sender, EventArgs e)
{
if (t_uname.TextLength == 0 || t_pass.TextLength == 0)
{
MessageBox.Show("Periksa kembali dan isi username dan password dengan lengkap");
}
else
{
try
{
cmd = new MySqlCommand("SELECT * FROM tb_user where username = '******'", con.Buka());
reader = cmd.ExecuteReader();
if (reader.HasRows == true)
{
while (reader.Read())
{
nama = reader["nama"].ToString();
id = reader["id_user"].ToString();
jeneng = reader["username"].ToString();
pass = reader["password"].ToString();
status = reader["status"].ToString();
pos = reader["position"].ToString();
if (jeneng == t_uname.Text && pass == t_pass.Text)
{
if (pos == "1")
{
x = 0;
MessageBox.Show("Login Berhasil");
MasterMenu m = new MasterMenu();
m.Show();
this.Hide();
}
else
{
MessageBox.Show("Akun anda terblokir!, silahkan hubungi admin");
}
}
else if (jeneng == t_uname.Text && pass != t_pass.Text)
{
uname = reader["username"].ToString();
x += 1;
if (x > 3)
{
MessageBox.Show("Akun anda terblokir!");
}
else
{
MessageBox.Show("Password Salah, Anda diberi kesempatan untuk login 3x jika gagal akun terblokir");
}
}
}
}
else
{
MessageBox.Show("Gagal");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
con.Tutup();
}
if (x == 3)
{
int z = 0;
con.UD("UPDATE tb_user set position = '" + z + "' where username = '******'", "Selamat akun anda terblokir");
}
bersih();
}
}
