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);
}
