public List <IOpstiDomenskiObjekat> ExecuteReader(string upit, IOpstiDomenskiObjekat odo)
{
komanda.CommandText = upit;
komanda.CommandType = System.Data.CommandType.Text;
OleDbDataReader citac = komanda.ExecuteReader();
List <IOpstiDomenskiObjekat> lista = odo.VratiListu(citac);
citac.Close();
return(lista);
}
public List <IOpstiDomenskiObjekat> SelectAll(IOpstiDomenskiObjekat odo)
{
komanda.CommandText = $"Select * from {odo.VratiImeTabele()}";
komanda.CommandType = System.Data.CommandType.Text;
OleDbDataReader citac = komanda.ExecuteReader();
List <IOpstiDomenskiObjekat> lista = odo.VratiListu(citac);
citac.Close();
return(lista);
}
public List <IOpstiDomenskiObjekat> VratiSve(IOpstiDomenskiObjekat odo)
{
List <IOpstiDomenskiObjekat> lista;
komanda.CommandText = $"SELECT * FROM {odo.VratiImeTabele()}";
komanda.CommandType = CommandType.Text;
OleDbDataReader citac = komanda.ExecuteReader();
lista = odo.VratiListu(citac);
citac.Close();
return(lista);
}
public List <IOpstiDomenskiObjekat> VratiSveObjektePoUslovu(IOpstiDomenskiObjekat odo)
{
try
{
string upit = "SELECT * FROM " + odo.VratiImeTabele() + " WHERE " + odo.VratiUslovZaObjekat();
komanda = new OleDbCommand(upit, konekcija, transakcija);
OleDbDataReader citac = komanda.ExecuteReader();
return(odo.VratiListu(citac));
}
catch (Exception ex)
{
throw ex;
}
}