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