private void Button_Click_4(object sender, RoutedEventArgs e) { SdelkaModel sdelkaModel = (SdelkaModel)sdelkaList.SelectedItem; using (ModelDB db = new ModelDB()) { Sdelka sdelka = db.Sdelka.Where(p => p.sdelka1 == sdelkaModel.id).FirstOrDefault(); if (sdelka != null) { db.Entry(sdelka).State = EntityState.Deleted; db.SaveChanges(); } } sdelkaList.SelectedItem = null; UpdateSdelka(); }
private void sdelkaList_SelectionChanged(object sender, SelectionChangedEventArgs e) { if (sdelkaList.SelectedItem != null) { SdelkaModel sdelkaModel = (SdelkaModel)sdelkaList.SelectedItem; using (ModelDB db = new ModelDB()) { Sdelka sdelka = db.Sdelka.Where(p => p.sdelka1 == sdelkaModel.id).FirstOrDefault(); id_client.Text = db.Client.Where(p => p.Id_client == sdelka.id_client).FirstOrDefault().Fio; id_tovar.Text = db.Tovar.Where(p => p.id_tovar == sdelka.id_tovar).FirstOrDefault().name; count.Text = sdelka.count.ToString(); sum.Text = sdelka.sum.ToString(); Date.SelectedDate = sdelka.data; sdelkaModel = null; } } }
private void Button_Click_2(object sender, RoutedEventArgs e) { using (ModelDB db = new ModelDB()) { int id_cl = db.Client.Where(p => p.Fio.Equals(id_client.SelectedItem.ToString())).FirstOrDefault().Id_client; int id_tv = db.Tovar.Where(p => p.name.Equals(id_tovar.SelectedItem.ToString())).FirstOrDefault().id_tovar; Sdelka sdelka = new Sdelka(); sdelka.id_client = id_cl; sdelka.id_tovar = id_tv; sdelka.sum = decimal.Parse(sum.Text); sdelka.count = int.Parse(count.Text); sdelka.data = Date.SelectedDate.Value; db.Sdelka.Add(sdelka); db.SaveChanges(); UpdateSdelka(); } }
private void Button_Click_3(object sender, RoutedEventArgs e) { SdelkaModel sdelkaModel = (SdelkaModel)sdelkaList.SelectedItem; using (ModelDB db = new ModelDB()) { Sdelka sdelka = db.Sdelka.Where(p => p.sdelka1 == sdelkaModel.id).FirstOrDefault(); sdelka.sum = decimal.Parse(sum.Text); sdelka.sdelka1 = sdelkaModel.id; sdelka.count = int.Parse(count.Text); sdelka.data = Date.SelectedDate.Value; string name = id_tovar.SelectedValue.ToString(); string fio = id_client.SelectedValue.ToString(); sdelka.id_tovar = db.Tovar.Where(p => p.name.Equals(name)).FirstOrDefault().id_tovar; sdelka.id_client = db.Client.Where(p => p.Fio.Equals(fio)).FirstOrDefault().Id_client; db.Entry(sdelka).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); } UpdateSdelka(); sdelkaList.SelectedItem = null; }