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