private void CheckExchangesStatus(int code) { if (code.Equals(EXCHANGE_STATUS)) { // провірити чи є товар в даний момент на складі try { GoodsShops goodsShop = (db.GoodsShops as IEnumerable <GoodsShops>) .Where(x => x.Good_ID.Equals(GoodsComboBox.SelectedValue) && x.Shop_ID.Equals(employee.Shop_ID)) .FirstOrDefault(); if (goodsShop.Count > 0) { db.GoodsShops.Attach(goodsShop); goodsShop.Count -= 1; db.SaveChanges(); createService(code); this.Close(); } else { MessageBox.Show("В даний момент у магазині немає цього товару", "Повідомлення", MessageBoxButtons.OK, MessageBoxIcon.Information); } } catch (NullReferenceException) { MessageBox.Show("В даний момент у магазині немає цього товару", "Повідомлення", MessageBoxButtons.OK, MessageBoxIcon.Information); } } else { createService(code); this.Close(); } }
private void NewShipmentForm_FormClosing(object sender, FormClosingEventArgs e) { if (DialogResult == DialogResult.OK) { Delivery delivery = (db.Delivery as IEnumerable <Delivery>) .Where(x => x.Deliver_ID.Equals(DeliveryComboBox.SelectedValue)) .FirstOrDefault(); GoodsShops gs = (db.GoodsShops as IEnumerable <GoodsShops>) .Where(x => x.Shop_ID.Equals(ShopComboBox.SelectedValue ?? 0) && x.Good_ID.Equals(delivery.Good_ID)) .FirstOrDefault(); if (gs != null) { db.GoodsShops.Attach(gs); gs.Count += delivery.Count; } else { gs = new GoodsShops() { Code = CodeGenerator.GenerateCode("GoodsShops", "gs"), Good_ID = delivery.Good_ID, Shop_ID = (int)ShopComboBox.SelectedValue, Count = delivery.Count }; db.GoodsShops.Add(gs); db.SaveChanges(); gs = (db.GoodsShops as IEnumerable <GoodsShops>) .Where(x => x.Shop_ID.Equals(ShopComboBox.SelectedValue ?? 0) && x.Good_ID.Equals(delivery.Good_ID)) .FirstOrDefault(); } Shipment shipment = new Shipment() { Deliver_ID = delivery.Deliver_ID, GoodsShops_ID = gs.GoodsShops_ID, Employee_ID = (int)EmployeeComboBox.SelectedValue, Date = DateTime.Now }; db.Shipment.Add(shipment); db.SaveChanges(); } e.Cancel = false; }
public GoodsShopsIEF(GoodsShops obj, my_db_for_db_2Entities _db) { InitializeComponent(); db = _db; goodsBindingSource.DataSource = db.Goods.ToList(); shopsBindingSource.DataSource = db.Shops.ToList(); goodsShopsBindingSource.DataSource = db.GoodsShops.ToList(); if (obj == null) { goodsShopsBindingSource.DataSource = new GoodsShops(); db.GoodsShops.Add(goodsShopsBindingSource.Current as GoodsShops); } else { goodsShopsBindingSource.DataSource = obj; db.GoodsShops.Attach(goodsShopsBindingSource.Current as GoodsShops); } }
private void NewTransportationForm_FormClosing(object sender, FormClosingEventArgs e) { if (DialogResult == DialogResult.OK) { if (!ShopFromComboBox.SelectedValue.Equals(ShopToComboBox.SelectedValue)) { if (countNUD.Value < 1) { MessageBox.Show("Оберіть кількість", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information); e.Cancel = true; return; } else { int goodID = (int)(goodsComboBox.SelectedValue ?? 0); int shopTo = (int)(ShopToComboBox.SelectedValue ?? 0); GoodsShops GS_To = (db.GoodsShops as IEnumerable <GoodsShops>) .Where(x => x.Good_ID.Equals(goodID) && x.Shop_ID.Equals(shopTo)) .Select(x => x) .FirstOrDefault(); if (GS_To == null) { GS_To = new GoodsShops() { Code = CodeGenerator.GenerateCode("GoodsShops", "gs"), Good_ID = goodID, Shop_ID = shopTo, Count = 0 }; db.GoodsShops.Add(GS_To); db.SaveChanges(); GS_To = (db.GoodsShops as IEnumerable <GoodsShops>) .Where(x => x.Good_ID.Equals(goodID) && x.Shop_ID.Equals(shopTo)) .Select(x => x) .FirstOrDefault(); } GoodsShops GS_From = (db.GoodsShops as IEnumerable <GoodsShops>) .Where(x => x.Good_ID.Equals(goodID) && x.Shop_ID.Equals(ShopFromComboBox.SelectedValue ?? 0)) .Select(x => x) .FirstOrDefault(); int count = (int)countNUD.Value; Transportation transportation = new Transportation() { GS_from_ID = GS_From.GoodsShops_ID, GS_in_ID = GS_To.GoodsShops_ID, Employee_ID = employee.Employee_ID, Date = DateTime.Now, Count = count }; db.Transportation.Add(transportation); db.GoodsShops.Attach(GS_From); GS_From.Count -= count; db.GoodsShops.Attach(GS_To); GS_To.Count += count; db.SaveChanges(); //this.Close(); } } else { MessageBox.Show("Оберіть різні магазини", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information); e.Cancel = true; return; } } e.Cancel = false; }