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