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}");
}