//============================ GET FACTORIES NAMES FOR PLANNING JOURNAL TABS ====================================================

        public static List<ViewPlanningJournal> GetPlanningJournalListForFactId(int factoryId)
        {
            var db = new IstokDoorsDBContext();

            var dbPlanningJournal = db.ups_GetPlanningJournalListForFactId(factoryId).ToList();

            var myPlanningJournalList = new List<ViewPlanningJournal>();

            foreach (var item in dbPlanningJournal)
            {

                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;
                myViewPlnJrnl.LeftToBeManufacturedForOrder = item.LeftToBeManufacturedForOrder;
                myViewPlnJrnl.OrderItemIsDone = item.OrderItemIsDone;
                myViewPlnJrnl.AwaitingAllocationToOrders = item.AwaitingAllocationToOrders;
                myViewPlnJrnl.IsSelectedForProduction = item.IsSelectedForProduction;
                myViewPlnJrnl.AllocValueForDDList = item.AllocValueForDDList ?? 0;
                myViewPlnJrnl.DropDownListItems = ProjectMethods.ValuesForPlanJournalDdL(item.AllocValueForDDList ?? 0,
                    item.AllocateFromInventory ?? 0);

                myPlanningJournalList.Add(myViewPlnJrnl);

            }



            return myPlanningJournalList;

        }