// 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);
}
