private void btnSubmit_Click(object sender, EventArgs e) { string strPart = txtPartNumber.Text; int strQuantity = Convert.ToInt32(txtQuantity.Text); InventoryEntity entity = new InventoryEntity(); Inventory_Transactions itrans = new Inventory_Transactions(); var parts = (from p in entity.Inventory_Parts where p.PartNumber == strPart select p).Count(); if (parts == 0) { MessageBox.Show("That part does not exist, try again!"); } else { itrans.PartNumber = strPart; if (strDirection == "out") { itrans.TransactionType = "Inventory Out"; strQuantity = strQuantity * -1; } else { itrans.TransactionType = "Inventory In"; } itrans.Quantity = strQuantity; entity.Inventory_Transactions.Add(itrans); entity.SaveChanges(); if (strDirection == "out") { MessageBox.Show("Inventory Released. Great!"); } else { MessageBox.Show("Inventory Received. Awesome!"); } } }
private void btnSubmit_Click(object sender, EventArgs e) { string strPartNumber = txtPartNumber.Text; string strJobNumber = txtJobNumber.Text; int strLotNumber = Convert.ToInt32(txtLotNumber.Text); string strDetailNumber = txtDetailNumber.Text; string strMfg = txtMfg.Text; string strNomen = txtNomenclature.Text; string strSupplier = txtSupplier.Text; int strQtyUnit = Convert.ToInt32(txtQtyUnit.Text); int strQtyTotal = Convert.ToInt32(txtQtyTotal.Text); string strPO = txtPO.Text; try { InventoryEntity entity = new InventoryEntity(); Inventory_Parts inventory_Parts1 = new Inventory_Parts(); inventory_Parts1.PartNumber = strPartNumber; inventory_Parts1.JobNumber = strJobNumber; inventory_Parts1.LotNumber = strLotNumber; inventory_Parts1.DetailNumber = strDetailNumber; inventory_Parts1.MfgPart = strMfg; inventory_Parts1.Nomenclature = strNomen; inventory_Parts1.Supplier = strSupplier; inventory_Parts1.QtyReqdUnit = strQtyUnit; inventory_Parts1.QtyReqdTotal = strQtyTotal; inventory_Parts1.PO = strPO; entity.Inventory_Parts.Add(inventory_Parts1); entity.SaveChanges(); //var stocks = context.Stocks.AsQueryable(); //if (batchNumber != null) stocks = stocks.Where(s => s.Number = batchNumber); //if (name != null) stocks = stocks.Where(s => s.Name.StartsWith(name)); //var result = stocks.ToList(); // execute query // var result = context.Stocks //.Where(batchNumber == null || stock.Number == batchNumber) //.Where(name == null || s => s.Name.StartsWith(name)) //.ToList(); Inventory_Parts ip2 = new Inventory_Parts(); var iTransaction = entity.Inventory_Parts .Where(ip3 => ip3.JobNumber == strJobNumber) .Where(ip3 => ip3.LotNumber == strLotNumber) .Where(ip3 => ip3.DetailNumber == strDetailNumber) .Where(ip3 => ip3.PartNumber == strPartNumber) .ToList(); foreach (Inventory_Parts t in iTransaction) { Inventory_Transactions itrans2 = new Inventory_Transactions(); itrans2.PartNumber = t.PartNumber; itrans2.TransactionType = "Initial Quantity"; itrans2.Quantity = Convert.ToInt32(itxtQuantity.Text); entity.Inventory_Transactions.Add(itrans2); entity.SaveChanges(); } } catch (Exception e4) { MessageBox.Show(e4.InnerException.ToString()); } finally { MessageBox.Show("Part Added Successfully"); } }