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; }