private void btnAdd_Click(object sender, RoutedEventArgs e) { int cnt = lista.Count(); Predmet pr = new Predmet() { tip = -1 }; if (cnt != 0) { pr.id = Predmet.Daj().Last().id + 1; } else { pr.id = 1; } lista.Add(pr); lstPredmeti.SelectedIndex = cnt; EditMode(false); mode = 2; txtPredmet.Focus(); }
public static ObservableCollection <Predmet> DajPredmete(Smer sm, int razred) { ObservableCollection <Predmet> predmeti = new ObservableCollection <Predmet>(); SQLiteConnection con = new SQLiteConnection("Data Source = " + App.baza); con.Open(); ObservableCollection <Predmet> svi = Predmet.Daj(); SQLiteCommand com = new SQLiteCommand("SELECT * FROM smer_predmet WHERE id_smera=" + sm.id.ToString() + " AND razred=" + razred.ToString(), con); SQLiteDataReader read = com.ExecuteReader(); while (read.Read()) { Predmet pr = new Predmet(); var col = svi.Where(x => x.id == Convert.ToInt32(read["id_predmeta"])).ToList(); if (col.Count != 0) { pr = col[col.Count - 1]; pr.prosek = (read["prosek"].ToString() == "1"); predmeti.Add(pr); } } return(predmeti); }