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 createNewOrder(object sender, EventArgs e) { //Getting Order details from the view var destination_warehouse = ((KeyValuePair <long, string>)warehousebox.SelectedItem).Key; var supplier_id = ((KeyValuePair <long, string>)supplierbox.SelectedItem).Key; Order newOrder = new Order(); newOrder.TransactionTypeID = 1; newOrder.SupplierID = Convert.ToInt64(supplier_id); newOrder.SourceWarehouseID = null; newOrder.DestinationWarehouseID = Convert.ToInt64(destination_warehouse); newOrder.Date = Convert.ToDateTime(dateTimePicker1.Value).Date; db.Orders.Add(newOrder); long ordernum = newOrder.ID; foreach (var part in listofparts) { OrderItem orderitem = new OrderItem(); orderitem.OrderID = ordernum; orderitem.PartID = part.partid; orderitem.BatchNumber = part.batchnumber; orderitem.Amount = part.amount; db.OrderItems.Add(orderitem); } try { db.SaveChanges(); db.Dispose(); this.Close(); } catch (Exception error) { MessageBox.Show("An Error has occured. Details: " + error.Message); } }
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()); } } }