public List <Obc> ZobrazObce()
{
using (Connection) {
using (OracleCommand cmd = new OracleCommand()) {
cmd.Connection = Connection;
cmd.CommandText = "SELECT NAZEV FROM SEM_OBEC WHERE VIDIBLE=1 ";
List <Obc> vystup = new List <Obc>();
OracleDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
Obc tmp = new Obc();
tmp.Nazev = (string)reader.GetValue(0);
vystup.Add(tmp);
}
reader.Close();
return(vystup);
}
}
}
public List <Obc> ZobrazVsechnyObce()
{
using (Connection) {
using (OracleCommand cmd = new OracleCommand()) {
cmd.Connection = Connection;
cmd.CommandText = "SELECT nazev, vidible FROM SEM_OBEC";
List <Obc> vystup = new List <Obc>();
OracleDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
Obc tmp = new Obc();
tmp.Nazev = (string)reader.GetValue(0);
tmp.Visibility = (Decimal)reader.GetValue(1);
vystup.Add(tmp);
}
reader.Close();
return(vystup);
}
}
}
