private void btn_login_Click(object sender, EventArgs e) { if ((txt_nik.Text == "") || (txt_pass.Text == "")) { MessageBox.Show(" User Dan Password Tidak Boleh Kosong"); } login_karyawan obj_login = new login_karyawan(); obj_login.nik = txt_nik.Text; obj_login.pass = txt_pass.Text; if (new login_dao().login_karyawan(obj_login) == "sukses") { MessageBox.Show("Login Berhasil"); if (new status_karyawan().status(obj_login) == "kepala") { frm_utama_parent frm_utama = new frm_utama_parent(txt_nik.Text); frm_utama.Show(); } else if (new status_karyawan().status(obj_login) == "ass_kepala") { frm_utama_parent frm_utama = new frm_utama_parent(txt_nik.Text); frm_utama.Show(); } else if (new status_karyawan().status(obj_login) == "kasir") { // frm_kasir kasir = new frm_kasir(txt_nik.Text); //karyawan kry = new karyawan(); frm_utama_parent_kasir frm_utama_kasir = new frm_utama_parent_kasir(txt_nik.Text); frm_utama_kasir.Show(); } } else { MessageBox.Show("Login Gagal "); } }
public string status(login_karyawan obj_login) { string status_kar = ""; conn.Open(); MySqlCommand query = new MySqlCommand(); query.Connection = conn; query.CommandText = "SELECT Jabatan FROM t_karyawan WHERE Nik = '" + obj_login.nik + "'"; MySqlDataReader reader = query.ExecuteReader(); while (reader.Read()) { if (reader.GetString(0).ToString() == "Kepala Toko") { status_kar = "kepala"; } else if (reader.GetString(0).ToString() == "Asissten Kepala ") { status_kar = "ass_kepala"; } else if (reader.GetString(0).ToString() == "Staff") { status_kar = "staff"; } else if (reader.GetString(0).ToString() == "Kasir") { status_kar = "kasir"; } } conn.Close(); return(status_kar); }
public string login_karyawan(login_karyawan obj_login) { string status = "gagal"; obj_login.pass = obj_login.pass.ToUpper(); conn.Open(); MySqlCommand query = new MySqlCommand(); query.Connection = conn; query.CommandText = "SELECT * FROM t_karyawan "; MySqlDataReader reader = query.ExecuteReader(); while (reader.Read()) { if ((reader.GetString(0).ToString() == obj_login.nik) && (reader.GetString(8).ToString().ToUpper() == obj_login.pass)) { status = "sukses"; } } conn.Close(); return(status); }