public static void DodajTraceMaterial(trace_material poz) { using (var db = new ecoplastolEntities()) { db.trace_material.Add(poz); db.SaveChanges(); } }
public static void PoprawTraceMaterial(trace_material poz) { using (var db = new ecoplastolEntities()) { db.Entry(poz).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); } }
public static void UsunTraceMaterial(trace_material poz) { using (var db = new ecoplastolEntities()) { db.trace_material.Attach(poz); db.trace_material.Remove(poz); db.SaveChanges(); } }
private void BtnDodaj_Click(object sender, RoutedEventArgs e) { akcja = "D"; grdBookmark = grdLista.SelectedIndex; grdLista.IsEnabled = false; grdPozycje.IsEnabled = true; btnDodaj.IsEnabled = false; btnKlonuj.IsEnabled = false; btnPopraw.IsEnabled = false; btnUsun.IsEnabled = false; btnAnuluj.IsEnabled = true; btnZatwierdz.IsEnabled = true; trace_material poz = new trace_material(); grdPozycje.DataContext = poz; }
private void BtnKlonuj_Click(object sender, RoutedEventArgs e) { akcja = "K"; grdLista.IsEnabled = false; grdPozycje.IsEnabled = true; btnDodaj.IsEnabled = false; btnKlonuj.IsEnabled = false; btnPopraw.IsEnabled = false; btnUsun.IsEnabled = false; btnAnuluj.IsEnabled = true; btnZatwierdz.IsEnabled = true; trace_material poz = new trace_material(); poz.parametr = rowTraceMaterial.parametr; poz.wartosc = rowTraceMaterial.wartosc; poz.opis = rowTraceMaterial.opis; grdPozycje.DataContext = poz; }
private void BtnZatwierdz_Click(object sender, RoutedEventArgs e) { grdLista.IsEnabled = true; grdPozycje.IsEnabled = false; btnDodaj.IsEnabled = true; btnKlonuj.IsEnabled = true; btnPopraw.IsEnabled = true; btnUsun.IsEnabled = true; btnAnuluj.IsEnabled = false; btnZatwierdz.IsEnabled = false; switch (akcja) { case "D": case "K": if (grdPozycje.DataContext is trace_material) { var row = new trace_material(); row = grdPozycje.DataContext as trace_material; row.id = PanelTrace_db.IdTraceMaterial(); row.opw = frmLogin.LoggedUser.login; row.czasw = DateTime.Now; row.opm = frmLogin.LoggedUser.login; row.czasm = DateTime.Now; PanelTrace_db.DodajTraceMaterial(row); } break; case "P": rowTraceMaterial.opm = frmLogin.LoggedUser.login; rowTraceMaterial.czasm = DateTime.Now; PanelTrace_db.PoprawTraceMaterial(rowTraceMaterial); break; default: break; } listTraceMaterial = PanelTrace_db.PobierzTraceMaterial(); grdLista.ItemsSource = listTraceMaterial; }
private void GrdLista_SelectionChanged(object sender, SelectionChangedEventArgs e) { rowTraceMaterial = grdLista.SelectedItem as trace_material; grdPozycje.DataContext = rowTraceMaterial; }