public HasilTaniJoin FindHasilTaniJoin(int idHasilTani)
{
HasilTaniJoin hasilTaniJoin = new HasilTaniJoin();
JenisTani jenisTani = new JenisTani();
Lokasi lokasi = new Lokasi();
using (MySqlConnection conn = GetConnection())
{
conn.Open();
MySqlCommand cmd = new MySqlCommand("SELECT * FROM hasil_tani INNER JOIN jenis_tani ON jenis_tani.id_jenistani = hasil_tani.id_jenistani INNER JOIN lokasi ON lokasi.id_lokasi = hasil_tani.id_lokasi WHERE id_hasil = '" + idHasilTani + "'", conn);
using (MySqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
hasilTaniJoin.IdHasilTani = reader.GetInt32("id_hasil");
hasilTaniJoin.Jumlah = reader.GetInt32("jumlah");
jenisTani.IdJenisTani = reader.GetInt32("id_jenistani");
jenisTani.NamaJenisTani = reader.GetString("nama_jenistani");
lokasi.IdLokasi = reader.GetInt32("id_lokasi");
lokasi.Kecamatan = reader.GetString("kecamatan");
lokasi.Kabupaten = reader.GetString("kabupaten");
lokasi.Provinsi = reader.GetString("provinsi");
lokasi.KodePos = reader.GetInt32("kode_pos");
lokasi.Latitude = reader.GetDecimal("latitude");
lokasi.Longitude = reader.GetDecimal("longtitude");
hasilTaniJoin.jenisTani = jenisTani;
hasilTaniJoin.lokasi = lokasi;
}
}
}
return(hasilTaniJoin);
}
public JenisTani FindJenisTani(int idJenisTani)
{
JenisTani jenisTani = new JenisTani();
using (MySqlConnection conn = GetConnection())
{
conn.Open();
MySqlCommand cmd = new MySqlCommand("SELECT * FROM jenis_tani WHERE id_jenistani = ('" + idJenisTani + "')", conn);
using (MySqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
jenisTani.IdJenisTani = reader.GetInt32("id_jenistani");
jenisTani.NamaJenisTani = reader.GetString("nama_jenistani");
}
}
}
return(jenisTani);
}