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