public List <IObjekat> VratiSveSaUslovom(IObjekat objekat)
{
SqlCommand command = new SqlCommand("", connection, transaction);
command.CommandText = $"select * from {objekat.VratiImeKlase()} where {objekat.VratiUslovZaTrazenje()}";
SqlDataReader reader = command.ExecuteReader();
List <IObjekat> rezultat = objekat.VratiListu(reader);
reader.Close();
return(rezultat);
}
public int Obrisi(IObjekat objekat)
{
SqlCommand komanda = new SqlCommand($"delete from {objekat.VratiImeKlase()} where {objekat.VratiUslovZaTrazenje()}", connection, transaction);
return(komanda.ExecuteNonQuery());
}
public int Izmeni(IObjekat objekat)
{
SqlCommand komanda = new SqlCommand($"update {objekat.VratiImeKlase()} set {objekat.PostaviVrednostAtributa()} where {objekat.VratiUslovZaTrazenje()}", connection, transaction);
return(komanda.ExecuteNonQuery());
}
public IObjekat VratiJedan(IObjekat objekat)
{
IObjekat rezultat;
SqlCommand command = new SqlCommand($"select * from {objekat.VratiImeKlase()} where {objekat.VratiUslovZaTrazenje()}", connection, transaction);
SqlDataReader reader = command.ExecuteReader();
rezultat = objekat.VratiObjekat(reader);
reader.Close();
return(rezultat);
}
