public List <tbl_stasi> getStasiBasedOnIdParokiNew(int id_paroki, string namaDatabase) { MySqlConnection connection = dbConnector.openConnection("", "", namaDatabase); String query = "Select * from tbl_stasi where id_paroki = @idParoki"; connection.Open(); MySqlCommand command = new MySqlCommand(query, connection); command.Parameters.AddWithValue("@idParoki", id_paroki); MySqlDataReader reader = command.ExecuteReader(); List <tbl_stasi> balikan = new List <tbl_stasi>(); while (reader.Read()) { tbl_stasi temp = new tbl_stasi(); temp.id_paroki = reader["id_paroki"].ToString(); temp.id_stasi = reader["id_stasi"].ToString(); temp.kode_stasi = reader["kode_stasi"].ToString(); temp.nama_stasi = reader["nama_stasi"].ToString(); balikan.Add(temp); } connection.Close(); reader.Close(); return(balikan); }
public List <tbl_stasi> getAllStasiList() { DataTable dt = new DataTable(); dt.Clear(); dt = stasiAdapter.GetData(); List <tbl_stasi> balikan = new List <tbl_stasi>(); for (int i = 0; i < dt.Rows.Count; i++) { tbl_stasi temp = new tbl_stasi(); temp.id_stasi = dt.Rows[i]["id_stasi"].ToString(); temp.kode_stasi = dt.Rows[i]["kode_stasi"].ToString(); temp.id_paroki = dt.Rows[i]["id_paroki"].ToString(); temp.nama_stasi = dt.Rows[i]["nama_stasi"].ToString(); temp.jumlah_umat_stasi = Convert.ToInt32(dt.Rows[i]["jumlah_umat_stasi"]); temp.id_ref_kondisi_ekonomi = dt.Rows[i]["id_ref_kondisi_ekonomi"].ToString(); balikan.Add(temp); } return(balikan); }