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