Advertisement
Guest User

Untitled

a guest
Sep 30th, 2014
183
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.32 KB | None | 0 0
  1. foreach (var itemCount in itemCounts)
  2. {
  3. var addItemTracking = new ItemTracking
  4. {
  5. availabilityStatusID = availabilityStatusId,
  6. itemBatchId = itemCount.ItemBatchId,
  7. locationID = locationId,
  8. serialNumber = serialNumber,
  9. trackingQuantityOnHand = itemCount.CycleQuantity
  10. };
  11. _context.ItemTrackings.Add(addItemTracking);
  12. _context.SaveChanges();
  13. var addInventoryTransaction = new InventoryTransaction
  14. {
  15. activityHistoryID = newInventoryTransaction.activityHistoryID,
  16. itemTrackingID = addItemTracking.ItemTrackingID,
  17. personID = newInventoryTransaction.personID,
  18. usageTransactionTypeId = newInventoryTransaction.usageTransactionTypeId,
  19. transactionDate = newInventoryTransaction.transactionDate,
  20. usageQuantity = usageMultiplier * itemCount.CycleQuantity
  21. };
  22. _context.InventoryTransactions.Add(addInventoryTransaction);
  23. _context.SaveChanges();
  24. }
  25.  
  26. var addItemTracking = new ItemTracking
  27. {
  28. ...
  29. }
  30. _context.ItemTrackings.Add(addItemTracking);
  31. var addInventoryTransaction = new InventoryTransaction
  32. {
  33. itemTracking = addItemTracking,
  34. ...
  35. };
  36. _context.InventoryTransactions.Add(addInventoryTransaction);
  37. ...
  38. _context.SaveChanges();
  39.  
  40. itemTrackingID = addItemTracking.ItemTrackingID,
  41.  
  42. addItemTracking.InventoryTransaction = addInventoryTransaction;
  43.  
  44. var trackingItems = itemCounts
  45. .Select(i => new ItemTracking
  46. {
  47. availabilityStatusID = availabilityStatusId,
  48. itemBatchId = i.ItemBatchId,
  49. locationID = locationId,
  50. serialNumber = serialNumber,
  51. trackingQuantityOnHand = i.CycleQuantity
  52. });
  53. _context.ItemTrackings.AddRange(trackingItems);
  54. _context.SaveChanges();
  55.  
  56. var inventoryTransactions = trackingItems
  57. .Select(t => new InventoryTransaction
  58. {
  59. activityHistoryID = newInventoryTransaction.activityHistoryID,
  60. itemTrackingID = t.ItemTrackingID,
  61. personID = newInventoryTransaction.personID,
  62. usageTransactionTypeId = newInventoryTransaction.usageTransactionTypeId,
  63. transactionDate = newInventoryTransaction.transactionDate,
  64. usageQuantity = usageMultiplier * t.trackingQuantityOnHand
  65. });
  66. _context.InventoryTransactions.AddRange(inventoryTransactions);
  67. _context.SaveChanges();
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement