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