public void SearchIdNapi(string nomorTahanan, IOnLoginPengunjungFinishedListener listener) { connection = ConnectDB.ConnectingDB(); try { string query = "SELECT * FROM `napi` WHERE `noTahanan`= '" + nomorTahanan + "'"; Boolean error = true; connection.Open(); MySqlCommand command = connection.CreateCommand(); command.CommandText = query; MySqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { if (reader.GetString(0).ToString() == nomorTahanan) { napiModel.setNomorTahanan(reader.GetString(0).ToString()); napiModel.setNamaTahanan(reader.GetString(1).ToString()); napiModel.setJenisKelaminTahanan(reader.GetString(2).ToString()); napiModel.setKewarganegaraanTahanan(reader.GetString(3).ToString()); napiModel.setTanggalLahirTahanan(reader.GetString(4).ToString()); napiModel.setAgamaTahanan(reader.GetString(5).ToString()); listener.onSuccessCariIdNapi(napiModel); error = false; } } if (error == true) { listener.onErrorCariIdNapi(); } connection.Close(); } catch (Exception e) { Console.WriteLine("Error:" + e); } }