public static void GetStavke(ref Narudzba n)
{
SqliteCommand c = DB.con.CreateCommand();
c.CommandText = String.Format(@"SELECT * FROM Stavka_Narudzbe WHERE id_narudzba = {0}", n.ID);
SqliteDataReader reader = c.ExecuteReader();
while (reader.Read())
{
StavkaNarudzbe ns = new StavkaNarudzbe((long)reader["id"], ArtikliPresenter.GetArtikl((long)reader["id_artikl"]),
(int)reader.GetInt64(3), StavkaNarudzbe.StatusFromString((string)reader["status"]));
n.Stavke.Add(ns);
}
c.Dispose();
}
public void DodajStavku(string sifra, int kolicina, int status)
{
DodajStavku(new StavkaNarudzbe(ArtikliPresenter.GetArtikl(sifra), kolicina, StavkaNarudzbe.GetStatus(status)));
}
