public static void ObrisiKurs() { Console.WriteLine("Upisite id kursa: "); int id = Convert.ToInt32(Console.ReadLine()); KursDAO.Delete(Program.conn, id); }
public static void IspisiSveKurseve() { sviKursevi = KursDAO.GetAll(Program.conn); foreach (Kurs kurs in sviKursevi) { Console.WriteLine(kurs.ToString()); } }
public static void IspisiKursPoId() { Console.WriteLine("Upisite id kursa: "); int id = Convert.ToInt32(Console.ReadLine()); Kurs kurs = KursDAO.GetKursById(Program.conn, id); Console.WriteLine(kurs.ToString()); }
public App() { UcenikDAO.Read(); TipKorisnikaDAO.Read(); KorisnikDAO.Read(); NastavnikDAO.Read(); JezikDAO.Read(); TipKursaDAO.Read(); KursDAO.Read(); UplateDAO.Read(); }
public App() { KorisnikDAO.Read(); JezikDAO.Read(); NivoDAO.Read(); KursDAO.Read(); NastavnikDAO.Read(); UcenikDAO.Read(); NastavnikKursDAO.Read(); UcenikKursDAO.Read(); UplataDAO.Read(); SkolaDAO.Read(); }
private void btnBrisanje_Click(object sender, RoutedEventArgs e) { if (MessageBox.Show("Da li ste sigurni?", "Potvrda brisanja", MessageBoxButton.YesNo) == MessageBoxResult.Yes) { Kurs j = dgKursevi.SelectedItem as Kurs; j.Status = false; btnBrisanje.IsEnabled = false; btnIzmena.IsEnabled = false; KursDAO.Brisanje(j); } }
public static void DodajKurs() { Console.WriteLine("Upisite id novog kursa: "); int id = Convert.ToInt32(Console.ReadLine()); Console.WriteLine("Jezik: "); string jezik = Console.ReadLine(); Console.WriteLine("Nivo id: "); int nivo = Convert.ToInt32(Console.ReadLine()); Console.WriteLine("Cena: "); int cena = Convert.ToInt32(Console.ReadLine()); Kurs kurs = new Kurs(id, nivo, jezik, cena); KursDAO.Add(Program.conn, kurs); }
public static void UpdatujKurs() { Console.WriteLine("Upisite id kursa: "); int id = Convert.ToInt32(Console.ReadLine()); Console.WriteLine("Upisite nov jezik kursa: "); string novJezik = Console.ReadLine(); Console.WriteLine("Nivo id: "); int novNivo = Convert.ToInt32(Console.ReadLine()); Console.WriteLine("Cena: "); int novaCena = Convert.ToInt32(Console.ReadLine()); Kurs kurs = new Kurs(id, novNivo, novJezik, novaCena); KursDAO.Update(Program.conn, kurs); }
public KurseviWindow() { KursDAO.Read(); InitializeComponent(); bIzmeni.IsEnabled = false; bObrisi.IsEnabled = false; rbUcenik.IsChecked = true; rbIme.IsChecked = true; cvs = new CollectionViewSource(); cvs.Source = Aplikacija.Instanca.Kursevi; dgKursevi.ItemsSource = cvs.View; dgKursevi.IsReadOnly = true; dgKursevi.SelectionMode = DataGridSelectionMode.Single; dgKursevi.AutoGenerateColumns = false; DataGridTextColumn c = new DataGridTextColumn(); c.Header = "Jezik"; c.Binding = new Binding("JezikKursa.Naziv"); c.Width = new DataGridLength(1, DataGridLengthUnitType.Star); dgKursevi.Columns.Add(c); c = new DataGridTextColumn(); c.Header = "Tip"; c.Binding = new Binding("Tip.Nivo"); c.Width = new DataGridLength(1, DataGridLengthUnitType.Star); dgKursevi.Columns.Add(c); c = new DataGridTextColumn(); c.Header = "Cena"; c.Binding = new Binding("Cena"); c.Width = new DataGridLength(1, DataGridLengthUnitType.Star); dgKursevi.Columns.Add(c); c = new DataGridTextColumn(); c.Header = "Predavac"; c.Binding = new Binding("Predavac.ImePrezime"); c.Width = new DataGridLength(1, DataGridLengthUnitType.Star); dgKursevi.Columns.Add(c); }
private void bSacuvaj_Click(object sender, RoutedEventArgs e) { this.original.SetValues(copyObj); if (mod == MOD.DODAVANJE) { try { Aplikacija.Instanca.Kursevi.Add(original); KursDAO.Create(original); } catch { } } else { try { KursDAO.Update(original); } catch { } } KursDAO.Read(); this.DialogResult = true; this.Close(); }
private void bObrisi_Click(object sender, RoutedEventArgs e) { if (MessageBox.Show("Da li ste sigurni?", "Potvrda brisanja", MessageBoxButton.YesNo) == MessageBoxResult.Yes) { Kurs k = dgKursevi.SelectedItem as Kurs; foreach (Uplata u in Aplikacija.Instanca.Uplate) { if (u.Kurs.Id == k.Id) { MessageBox.Show("Ne mozete obrisati kurs zato sto je referenciran u uplati.", "Greska"); return; } } Aplikacija.Instanca.Kursevi.Remove(k); KursDAO.Delete(k); } if (Aplikacija.Instanca.Kursevi.Count == 0) { bObrisi.IsEnabled = false; bIzmeni.IsEnabled = false; } }
private void btnSave_Click(object sender, RoutedEventArgs e) { try { original.Jezik = cbJezik.SelectedItem as Jezik; original.TipKursa = cbTip.SelectedItem as TipKursa; original.Cena = Convert.ToDouble(tbCena.Text); original.DatumPocetak = dpDatumPocetak.SelectedDate.Value; original.DatumKraj = dpDatumKraj.SelectedDate.Value; if (cbStatus.IsChecked == true) { original.Status = true; } else { original.Status = false; } if (mod == MOD.DODAVANJE) { int id = Aplikacija.Instanca.Kursevi.Count + 1; original.Id = id; Aplikacija.Instanca.Kursevi.Add(original); KursDAO.Create(original); } else { KursDAO.Update(original); } this.Close(); } catch (FormatException) { MessageBox.Show("Plata mora biti broj"); } }