private void button3_Click(object sender, EventArgs e) { HashSet <int> rows = new HashSet <int>(); foreach (var row in productsDataGridView.SelectedCells) { int RowIndex = ((System.Windows.Forms.DataGridViewTextBoxCell)row).RowIndex; rows.Add((int)productsDataGridView[0, RowIndex].Value); } foreach (int row in rows) { using (WMSEntities cont = new WMSEntities()) { var query = from t in cont.Products where t.ID == row select t; if (query.Count() > 0) { var t = query.ToList().First(); cont.Products.Remove(t); cont.SaveChanges(); } } } ProductsForm_Load(null, null); }
private void button1_Click(object sender, EventArgs e) { using (WMSEntities cont = new WMSEntities()) { Users t = new Users { ID = 1 + LastID(), Name = textBox2.Text }; cont.Users.Add(t); cont.SaveChanges(); } UsersForm_Load(null, null); }
private void btnRefill_Click(object sender, EventArgs e) { int warehouseID = Int32.Parse(cmbWarehouse.SelectedItem.ToString()); string ProductName = Search_txt.Text; if (String.IsNullOrEmpty(txtQuantity.Text)) { MessageBox.Show("Please insert a quantity!!"); return; } int quantity = Int32.Parse(txtQuantity.Text.ToString()); if (quantity <= 0) { MessageBox.Show("Please insert a valid quantity (greater than zero)!!"); txtQuantity.Clear(); txtQuantity.Focus(); return; } using (var context = new WMSEntities()) { var result = (from p in context.Products where p.ProductName == ProductName select p.ProductID).First(); int prodID = Int32.Parse(result.ToString()); Form Barcode = new FormBarcode(prodID); Barcode.ShowDialog(); } Form Refill = new RefillForm(0, warehouseID, ProductName, txtQuantity.Text.ToString(), true); Refill.ShowDialog(); using (var context = new WMSEntities()) { using (var dbContextTransaction = context.Database.BeginTransaction()) { try { context.RefillFromWarehouse(0, warehouseID, quantity, ProductName); context.SaveChanges(); dbContextTransaction.Commit(); } catch (Exception ex) { MessageBox.Show(ex.Message.ToString()); dbContextTransaction.Rollback(); } } } }
//додавання нового рядка private void button1_Click(object sender, EventArgs e) { using (WMSEntities cont = new WMSEntities()) { Clients t = new Clients() { ID = 1 + LastID(), Name = textBox2.Text, Code = textBox1.Text }; cont.Clients.Add(t); cont.SaveChanges(); } Form1_Load(null, null); }
//кнопка "ОК" private void button1_Click(object sender, EventArgs e) { //перевірка кокектності заповнення if (NameText.Text.Trim().Length == 0) { MessageBox.Show("Name is empty !"); return; } if (AmountText.Text.Trim().Length == 0) { MessageBox.Show("Amount is empty !"); return; } if (WidthText.Text.Trim().Length == 0) { MessageBox.Show("Width is empty !"); return; } if (HeightText.Text.Trim().Length == 0) { MessageBox.Show("Height is empty !"); return; } if (DepthText.Text.Trim().Length == 0) { MessageBox.Show("Depth is empty !"); return; } decimal nAmount; if (!decimal.TryParse(AmountText.Text.Trim(), out nAmount)) { MessageBox.Show("Amount: bad format of number !"); return; } decimal nWidth; if (!decimal.TryParse(WidthText.Text.Trim(), out nWidth)) { MessageBox.Show("Width: bad format of number !"); return; } decimal nHeight; if (!decimal.TryParse(HeightText.Text.Trim(), out nHeight)) { MessageBox.Show("Height: bad format of number !"); return; } decimal nDepth; if (!decimal.TryParse(DepthText.Text.Trim(), out nDepth)) { MessageBox.Show("Depth: bad format of number !"); return; } if (clientsDataGridView.SelectedCells.Count == 0) { MessageBox.Show("Choose the Client !"); return; } if (regionDataGridView.SelectedCells.Count == 0) { MessageBox.Show("Choose the Region !"); return; } var row = clientsDataGridView.SelectedCells[0]; int RowIndex = ((System.Windows.Forms.DataGridViewTextBoxCell)row).RowIndex; int nClientID = (int)clientsDataGridView[0, RowIndex].Value; row = regionDataGridView.SelectedCells[0]; RowIndex = ((System.Windows.Forms.DataGridViewTextBoxCell)row).RowIndex; int nRegionID = (int)regionDataGridView[0, RowIndex].Value; using (WMSEntities cont = new WMSEntities()) { Products t = new Products { ID = int.Parse(IDText.Text), Name = NameText.Text.Trim(), Amount = nAmount, Width = nWidth, Height = nHeight, Depth = nDepth, ClientID = nClientID, RegionID = nRegionID, }; cont.Products.AddOrUpdate(t); cont.SaveChanges(); } DialogResult = DialogResult.OK; Close(); }
private void button1_Click(object sender, EventArgs e) { if (NameText.Text.Trim().Length == 0) { MessageBox.Show("Name is empty !"); return; } if (AmountText.Text.Trim().Length == 0) { MessageBox.Show("Amount is empty !"); return; } if (WidthText.Text.Trim().Length == 0) { MessageBox.Show("Width is empty !"); return; } if (HeightText.Text.Trim().Length == 0) { MessageBox.Show("Height is empty !"); return; } if (DepthText.Text.Trim().Length == 0) { MessageBox.Show("Depth is empty !"); return; } if (StillageText.Text.Trim().Length == 0) { MessageBox.Show("Stillage is empty !"); return; } if (TierText.Text.Trim().Length == 0) { MessageBox.Show("Tier is empty !"); return; } if (PositionText.Text.Trim().Length == 0) { MessageBox.Show("Position is empty !"); return; } if (SizeControlText.Text.Trim().Length == 0) { MessageBox.Show("Size control is empty !"); return; } if (AmountControlText.Text.Trim().Length == 0) { MessageBox.Show("Amount control is empty !"); return; } decimal nAmount; if (!decimal.TryParse(AmountText.Text.Trim(), out nAmount)) { MessageBox.Show("Amount: bad format of number !"); return; } decimal nWidth; if (!decimal.TryParse(WidthText.Text.Trim(), out nWidth)) { MessageBox.Show("Width: bad format of number !"); return; } decimal nHeight; if (!decimal.TryParse(HeightText.Text.Trim(), out nHeight)) { MessageBox.Show("Height: bad format of number !"); return; } decimal nDepth; if (!decimal.TryParse(DepthText.Text.Trim(), out nDepth)) { MessageBox.Show("Depth: bad format of number !"); return; } int nStillage; if (!int.TryParse(StillageText.Text.Trim(), out nStillage)) { MessageBox.Show("Stillage: bad format of number !"); return; } int nTier; if (!int.TryParse(TierText.Text.Trim(), out nTier)) { MessageBox.Show("Tier: bad format of number !"); return; } int nPosition; if (!int.TryParse(PositionText.Text.Trim(), out nPosition)) { MessageBox.Show("Position: bad format of number !"); return; } int nSizeControl; if (!int.TryParse(SizeControlText.Text.Trim(), out nSizeControl)) { MessageBox.Show("Size control: bad format of number !"); return; } int nAmountControl; if (!int.TryParse(AmountControlText.Text.Trim(), out nAmountControl)) { MessageBox.Show("Amount control: bad format of number !"); return; } if (clientsDataGridView.SelectedCells.Count == 0) { MessageBox.Show("Choose the Client !"); return; } if (regionDataGridView.SelectedCells.Count == 0) { MessageBox.Show("Choose the Region !"); return; } if (warehoesesGridView.SelectedCells.Count == 0) { MessageBox.Show("Choose the Warehouse !"); return; } var row = clientsDataGridView.SelectedCells[0]; int RowIndex = ((System.Windows.Forms.DataGridViewTextBoxCell)row).RowIndex; int nTypeID = (int)clientsDataGridView[0, RowIndex].Value; row = regionDataGridView.SelectedCells[0]; RowIndex = ((System.Windows.Forms.DataGridViewTextBoxCell)row).RowIndex; int nRegionID = (int)regionDataGridView[0, RowIndex].Value; row = warehoesesGridView.SelectedCells[0]; RowIndex = ((System.Windows.Forms.DataGridViewTextBoxCell)row).RowIndex; int nWareID = (int)warehoesesGridView[0, RowIndex].Value; using (WMSEntities cont = new WMSEntities()) { Cells t = new Cells { ID = int.Parse(IDText.Text), Name = NameText.Text.Trim(), Amount = nAmount, Width = nWidth, Height = nHeight, Depth = nDepth, Stillage = nStillage, Tier = nTier, Position = nPosition, SizeControl = nSizeControl, AmountControl = nAmountControl, TypeID = nTypeID, RegionID = nRegionID, WarehouseID = nWareID }; cont.Cells.AddOrUpdate(t); cont.SaveChanges(); } DialogResult = DialogResult.OK; Close(); }
private void regionsDataGridView_CellEndEdit(object sender, DataGridViewCellEventArgs e) { context.SaveChanges(); }
private void TryRefillfromWarehouse(string Product, string Quantity, int DestinationWarehouseID, int OrderID, string ClientName, string Adress) { using (var context = new WMSEntities()) { using (var dbContextTransaction = context.Database.BeginTransaction()) { try { int quantity = Int32.Parse(Quantity); var result = (from p in context.Products where p.ProductName.Equals(Product) && p.UnitsInStock >= quantity select new { SourceWarehouseID = p.WarehouseID, units = p.UnitsInStock, prodID = p.ProductID, rowID = p.RowID, price = p.UnitPrice }); if (!string.IsNullOrWhiteSpace(result.ToString())) { if (result.Count() != 0) { var rez = result.ToList(); DialogResult dr = MessageBox.Show(String.Format("Do you want to refill warehouse {0} from warehouse {1} with product ->{2}, units->{3}?", DestinationWarehouseID, rez[0].SourceWarehouseID, Product, Quantity), "The Question", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button1); switch (dr) { case DialogResult.Yes: { int sourceID; Int32.TryParse(rez[0].SourceWarehouseID.ToString(), out sourceID); float price = float.Parse(rez[0].price.ToString()); Form refill = new RefillForm(sourceID, DestinationWarehouseID, Product, Quantity, false); refill.ShowDialog(); context.RefillFromWarehouse(rez[0].SourceWarehouseID, DestinationWarehouseID, quantity, Product); refill.Close(); // Form BarCodeCheck = new BarCodeCheck(rez[0].prodID); // BarCodeCheck.Show(); MessageBox.Show("The refill is done! Order is ready to be processed! "); Form fr = new ProcessingOrder(OrderID.ToString(), ClientName, Adress, Product, quantity, rez[0].rowID, price); fr.Show(); context.UpdateDB(Product, quantity, DestinationWarehouseID); context.SaveChanges(); context.MarkProcessed(OrderID, rez[0].prodID); context.SaveChanges(); dbContextTransaction.Commit(); break; }; case DialogResult.No: { break; }; } } else { var rez = (from p in context.Products where p.ProductName.Equals(Product) select new { prodID = p.ProductID, rowID = p.RowID, Price = p.UnitPrice }).ToList(); Form refill = new RefillForm(0, DestinationWarehouseID, Product, Quantity, false); refill.ShowDialog(); // Form BarCodeCheck = new BarCodeCheck(rez[0].prodID); //BarCodeCheck.Show(); context.RefillFromWarehouse(0, DestinationWarehouseID, quantity, Product); context.SaveChanges(); refill.Close(); MessageBox.Show("The refill is done! Order is ready to be processed! "); float price = float.Parse(rez[0].Price.ToString()); Form fr = new ProcessingOrder(OrderID.ToString(), ClientName, Adress, Product, quantity, rez[0].rowID, price); fr.Show(); context.MarkProcessed(OrderID, rez[0].prodID); context.SaveChanges(); context.UpdateDB(Product, quantity, DestinationWarehouseID); context.SaveChanges(); dbContextTransaction.Commit(); } } } catch (Exception ex) { MessageBox.Show(ex.Message.ToString()); dbContextTransaction.Rollback(); } } } }
private void btnProcessOrder_Click(object sender, EventArgs e) { try { if (gvUnproccOrders.SelectedCells.Count == 0) { throw new Exception("No orders to process!"); } if (gvUnproccOrders.SelectedCells.Count < 2) { throw new Exception("Select the entire row!"); } string SearchValue = ""; string OrderID = ""; foreach (DataGridViewRow row in gvUnproccOrders.SelectedRows) { OrderID = row.Cells[0].Value.ToString(); SearchValue = OrderID; } int rowIndex = -1; foreach (DataGridViewRow row in gvUnproccOrders.Rows) { if (row.Cells[0].Value.ToString().Equals(SearchValue)) { rowIndex = row.Index; gvUnproccOrders.Rows[rowIndex].Selected = true; string ClientName = row.Cells[1].Value.ToString(); string Adress = row.Cells[2].Value.ToString(); string Product = row.Cells[3].Value.ToString(); string Quantity = row.Cells[4].Value.ToString(); string WarehouseID = row.Cells[5].Value.ToString(); using (var context = new WMSEntities()) { using (var dbContextTransaction = context.Database.BeginTransaction()) { try { var prodID = (from p in context.Products where p.ProductName.Equals(Product) select p).First().ProductID; int warehouseID = Int32.Parse(WarehouseID); var WarehouseName = (from c in context.Warehouses where c.WarehouseID.Equals(warehouseID) select c).First().Address; var check = (from p in context.Products where p.ProductName.Equals(Product) && p.WarehouseID.Equals(warehouseID) select p).FirstOrDefault(); if (check != null) { if (!string.IsNullOrWhiteSpace(check.ToString())) { var unitsInStock = (from p in context.Products where p.ProductName.Equals(Product) && p.WarehouseID.Equals(warehouseID) select p).FirstOrDefault().UnitsInStock; if (unitsInStock < Int32.Parse(Quantity)) { MessageBox.Show(String.Format("Unfortunately, warehouse {0} do not have {1} units of {2}. Trying to refill from other warehouses...", WarehouseID, Quantity, Product)); int orderID = Int32.Parse(OrderID); TryRefillfromWarehouse(Product, Quantity, warehouseID, orderID, ClientName, Adress); } else { var rez = (from p in context.Products where p.ProductName.Equals(Product) select new { rowID = p.RowID, Price = p.UnitPrice, prodID = p.ProductID }).ToList(); int quantity = Int32.Parse(Quantity); float price = float.Parse(rez[0].Price.ToString()); Form processingForm = new ProcessingOrder(OrderID, ClientName, Adress, Product, quantity, rez[0].rowID, price); processingForm.Show(); int units = Int32.Parse(Quantity); int orderID = Int32.Parse(OrderID); context.UpdateDB(Product, units, warehouseID); context.SaveChanges(); context.MarkProcessed(orderID, prodID); context.SaveChanges(); dbContextTransaction.Commit(); } } } else { int orderID = Int32.Parse(OrderID); MessageBox.Show(String.Format("Unfortunately, {0} warehouse do not have {1} units of {2}. Trying to refill from other warehouses...", WarehouseName, Quantity, Product)); TryRefillfromWarehouse(Product, Quantity, warehouseID, orderID, ClientName, Adress); } } catch (Exception ex) { MessageBox.Show(ex.Message.ToString()); dbContextTransaction.Rollback(); } } } } } this.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message, "Message", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void usersBindingNavigatorSaveItem_Click(object sender, EventArgs e) { context.SaveChanges(); }
private void btnAcceptSuggestion_Click(object sender, EventArgs e) { try { if (gvSuggestedReffils.SelectedCells.Count == 0) { throw new Exception("No suggestions!"); } if (gvSuggestedReffils.SelectedCells.Count < 2) { throw new Exception("Select the entire row!"); } string SearchValue = ""; string SuggestedOrderID = ""; foreach (DataGridViewRow row in gvSuggestedReffils.SelectedRows) { SuggestedOrderID = row.Cells[0].Value.ToString(); SearchValue = SuggestedOrderID; } int rowIndex = -1; foreach (DataGridViewRow row in gvSuggestedReffils.Rows) { if (row.Cells[0].Value.ToString().Equals(SearchValue)) { rowIndex = row.Index; gvSuggestedReffils.Rows[rowIndex].Selected = true; string OrderID = row.Cells[0].Value.ToString(); string WarehouseID = row.Cells[2].Value.ToString(); string Product = row.Cells[1].Value.ToString(); if (string.IsNullOrWhiteSpace(txtQuantity.Text) || txtQuantity.Text == "0") { throw new Exception("Please insert a quantity!\n"); } string Quantity = txtQuantity.Text.ToString(); using (var context = new WMSEntities()) { using (var dbContextTransaction = context.Database.BeginTransaction()) { try { context.AcceptSuggestion(Int32.Parse(OrderID), Int32.Parse(Quantity)); context.SaveChanges(); int warehouseID = Int32.Parse(WarehouseID); using (var context1 = new WMSEntities()) { var result = (from p in context1.Products where p.ProductName == Product select p.ProductID).First(); int prodID = Int32.Parse(result.ToString()); Form Barcode = new FormBarcode(prodID); Barcode.ShowDialog(); } Form RefillForm = new RefillForm(0, warehouseID, Product, Quantity, true); RefillForm.ShowDialog(); dbContextTransaction.Commit(); } catch (Exception ex) { MessageBox.Show(ex.Message.ToString()); dbContextTransaction.Rollback(); } } } } } this.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message, "Message", MessageBoxButtons.OK, MessageBoxIcon.Error); } }