public static List <Artikl> GetArtikleReadOnly(Artikl.OznakaArtikla oznaka) { List <Artikl> artikli = new List <Artikl>(); SqliteCommand c = DB.con.CreateCommand(); c.CommandText = String.Format(@"SELECT * FROM Artikl WHERE oznaka = '{0}'", oznaka); SqliteDataReader reader = c.ExecuteReader(); while (reader.Read()) { Artikl a = new Artikl((long)reader["ID"], (string)reader["sifra"], (string)reader["naziv"], (string)reader["duzi_naziv"], (float)reader.GetDecimal(5), (string)reader["sastav"], Artikl.OznakaFromString((string)reader["oznaka"])); artikli.Add(a); } c.Dispose(); return(artikli); }
public static List <Artikl> GetArtikleReadOnly() { List <Artikl> artikli = new List <Artikl>(); SqliteCommand c = DB.con.CreateCommand(); System.Runtime.CompilerServices.RuntimeHelpers.RunClassConstructor(typeof(DBStavkeNarudzbe).TypeHandle); c.CommandText = String.Format(@"SELECT * FROM Artikl a ORDER BY (SELECT COUNT(*) FROM Stavka_Narudzbe WHERE id_artikl = a.id) DESC" ); SqliteDataReader reader = c.ExecuteReader(); while (reader.Read()) { Artikl a = new Artikl((long)reader["ID"], (string)reader["sifra"], (string)reader["naziv"], (string)reader["duzi_naziv"], (float)reader.GetDecimal(5), (string)reader["sastav"], Artikl.OznakaFromString((string)reader["oznaka"])); artikli.Add(a); } c.Dispose(); return(artikli); }