// ...#...
public bool SacuvajSlozen(IDomenskiObjekat objekat)
{
SqlCommand command = new SqlCommand($"INSERT INTO {objekat.VratiImeKlase()} OUTPUT {objekat.VratiImePrimarnogKljuca()} VALUES ({objekat.VratiVrednostiAtributa()})", connection, transaction);
int id = (int)command.ExecuteScalar();
foreach (IDomenskiObjekat o in objekat.VratiSlabeObjekte())
{
// smanjiti robu sa update preko where uslova za korisnika i naziv robe
// na primer UPDATE Roba SET KolicinaRobe = KolicinaRobe - 100 WHERE NazivRobe = 'Secer' AND KorisnikRobe = 2 AND RazmenaUlozeneRobe IS NULL
SqlCommand command3 = new SqlCommand($"UPDATE {o.VratiImeKlase()} SET KolicinaRobe = KolicinaRobe - {((Roba)o).KolicinaRobe} WHERE NazivRobe = '{((Roba)o).NazivRobe}' AND KorisnikRobe = {((Roba)o).KorisnikRobe.KorisnikID} AND RazmenaUlozeneRobe IS NULL", connection, transaction);
var i = command3.ExecuteNonQuery();
SqlCommand command2 = new SqlCommand($"INSERT INTO {o.VratiImeKlase()} VALUES ({o.VratiVrednostiAtributa()}, {id})", connection, transaction);
command2.ExecuteScalar();
}
IDomenskiObjekat trazenaRoba = objekat.VratiPoddomen(3);
if (Izmeni(trazenaRoba) != 1)
{
throw new Exception();
}
return(true);
}
// ...#...
public int SacuvajIUzvratiID(IDomenskiObjekat objekat)
{
SqlCommand command = new SqlCommand($"INSERT INTO {objekat.VratiImeKlase()} OUTPUT {objekat.VratiImePrimarnogKljuca()} VALUES({objekat.VratiVrednostiAtributa()})", connection, transaction);
return((int)command.ExecuteScalar());
}
// ...#...
public int Sacuvaj(IDomenskiObjekat objekat)
{
SqlCommand command = new SqlCommand($"INSERT INTO {objekat.VratiImeKlase()} VALUES ({objekat.VratiVrednostiAtributa()})", connection, transaction);
return(command.ExecuteNonQuery());
}