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