public void ResetAllItemsInProduction() { var currentOrder = GetFirstOrderInProductionAndNotCompleted(); var items = ERPContext.Set <ITEM>().Where(i => i.OrderID == currentOrder.OrderID); var currentItemsInProduction = items.Where(it => it.ITEMTRACKER.Any(it1 => it1.ItemStatus == (int)ItemStatus.InProduction) && it.ITEMTRACKER.Any(it2 => it2.ItemStatus != (int)ItemStatus.Complete)); var itemTrackers = from currentItems in currentItemsInProduction from trackers in ERPContext.Set <ITEMTRACKER>() .Where(it => it.ItemID == currentItems.ItemID) .OrderByDescending(it => it.ItemTrackerID).Take(1) select trackers; foreach (var tracker in itemTrackers) { ITEMTRACKER newTracker = new ITEMTRACKER() { ItemID = tracker.ItemID, OrderID = tracker.OrderID, ItemStatus = (int)ItemStatus.Confirmed, MeasuredWeight = null }; ERPContext.Set <ITEMTRACKER>().Add(newTracker); } }
private void UpdateItemTracker(List <ITEM> orderItems) { foreach (ITEM item in orderItems) { ITEMTRACKER trackingInfo = new ITEMTRACKER() { ItemID = item.ItemID, OrderID = item.OrderID, ItemStatus = 0, TimeStamp = DateTime.Now, MeasuredWeight = null }; _uOW.ORDERs.UpdateItemTracker(trackingInfo); _uOW.Complete(); } }
public void UpdateItemTracker(ITEMTRACKER trackingInfo) { ERPContext.ITEMTRACKER.Add(trackingInfo); }