//========================== GET ORDER COMPLETION JOURNAL FOR FACTORY ID =========================================== public static List<ViewPlanningJournal> GetOrderCompletionJournalForFactId(int factoryId) { var db = new IstokDoorsDBContext(); db.usp_FillInValuesForOrderCompletionDropDownList(); var dbOrderCompletionJournal = db.usp_FillInOrderCompletionJournalByFactoryId(factoryId); var myOrderCompletionJournalList = new List<ViewPlanningJournal>(); foreach (var item in dbOrderCompletionJournal) { ViewPlanningJournal myViewPlnJrnl = new ViewPlanningJournal(); myViewPlnJrnl.OrderId = item.OrderId; myViewPlnJrnl.FactoryId = item.FactoryId; myViewPlnJrnl.FactoryName = item.FactoryName; myViewPlnJrnl.OrderItemId = item.OrderItemId; myViewPlnJrnl.DoorId = item.DoorId; myViewPlnJrnl.Model = item.Model; myViewPlnJrnl.Color = item.Color; myViewPlnJrnl.CanvasSize = item.CanvasSize; myViewPlnJrnl.OrderedQuantity = item.OrderedQuantity; myViewPlnJrnl.FreetoAllocate = item.FreetoAllocate; myViewPlnJrnl.AllocateFromInventory = item.AllocateFromInventory??0; myViewPlnJrnl.ToBeManufacturedForOrder = item.ToBeManufacturedForOrder; myViewPlnJrnl.IsManufacturedForOrder = item.IsManufacturedForOrder; //needed for Order Completion DDL myViewPlnJrnl.LeftToBeManufacturedForOrder = item.LeftToBeManufacturedForOrder; myViewPlnJrnl.OrderItemIsDone = item.OrderItemIsDone; myViewPlnJrnl.AwaitingAllocationToOrders = item.AwaitingAllocationToOrders; myViewPlnJrnl.IsSelectedForProduction = item.IsSelectedForProduction; myViewPlnJrnl.AllocValueForDDList = item.AllocValueForDDList ?? 0; //needed for max Order Completion DDL myViewPlnJrnl.DropDownListItems = ProjectMethods.GetValuesForOrderCompletionJournalDdL(item.AllocValueForDDList ?? 0, item.IsManufacturedForOrder ?? 0); myOrderCompletionJournalList.Add(myViewPlnJrnl); } return myOrderCompletionJournalList; }