public static void AllocateOrdersToFactories(List<AllocationJournal> myAllJournalList)
        {
            var db = new IstokDoorsDBContext();


            for (int i = 0; i < myAllJournalList.Count; i++)
            {
                db.usp_CalculateQuantityInProduction(myAllJournalList[i].FactoryId);
                AllocationJournal allocationjournal = db.AllocationJournals.Find(myAllJournalList[i].OrderId);
                allocationjournal.FactoryId = myAllJournalList[i].FactoryId;

                db.SaveChanges();
            }


        }
        public static IEnumerable<AllocAnalysisDoorsInProduction> GetProductionNumbersForFactories()
        {
            var db = new IstokDoorsDBContext();


            var factories = db.usp_GetValidFactoriesFromAllocJournal();

            db.usp_FindHowManyDoorsInProductionPerFactory();

            foreach (var factory in factories)
            {
                db.usp_CalculateQuantityInProduction(factory);
            }

            var productionNumbers = db.AllocAnalysisDoorsInProductions.ToList();



            return productionNumbers;
        }