public Lokasi FindLokasiTani(int idLokasi) { Lokasi lokasi = new Lokasi(); using (MySqlConnection conn = GetConnection()) { conn.Open(); MySqlCommand cmd = new MySqlCommand("SELECT * FROM lokasi WHERE id_lokasi = ('" + idLokasi + "')", conn); using (MySqlDataReader reader = cmd.ExecuteReader()) { while (reader.Read()) { 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"); } } } return(lokasi); }
public TanahJoin FindTanahJoin(int idTanah) { TanahJoin tanahJoin = new TanahJoin(); JenisTanah jenisTanah = new JenisTanah(); Lokasi lokasi = new Lokasi(); using (MySqlConnection conn = GetConnection()) { conn.Open(); MySqlCommand cmd = new MySqlCommand("SELECT * FROM tanah INNER JOIN jenis_tanah ON jenis_tanah.id_jenistanah = tanah.id_jenistanah INNER JOIN lokasi ON lokasi.id_lokasi = tanah.id_lokasi WHERE id_tanah = '" + idTanah + "'", conn); using (MySqlDataReader reader = cmd.ExecuteReader()) { while (reader.Read()) { tanahJoin.IdTanah = reader.GetInt32("id_tanah"); tanahJoin.Suhu = reader.GetInt32("suhu"); tanahJoin.LuasTanah = reader.GetInt32("luas_tanah"); jenisTanah.IdJenisTanah = reader.GetInt32("id_jenistanah"); jenisTanah.NamaJenisTanah = reader.GetString("nama_jenistanah"); 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"); tanahJoin.JenisTanah = jenisTanah; tanahJoin.Lokasi = lokasi; } } } return(tanahJoin); }
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); }