public static ObservableCollection <Ucenik> Daj(string query) { ObservableCollection <Ucenik> ucenici = new ObservableCollection <Ucenik>(); SQLiteConnection con = new SQLiteConnection("Data Source = " + App.baza); con.Open(); SQLiteCommand com = new SQLiteCommand("SELECT * FROM ucenici WHERE " + query, con); SQLiteDataReader read = com.ExecuteReader(); while (read.Read()) { ucenici.Add(new Ucenik() { broj = Convert.ToInt32(read["broj"]), brojReg = Convert.ToInt32(read["broj_reg"]), jmbg = Convert.ToInt64(read["jmbg"]), naziv = read["naziv"].ToString(), mestoRodj = read["mesto_rodj"].ToString(), datumRodj = read["datum_rodj"].ToString(), otac = read["otac"].ToString(), majka = read["majka"].ToString(), upisanU = Convert.ToInt32(read["upisan_u"]), redovan = Convert.ToInt32(read["redovan"]), smer = Smer.Daj().Where(x => x.id == Convert.ToInt32(read["id_smera"])).ToList()[0], trajanje = Convert.ToInt32(read["trajanje"]) }); } con.Close(); return(ucenici); }
public ListePredmeta() { InitializeComponent(); cmbSmer.ItemsSource = Smer.Daj(); lista = Smer.DajPredmete((Smer)cmbSmer.SelectedItem, cmbRazred.SelectedIndex + 1); lstPredmeti.ItemsSource = lista; lstPredmeti.ItemContainerStyle.Setters.Add(new EventSetter(ListBoxItem.PreviewMouseLeftButtonDownEvent, new MouseButtonEventHandler(s_PreviewMouseLeftButtonDown))); lstPredmeti.ItemContainerStyle.Setters.Add(new EventSetter(ListBoxItem.DropEvent, new DragEventHandler(listbox1_Drop))); }
private void btnCanc_Click(object sender, RoutedEventArgs e) { if (mode == 1) { lista = Smer.Daj(); } else if (mode == 2) { lista.Remove(lista.Last()); } mode = 0; EditMode(true); }
int mode = 0; // 0 - standard, 1 - edit, 2 - add public Ucenici() { InitializeComponent(); lista = Ucenik.Daj(); lb_ucenici.ItemsSource = lista; memberCmb.ItemsSource = Ucenik.DajPolja(true); memberCmb.SelectedIndex = 3; txt11.ItemsSource = Smer.Daj(); boksovi.Add(txt1); boksovi.Add(txt2); boksovi.Add(txt3); boksovi.Add(txt4); boksovi.Add(txt5); boksovi.Add(txt6); boksovi.Add(txt7); boksovi.Add(txt8); boksovi.Add(txt9); boksovi.Add(txt12); boksovi.Add(txt14); EditMode(true); Grupisanje(); }
int mode = 0; // 0 - standard, 1 - edit, 2 - add public Smerovi() { InitializeComponent(); lista = Smer.Daj(); lstSmerovi.ItemsSource = lista; }