private void Button_Click(object sender, RoutedEventArgs e) { PrehrambeniProdukt prod = new PrehrambeniProdukt(); string uneseni = comboprodukti.Text; string[] tipovi = Regex.Split(uneseni, " "); foreach (PrehrambeniProdukt p in produkti) { if (p.Tip == tipovi[0]) prod = p; } listaproizvoda.Items.Add(prod); kprodukti.Add(prod); comboprodukti.SelectedIndex = -1; }
private void Button_Click_3(object sender, RoutedEventArgs e) { PrehrambeniProduktDao pDAO = new PrehrambeniProduktDao(); if (Naziv1.Text == String.Empty) return; PrehrambeniProdukt p = new PrehrambeniProdukt(Naziv1.Text, Convert.ToDouble(Cijena.Text)); pDAO.create(p); ListBox1.ItemsSource = pDAO.getAll(); ComboBox3.ItemsSource = pDAO.getAll(); Naziv1.Clear(); Cijena.Clear(); }
public Racun getById(int id) { DataSet data = manager.ExecuteSqlCommandToDataSet("SELECT * FROM Racun r, ProdavacHrane ph WHERE r.RacunId = " + id + " and r.ProdavacID = ph.PrehrambeniProduktID "); DataSet data2 = manager.ExecuteSqlCommandToDataSet("SELECT * FROM PrehrambeniProdukt ph, RacunProdukt rp, Racun r WHERE rp.RacunId = " + id + " AND rp.ProduktID = ph.Id "); List<PrehrambeniProdukt> lista = new List<PrehrambeniProdukt>(); foreach (DataRow dataRow in data2.Tables[0].Rows) { PrehrambeniProdukt ph = new PrehrambeniProdukt( Convert.ToInt32(dataRow["PrehrambeniProduktID"]), Convert.ToString(dataRow["Tip"]), Convert.ToDouble(dataRow["Cijena"]) ); lista.Add(ph); } foreach (DataRow dataRow in data.Tables[0].Rows) { Racun racun = new Racun( Convert.ToInt32(dataRow["RacunId"]), Convert.ToInt32(dataRow["Sifra"]), Convert.ToDateTime(dataRow["Vrijeme"]), new Menadzer( Convert.ToString(dataRow["Telefon"]), Convert.ToString(dataRow["Ime"]), Convert.ToString(dataRow["Prezime"]), Convert.ToString(dataRow["Jmbg"]), Convert.ToInt32(dataRow["UposlenikId"]), Convert.ToDouble(dataRow["Koeficijent"]) ), new ProdavacHrane(Convert.ToString(dataRow["Pult"]), Convert.ToString(dataRow["Ime"]), Convert.ToString(dataRow["Prezime"]), Convert.ToString(dataRow["Jmbg"]), Convert.ToInt32(dataRow["UposlenikId"]), Convert.ToDouble(dataRow["Koeficijent"])), lista ); return racun; } return null; }
/// <summary> /// Konstruktor koji prima instancu klase PrehrambeniProdukt /// </summary> /// <param name="p">Instanca klase</param> public PrehrambeniProdukt(PrehrambeniProdukt p) { this.Id = p.Id; this.Tip = p.Tip; this.Cijena = p.Cijena; }