private void UpdateRfidPegawai(string idPegawai, string lastHeksa)
{
Int32 sequence = Int32.Parse(lastHeksa, System.Globalization.NumberStyles.HexNumber);//dari heksa terakir convert ke int
sequence++;
string heksa = String.Format("{0:X7}", sequence); //heksa selanjutnya => utk pegawai heksa ada 7 digit
DataTable dt = null;
cKoneksi koneksi = new cKoneksi();
SqlConnection conn = new SqlConnection(koneksi.konekMsSql('4'));
conn.Open();
try
{
string RFID = "2" + heksa + "";
SqlCommand cmd = null;
cQuery qr = new cQuery();
cmd = new SqlCommand(qr.qSelectIdPegawaiByRfid(RFID), conn);
SqlDataAdapter da = new SqlDataAdapter(cmd);
dt = new DataTable();
da.Fill(dt);
if (dt.Rows.Count > 0)
{
MessageBox.Show("Proses Generate Gagal");
return;
}
cmd = new SqlCommand(qr.qUpdateRfidPegByID(), conn);
cmd.Parameters.AddWithValue("@rfid", RFID);
cmd.Parameters.AddWithValue("@id_pegawai", idPegawai);
cmd.ExecuteNonQuery();
}
finally
{
conn.Close();
conn.Dispose();
dt.Clear();
dt.Dispose();
}
}