private void EditPurchaseOrder(object sender, EventArgs e) { //get supplierID long supplierid = ((KeyValuePair <long, string>)supplierbox.SelectedItem).Key; //get destinationwarehouseid long destwarehouseid = ((KeyValuePair <long, string>)warehousebox.SelectedItem).Key; //getting date DateTime date = dateTimePicker1.Value; var existingpurchaseorder = db.Orders.Where(o => o.ID == OID).FirstOrDefault(); existingpurchaseorder.SupplierID = supplierid; existingpurchaseorder.DestinationWarehouseID = destwarehouseid; existingpurchaseorder.Date = date; //Delete all orderitems associated with this order being edited var existingorderitems = db.OrderItems.Where(oit => oit.OrderID == OID).ToList(); foreach (var item in existingorderitems) { db.OrderItems.Remove(item); } foreach (var item in listofparts) { OrderItem neworderitems = new OrderItem(); neworderitems.OrderID = (long)OID; neworderitems.PartID = item.partid; neworderitems.BatchNumber = item.batchnumber; neworderitems.Amount = item.amount; db.OrderItems.Add(neworderitems); } try { db.SaveChanges(); MessageBox.Show("Your changes have been saved"); this.Close(); } catch (Exception error) { MessageBox.Show("Unable to save changes. Report this error to technician: " + error.ToString()); } }
private void editWarehouseOrder() { using (Session4Entities db = new Session4Entities()) { var swid = ((Warehouse)sourcewarehousebox.SelectedItem).ID; var dwid = ((Warehouse)destinationwarehousebox.SelectedItem).ID; var date = Convert.ToDateTime(dateTimePicker1.Value); //retrieving existing warehouse order var existingwarehouseorder = db.Orders.Where(a => a.ID == OID).FirstOrDefault(); existingwarehouseorder.SourceWarehouseID = swid; existingwarehouseorder.DestinationWarehouseID = dwid; existingwarehouseorder.Date = date; //retrieving existing orderitems related to the order var existingwarehouseorderitems = db.OrderItems.Where(oit => oit.OrderID == OID).ToList(); foreach (var item in existingwarehouseorderitems) { db.OrderItems.Remove(item); } foreach (var item in listofparts) { OrderItem newOrderitem = new OrderItem(); newOrderitem.OrderID = (long)OID; newOrderitem.PartID = item.partid; newOrderitem.BatchNumber = item.batchnumber; newOrderitem.Amount = item.amount; db.OrderItems.Add(newOrderitem); } try { db.SaveChanges(); db.Dispose(); this.Close(); } catch (Exception error) { MessageBox.Show("Whoops, an error has occured. Error Message: " + error.ToString()); } } }
private void newWarehouseOrder() { using (Session4Entities db = new Session4Entities()) { var swid = ((Warehouse)sourcewarehousebox.SelectedItem).ID; var dwid = ((Warehouse)destinationwarehousebox.SelectedItem).ID; var date = Convert.ToDateTime(dateTimePicker1.Value); Order newOrder = new Order(); newOrder.SourceWarehouseID = swid; newOrder.DestinationWarehouseID = dwid; newOrder.TransactionTypeID = 2; newOrder.Supplier = null; newOrder.Date = date; db.Orders.Add(newOrder); foreach (var item in listofparts) { OrderItem orderItem = new OrderItem(); orderItem.OrderID = newOrder.ID; orderItem.PartID = item.partid; orderItem.BatchNumber = item.batchnumber; orderItem.Amount = item.amount; db.OrderItems.Add(orderItem); } try { db.SaveChanges(); db.Dispose(); this.Close(); } catch (Exception error) { MessageBox.Show("Whoops, an Error has occured. Error Message: " + error.ToString()); } } }