// insert data user farmasi public bool insertData(passFarmasi pf) { Boolean stat = false; try { query = "insert into ap_pas_farmasi (kdkasir, pasword, nmkasir, uid, hak_akses) values (@kdkasir, @pasword, @nmkasir, @uid, @hak_akses)"; command = new SqlCommand(query, koneksi); command.Parameters.AddWithValue("@kdkasir", pf.Kdkasir); command.Parameters.AddWithValue("@pasword", pf.Pasword); command.Parameters.AddWithValue("@nmkasir", pf.Nmkasir); command.Parameters.AddWithValue("@uid", pf.Uid); command.Parameters.AddWithValue("@hak_akses", pf.Hak_akses); koneksi.Open(); int rows = command.ExecuteNonQuery(); if (rows > 0) { stat = true; } else { stat = false; } } catch (SqlException) { } finally { koneksi.Close(); } return(stat); }
void cariUserFarmasi(String term) { passFarmasi pf = new passFarmasi(); DFarmasi = MFarmasi.cariData(term); DGFarmasi.DataSource = DFarmasi; }
private void btnSimpan(object sender, EventArgs e) { passFarmasi pas = new passFarmasi(); pas.Uid = txtUID.Text; pas.Nmkasir = txtNAMA.Text; pas.Kdkasir = txtKDKASIR.Text; pas.Pasword = txtPASS.Text; pas.Hak_akses = txtHAKAKSES.Text; MFarmasi.insertData(pas); MessageBox.Show("BERHASIL DI SIMPAN"); lihatDataPegawai(); clearForm(); }
void validasiFarmasi(String term) { passFarmasi pf = new passFarmasi(); DataTable DTkasir = new DataTable(); DTkasir = MFarmasi.getUser(term); string pesan = string.Empty; if (DTkasir != null) { if (DTkasir.Rows.Count > 0) { object b = DTkasir.Rows[0]["kdkasir"]; string kdkasir = string.Empty; kdkasir = Convert.ToString(b); if (txtKDKASIR.Text == kdkasir) { pesan += "Kode user sudah di pakai oleh " + kdkasir + "\n"; pesan += "Silahkan pakai kode yang lain \n"; pesan += "Terimaksih"; txtKDKASIR.Text = ""; } } else { pesan += "Kode boleh di pakai"; } } else { pesan += "Kode boleh di pakai"; } MessageBox.Show(pesan, "Peringatan!!!", MessageBoxButtons.OK); }