public static void UcitajNamestaj() { using (SqlConnection connection = new SqlConnection(Projekat.CONNECTION_STRING)) { try { connection.Open(); DataSet ds = new DataSet(); SqlCommand namestajCommand = connection.CreateCommand(); namestajCommand.CommandText = @"SELECT * FROM Namestaj "; SqlDataAdapter daNamestaj = new SqlDataAdapter(); daNamestaj.SelectCommand = namestajCommand; daNamestaj.Fill(ds, "Namestaj"); foreach (DataRow row in ds.Tables["Namestaj"].Rows) { Namestaj n = new Namestaj(); n.Id = (int)row["Id"]; n.Sifra = (string)row["Sifra"]; n.Naziv = (string)row["Naziv"]; n.Cena = Convert.ToDouble(row["Cena"]); n.Kolicina = (int)row["Kolicina"]; n.IdTip = (int)row["IdTip"]; n.TipNamestaja = TipNamestaja.GetById(n.IdTip); n.Obrisan = (bool)row["Obrisan"]; Projekat.Instance.Namestaj.Add(n); } } catch (Exception) { Console.WriteLine("Nije uspela sql naredba"); return; } } }
public override string ToString() { return($"Naziv: {Naziv},Cena:{Cena} din,{TipNamestaja.GetById(IdTip).Naziv},kol: {Kolicina}"); }