public Sastojak(int id_proizvod, Magacin roba, Kategorija kategorija, double kolicina) { Id_proizvod = id_proizvod; SetRoba(roba); SetKategorija(kategorija); Kolicina = kolicina; }
public Magacin GetMagacinByID(int id_robe) { using (OracleConnection connection = new OracleConnection(ConnectionString.GetString())) { connection.Open(); string sql = "select * from magacin where id_robe = " + id_robe; OracleCommand command = new OracleCommand(sql, connection); OracleDataReader dr = command.ExecuteReader(); dr.Read(); Magacin roba = new Magacin(dr.GetInt32(0), dr.GetString(1), dr.GetDouble(2), dr.GetInt32(3)); return(roba); } }
public string DeleteRobu(Magacin roba) { using (OracleConnection connection = new OracleConnection(ConnectionString.GetString())) { connection.Open(); string sql = "delete from magacin where id_robe = " + roba.Id_robe; OracleCommand command = new OracleCommand(sql, connection); try { command.ExecuteNonQuery(); return("Uspesno ste obrisali " + roba.Naziv); } catch { return("Dolso je do greske prilikom brisanja " + roba.Naziv); } } }
public List <Magacin> GetMagacin() { using (OracleConnection connection = new OracleConnection(ConnectionString.GetString())) { connection.Open(); string sql = "select * from magacin"; OracleCommand command = new OracleCommand(sql, connection); OracleDataReader dr = command.ExecuteReader(); List <Magacin> magacin = new List <Magacin>(); while (dr.Read()) { Magacin roba = new Magacin(dr.GetInt32(0), dr.GetString(1), dr.GetInt32(2), dr.GetInt32(3)); magacin.Add(roba); } return(magacin); } }
public string InsertRobu(Magacin roba) { using (OracleConnection connection = new OracleConnection(ConnectionString.GetString())) { connection.Open(); string sql = "insert into magacin values(" + roba.Id_robe + ",\'" + roba.Naziv + "\'" + "," + roba.Kolicina + "," + roba.GetJM().Id_jm + ")"; OracleCommand command = new OracleCommand(sql, connection); try { command.ExecuteNonQuery(); return("Uspesno uneta roba!"); } catch { return("Doslo je do greske prilikom unosenja robe!"); } } }
public string UpdateMagacin(Magacin roba) { using (OracleConnection connection = new OracleConnection(ConnectionString.GetString())) { connection.Open(); string sql = "update magacin set" + " naziv = \'" + roba.Naziv + "\'" + ", kolicina = " + roba.Kolicina + ", id_jm = " + roba.GetJM().Id_jm + "where id_robe = " + roba.Id_robe; OracleCommand command = new OracleCommand(sql, connection); try { command.ExecuteNonQuery(); return("Uspesno ste azurirali stanje u magacinu!"); } catch { return("Doslo je do greske prilikom azuriranja stanja u magacinu!"); } } }
public void SetRoba(Magacin roba) { this.roba = roba; }