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