// ...#.... public int Obrisi(IDomenskiObjekat objekat) { SqlCommand command = new SqlCommand($"DELETE FROM {objekat.VratiImeKlase()} WHERE {objekat.VratiUslovPoIDu()}", connection, transaction); return(command.ExecuteNonQuery()); }
public IDomenskiObjekat VratiJedan(IDomenskiObjekat objekat) { IDomenskiObjekat rezultat; SqlCommand command = new SqlCommand($"SELECT * FROM {objekat.VratiImeKlase()} WHERE {objekat.VratiUslovPoIDu()}", connection, transaction); SqlDataReader reader = command.ExecuteReader(); rezultat = objekat.VratiObjekat(reader); reader.Close(); int broj = 1; while (rezultat.VratiPoddomen(broj) != null) { rezultat.PostaviPoddomen(VratiJedan(rezultat.VratiPoddomen(broj)), broj); broj++; } return(rezultat); }
// ...#... public int Izmeni(IDomenskiObjekat objekat) { SqlCommand command = new SqlCommand($"UPDATE {objekat.VratiImeKlase()} SET {objekat.PostaviVrednostiAtributa()} WHERE {objekat.VratiUslovPoIDu()}", connection, transaction); return(command.ExecuteNonQuery()); }