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