public DataTable auto()
{
query = "select count (*) from kembali";
dtTbl = dbConn.ExecQuery(query);
return(dtTbl);
}
public DataTable auto()
{
query = "Select count(*) from anggota";
dtTbl = dbConn.ExecQuery(query);
return(dtTbl);
}
public DataTable CekStatus(String lvl)
{
query = "select status from alat where nama_alat='" + lvl + "'";
dtTbl = dbConn.ExecQuery(query);
return(dtTbl);
}
public bool isExistPeminjam(String id_peminjaman)
{
bool cek = false;
query = "SELECT * FROM peminjam WHERE id_peminjaman = '" + id_peminjaman + "'";
dtTbl = dbConn.ExecQuery(query);
if (dtTbl.Rows.Count > 0)
{
cek = true;
}
return(cek);
}