private void SubmitBorder_MouseDown(object sender, MouseButtonEventArgs e) { try { Customer cust = new Customer(); cust.FullName = textBox_surname.Text + " " + textBox_name.Text + " " + textBox_fathername.Text; cust.PassportNumber = textBox_Passport.Text; cust.PermitWeapon = textBox_Weapon.Text; cust.ValidFrom = Convert.ToDateTime(textBox_validfrom.Text); cust.ValidTo = Convert.ToDateTime(textBox_validto.Text); UserContext db = new UserContext(); db.Customers.Add(cust); db.SaveChanges(); this.Close(); } catch { MessageBox.Show("Error"); } }
private void button2_Click(object sender, RoutedEventArgs e) { try { if (textBox_Count.Text != "" && textBox_Count.Text != "0" && textBox_PurchasePrice.Text != "" && textBox_PurchasePrice.Text != "0" && textBox_SellPrice.Text != "" && textBox_SellPrice.Text != "0") { UserContext db = new UserContext(); if (delinfo == null) { DeliveryViewModel edit = dataGridGoods.SelectedItem as DeliveryViewModel; DeliveryViewModel f = lst.FirstOrDefault(x => x == edit); db.Goodss.FirstOrDefault(x => x.Id == f.GoodsId).Balance -= f.Count; f.Price = Convert.ToDouble(textBox_PurchasePrice.Text); f.Count = Convert.ToInt32(textBox_Count.Text); db.Goodss.Find(edit.GoodsId).SellPrice = Convert.ToDouble(textBox_SellPrice.Text); db.Goodss.Find(f.GoodsId).PricePurchase = Convert.ToDouble(textBox_PurchasePrice.Text); db.Goodss.FirstOrDefault(x => x.Id == f.GoodsId).Balance += f.Count; dataGridGoods.ItemsSource = null; } else { delinfo.Price = Convert.ToDouble(textBox_PurchasePrice.Text); delinfo.Count = Convert.ToInt32(textBox_Count.Text); db.Goodss.Find(delinfo.GoodsId).SellPrice = Convert.ToDouble(textBox_SellPrice.Text); db.Goodss.Find(delinfo.GoodsId).PricePurchase = Convert.ToDouble(textBox_PurchasePrice.Text); lst.Add(delinfo); db.Goodss.FirstOrDefault(x => x.Id == delinfo.GoodsId).Balance += delinfo.Count; dataGridGoods.ItemsSource = null; delinfo = null; } db.SaveChanges(); button1_Click(null, null); } else { MessageBox.Show("Неправильный ввод"); } } catch { MessageBox.Show("Error"); } }
private void button2_Click(object sender, RoutedEventArgs e) { UserContext db = new UserContext(); if (delinfo == null) { OrderViewModel edit = dataGridGoods.SelectedItem as OrderViewModel; OrderViewModel f = lst.FirstOrDefault(x => x == edit); f.Price = Convert.ToDouble(textBLock_Price.Text); f.Count = Convert.ToInt32(textBox_Count.Text); dataGridGoods.ItemsSource = null; } else { delinfo.Price = Convert.ToDouble(textBLock_Price.Text); delinfo.Count = Convert.ToInt32(textBox_Count.Text); lst.Add(delinfo); dataGridGoods.ItemsSource = null; delinfo = null; } db.SaveChanges(); button1_Click(null, null); }
private void button7_Click(object sender, RoutedEventArgs e) { try { UserContext db = new UserContext(); if (IdDelivery == -1) { DeliveryNote delnew = new DeliveryNote(); delnew.Employees = db.Emloyees.FirstOrDefault(x => x.Id == EmployeeId); delnew.TypePayment = comboBox_TypePayment.SelectedItem as string; delnew.Sum = 0; delnew.Date = DateTime.Now; foreach (DeliveryViewModel delvm in lst) { DeliveryInfo delinfo = new DeliveryInfo(); delinfo.Count = delvm.Count; delinfo.Price = delvm.Price; delinfo.Goods = db.Goodss.Find(delvm.GoodsId); delnew.Sum += delvm.Summa; delnew.DeliveryInfos.Add(delinfo); } delnew.SavePDF(); db.DeliveryNotes.Add(delnew); } else { DeliveryNote delnew = db.DeliveryNotes.FirstOrDefault(x => x.Id == IdDelivery); delnew.Employees = db.Emloyees.FirstOrDefault(x => x.Id == EmployeeId); delnew.TypePayment = comboBox_TypePayment.SelectedItem as string; delnew.Sum = 0; delnew.Date = DateTime.Now; delnew.DeliveryInfos.Clear(); foreach (DeliveryViewModel delvm in lst) { DeliveryInfo delinfo = new DeliveryInfo(); delinfo.Count = delvm.Count; delinfo.Price = delvm.Price; delinfo.Goods = db.Goodss.Find(delvm.GoodsId); delnew.Sum += delvm.Summa; delnew.DeliveryInfos.Add(delinfo); } delnew.SavePDF(); } db.SaveChanges(); Close(); } catch { MessageBox.Show("Error"); } }
private void button7_Click(object sender, RoutedEventArgs e) { try { UserContext db = new UserContext(); if (IdDelivery == -1) { Order delnew = new Order(); delnew.Employees = db.Emloyees.FirstOrDefault(x => x.Id == EmployeeId); delnew.Date = DateTime.Now; if (checkBox.IsChecked == true) delnew.Status = true; else delnew.Status = false; foreach (OrderViewModel delvm in lst) { OrderInfo delinfo = new OrderInfo(); delinfo.Count = delvm.Count; delinfo.Goods = db.Goodss.Find(delvm.GoodsId); delnew.OrderInfos.Add(delinfo); } db.Orders.Add(delnew); delnew.SavePDF(); } else { Order delnew = db.Orders.Include("OrderInfos").FirstOrDefault(x => x.Id == IdDelivery); delnew.Employees = db.Emloyees.FirstOrDefault(x => x.Id == EmployeeId); delnew.OrderInfos.Clear(); delnew.Date = DateTime.Now; if (checkBox.IsChecked == true) delnew.Status = true; else delnew.Status = false; delnew.OrderInfos.Clear(); foreach (OrderViewModel delvm in lst) { OrderInfo delinfo = new OrderInfo(); delinfo.Count = delvm.Count; delinfo.Goods = db.Goodss.Find(delvm.GoodsId); delnew.OrderInfos.Add(delinfo); } delnew.SavePDF(); } foreach (OrderInfo s in db.OrderInfos.ToList()) { if (s.GoodsId == null) db.OrderInfos.Remove(s); } db.SaveChanges(); Close(); } catch { MessageBox.Show("Error"); } }