public void SearchIdMember(string nomorKtp, IOnLoginPengunjungFinishedListener listener) { connection = ConnectDB.ConnectingDB(); try { connection.Open(); string query = "SELECT * FROM `member` WHERE `noKTP`= '" + nomorKtp + "'"; Boolean error = true; MySqlCommand command = connection.CreateCommand(); command.CommandText = query; MySqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { if (reader.GetString(0).ToString() == nomorKtp) { memberModel.setNomorKtp(reader.GetString(0).ToString()); memberModel.setNama(reader.GetString(1).ToString()); memberModel.setJenisKelamin(reader.GetString(2).ToString()); memberModel.setKewarganegaraan(reader.GetString(3).ToString()); memberModel.setTanggalLahir(reader.GetString(4).ToString()); memberModel.setAgama(reader.GetString(5).ToString()); memberModel.setNomorTlp(reader.GetString(6).ToString()); memberModel.setEmail(reader.GetString(7).ToString()); memberModel.setAlamat(reader.GetString(8).ToString()); memberModel.setKecamatan(reader.GetString(9).ToString()); memberModel.setRtRw(reader.GetString(10).ToString()); listener.onSuccessCariIdMember(memberModel); error = false; } } if (error == true) { listener.onErrorCariIdMember(); } connection.Close(); } catch (Exception e) { Console.WriteLine("Error:" + e); } }