//DELETE
private void Brisanje_Click(object sender, RoutedEventArgs e)
{
int pib = int.Parse(((TextBlock)glavniGrid.SelectedCells[0].Column.GetCellContent(glavniGrid.SelectedCells[0].Item)).Text);
int godina = int.Parse(((TextBlock)glavniGrid.SelectedCells[1].Column.GetCellContent(glavniGrid.SelectedCells[0].Item)).Text);
int mesec = int.Parse(((TextBlock)glavniGrid.SelectedCells[2].Column.GetCellContent(glavniGrid.SelectedCells[0].Item)).Text);
int sifraOsig = int.Parse(tbSifraOsiguranik.Text);
Uplate brisiUplatu = (from u in FondDC.Uplates
where u.PIB == pib && u.Godina == godina && u.Mesec == mesec && u.SifOsiguranika == sifraOsig
select u).SingleOrDefault();
MessageBoxResult deleteRezult = MessageBox.Show("Da li ste sigurni da zelite da obrisete uplatu? ", "Brisanje", MessageBoxButton.YesNo);
if (deleteRezult == MessageBoxResult.Yes)
{
FondDC.Uplates.DeleteOnSubmit(brisiUplatu);
puniGrid();
try {
FondDC.SubmitChanges();
MessageBox.Show("Uspesno brisanje");
tbUplacenoUnos.Text = tbUplacenoPoGodini.Text = "";
puniGrid();
cmbGodine.ItemsSource = null;
puniCombo();
} catch (Exception ex) {
MessageBox.Show(ex.Message);
}
}
}
//INSERT DATA
private void BtnPotvrdi_Click(object sender, RoutedEventArgs e)
{
if (!String.IsNullOrEmpty(tbGodinaUnos.Text) && !String.IsNullOrEmpty(tbUplacenoUnos.Text) && !String.IsNullOrEmpty(cmbFirme.SelectedItem.ToString()) && !String.IsNullOrEmpty(tbSifraOsiguranik.Text) && !String.IsNullOrEmpty(tbMesec.Text))
{
Uplate novaUplata = new Uplate {
PIB = ((Firma)cmbFirme.SelectedItem).PIB,
Godina = int.Parse(tbGodinaUnos.Text),
Mesec = int.Parse(tbMesec.Text),
Uplaceno = int.Parse(tbUplacenoUnos.Text),
SifOsiguranika = int.Parse(tbSifraOsiguranik.Text)
};
FondDC.Uplates.InsertOnSubmit(novaUplata);
try {
FondDC.SubmitChanges();
MessageBox.Show("Uspesan unos");
tbGodinaUnos.Text = tbUplacenoUnos.Text = tbMesec.Text = "";
sliderMesec.Value = 0;
cmbGodine.ItemsSource = null;
puniGrid();
puniCombo();
} catch (Exception ex) {
MessageBox.Show(ex.Message);
}
}
else
{
MessageBox.Show("Sva polja su obavezna");
}
}
private void attach_Uplates(Uplate entity)
{
this.SendPropertyChanging();
entity.Osiguranik = this;
}
private void detach_Uplates(Uplate entity)
{
this.SendPropertyChanging();
entity.Osiguranik = null;
}
partial void DeleteUplate(Uplate instance);
partial void UpdateUplate(Uplate instance);
partial void InsertUplate(Uplate instance);
private void detach_Uplates(Uplate entity)
{
this.SendPropertyChanging();
entity.Firma = null;
}
private void attach_Uplates(Uplate entity)
{
this.SendPropertyChanging();
entity.Firma = this;
}