public void LoginPengungjung(string nomorKtp, string nomorTahanan, IOnLoginPengunjungFinishedListener listener)
{
connection = ConnectDB.ConnectingDB();
try
{
connection.Open();
MySqlCommand command = connection.CreateCommand();
query = "INSERT INTO `jenguk` (`NoKtp_member`, `NoTahanan_napi`, `Date`) VALUES ('" + nomorKtp + "', '" + nomorTahanan + "', CURRENT_TIMESTAMP)";
command.CommandText = query;
command.ExecuteNonQuery();
listener.onSuccessKirim();
}
catch (Exception e)
{
listener.onErrorKirim();
Console.WriteLine("Error:" + e);
}
connection.Close();
}
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);
}
}
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);
}
}
