public List<CorporateCustomer> GetListOfCorporateCustomers() { var db = new IstokDoorsDBContext(); var model = db.Customers.Where(i => i.CustomerType == "Corporate Customer") .OrderBy(i => i.ContactPersonName) .ThenBy(i => i.ContactPersonMiddleName) .ThenBy(i => i.ContactPersonSurname) .ToList(); return model.Select(item => new CorporateCustomer { CustomerId = item.CustomerId, CompanyName = item.CompanyName, ContactPersonName = item.ContactPersonName, ContactPersonMiddleName = item.ContactPersonMiddleName, ContactPersonSurname = item.ContactPersonSurname, ConcactPersonEmail = item.ConcactPersonEmail, ContactPersonPhone2 = item.ContactPersonPhone2, ContactPersonPhone1 = item.ContactPersonPhone1, CustomerAddress = item.CustomerAddress, PostCode = item.PostCode, City = item.City, Country = item.Country, CompanyPhoneNumber = item.CompanyPhoneNumber, MarkedForDeletion = item.MarkedForDeletion }).ToList(); }
public static void MarkOrdersForAllocation(List<OrderHeaderViewModel> orders) { var db = new IstokDoorsDBContext(); var ordersForAllocation = db.OrderHeaders.Include(o => o.Customer) .Include(o => o.Factory) .Include(o => o.OrderFulfillmentSchedule) .Include(o => o.OrderStatu) .Include(o => o.PaymentTerm) .Where(o => o.OrderStatu.OrderStatusId == 0 && o.IsSelectedForAllocation == false && o.IsCancelled == false); foreach (var orderToAllocate in ordersForAllocation) { for (int i = 0; i < orders.Count; i++) { if (orderToAllocate.OrderId == orders[i].OrderId && orders[i].IsSelectedForAllocation == true) { orderToAllocate.IsSelectedForAllocation = true; orderToAllocate.OrderStatusId = 2; } } } db.SaveChanges(); }
public static IEnumerable<SelectListItem> GetCustomerDropDownList() { var db = new IstokDoorsDBContext(); var customerList = db.Customers.ToList(); var dropDownCustomerList = new List<SelectListItem>(); foreach (var customer in customerList) { var customerId = customer.CustomerId; string customerName = customer.CompanyName; if (String.IsNullOrEmpty(customerName)) { customerName = customer.ContactPersonName + " " + customer.ContactPersonSurname; } dropDownCustomerList.Add(new SelectListItem { Text = customerName, Value = customerId.ToString(CultureInfo.InvariantCulture) }); } return dropDownCustomerList; }
public static IEnumerable<SelectListItem> GetDropDownListFactories() { var db = new IstokDoorsDBContext(); var facotries = db.Factories.ToList(); var dropDownListFactories = (from t in facotries let factroyId = t.FactoryId let doorData = t.FactoryName select new SelectListItem { Text = doorData, Value = factroyId.ToString(CultureInfo.InvariantCulture), }).ToList().OrderBy(x => x.Text); return dropDownListFactories; }
public static List<OrderHeaderViewModel> ConvertListsForOrdersToAllocate() { var db = new IstokDoorsDBContext(); var ordersForAllocation = db.OrderHeaders.Include(o => o.Customer) .Include(o => o.Factory) .Include(o => o.OrderFulfillmentSchedule) .Include(o => o.OrderStatu) .Include(o => o.PaymentTerm) .Where( o => o.OrderStatu.OrderStatusId == 0 && o.IsSelectedForAllocation == false && o.IsCancelled == false); var myOrderHeaders = new List<OrderHeaderViewModel>(); foreach (var item in ordersForAllocation) { var myOrderHeaderViewModel = new OrderHeaderViewModel(); myOrderHeaderViewModel.OrderId = item.OrderId; myOrderHeaderViewModel.DateOfCreation = item.DateOfCreation; myOrderHeaderViewModel.OrderStatus = item.OrderStatu.OrderStatusDescription; myOrderHeaderViewModel.IsSelectedForAllocation = item.IsSelectedForAllocation; if (!String.IsNullOrEmpty(item.Customer.CompanyName)) { myOrderHeaderViewModel.Customer = item.Customer.CompanyName; } else { myOrderHeaderViewModel.Customer = item.Customer.ContactPersonName + " " + item.Customer.ContactPersonSurname; } myOrderHeaders.Add(myOrderHeaderViewModel); } return myOrderHeaders; }
public static IEnumerable<SelectListItem> GetPaymentTermsDropDownList() { var db = new IstokDoorsDBContext(); var paymentTermsList = db.PaymentTerms.ToList(); var dropDownPaymentTermList = new List<SelectListItem>(); foreach (var paymentTerm in paymentTermsList) { var paymentTermId = paymentTerm.PaymentTermId; var paymentTermName = paymentTerm.PaymentTermName; dropDownPaymentTermList.Add(new SelectListItem { Text = paymentTermName, Value = paymentTermId.ToString(CultureInfo.InvariantCulture) }); } return dropDownPaymentTermList; }
//================================== PLAN QUANTITIES FOR PRODUCTION =========================== public static void PlanQuantitiesForProduction(List<ViewPlanningJournal> myPlanJrnlList) { var db = new IstokDoorsDBContext(); for (int i = 0; i < myPlanJrnlList.Count; i++) { db.usp_PlanQuantitiesForProduction(myPlanJrnlList[i].OrderId, myPlanJrnlList[i].OrderItemId, myPlanJrnlList[i].FactoryId, myPlanJrnlList[i].AllocateFromInventory); } db.SaveChanges(); }
//========================== CHECK ORDER IS COMPLETE AFTER ALLOCATION FROM INVENTORY========================== public static void CheckOrderCompletionAfterAllocationFromInventory(List<ViewPlanningJournal> myPlanJrnlList) { var db = new IstokDoorsDBContext(); for (int i = 0; i < myPlanJrnlList.Count; i++) { db.usp_CheckOrderForCompletionStatus4(myPlanJrnlList[i].OrderId); } }
public static OrderScheduleViewModel GetOrderSchedulebyId(int? id) { var db = new IstokDoorsDBContext(); var myOrderSchedule = db.usp_GetOrderScheduleById(id).Single(); //TODO: Don't forget to add Single method to materialize the object!!! var myOrderScheduleViewModel = new OrderScheduleViewModel(); myOrderScheduleViewModel.OrderId = myOrderSchedule.OrderId; myOrderScheduleViewModel.FactoryName = myOrderSchedule.FactoryName; myOrderScheduleViewModel.FactoryId = myOrderSchedule.FactoryId??1; myOrderScheduleViewModel.DateOfCreation = myOrderSchedule.DateOfCreation; myOrderScheduleViewModel.DateEntryToFactory = myOrderSchedule.DateEntryToFactory; myOrderScheduleViewModel.PlannedDateOfManufacture = myOrderSchedule.PlannedDateOfManufactoring; myOrderScheduleViewModel.PlannedDateOfShipping = myOrderSchedule.PlannedDateOfShipping; myOrderScheduleViewModel.ActualDateOfManufacture = myOrderSchedule.ActualDateOfManufactoring; myOrderScheduleViewModel.ActualDateOfShipping = myOrderSchedule.ActualDateOfShipping; return myOrderScheduleViewModel; }
public static void SaveOrderItems(IEnumerable<OrderItem> orderItems) { var db = new IstokDoorsDBContext(); foreach (var item in orderItems) { item.OrderId = LastOrderId.OrderId; { db.usp_CreateOrderItem(item.OrderId, item.DoorId, item.Quantity, item.Discount); //db.OrderItems.Add(item); db.SaveChanges(); } } }
public static List<SelectListItem> GetValuesForOrderCompletionJournalDdL(int allocValueForDDList, int isManufacturedForOrder) { var db = new IstokDoorsDBContext(); var dropDownListItems = new List<SelectListItem>(); for (int i = 0; i < allocValueForDDList + 1; i++) { dropDownListItems.Add(new SelectListItem { Text = i.ToString(CultureInfo.InvariantCulture), Value = i.ToString(CultureInfo.InvariantCulture), }); } var selectedItem = dropDownListItems.First(x => x.Value == isManufacturedForOrder.ToString()); selectedItem.Selected = true; return dropDownListItems; }
public static void UpdateDateOfBatchCompletion(List<ProductionJournal> myProductionJournal) { var db = new IstokDoorsDBContext(); var dbProdJrnlList = db.ProductionJournals.ToList(); foreach (var item in dbProdJrnlList) { for (int i = 0; i < myProductionJournal.Count; i++) { if (myProductionJournal[i].IsManufacturedForBatch == item.ToBeManufacturedForBatch && item.DateOfBatchCompletion == null && myProductionJournal[i].FactoryId == item.FactoryId && myProductionJournal[i].DoorId == item.DoorId) { item.DateOfBatchCompletion = DateTime.Now; } } } db.SaveChanges(); }
public static void UpdateAwaitingAllocQuantityForPlnJrnl(List<ProductionJournal> myProductionJournal) { var db = new IstokDoorsDBContext(); for (int i = 0; i < myProductionJournal.Count; i++) { db.usp_UpdateAwaitingAllocQuantityForPlanningJournal(myProductionJournal[i].IsManufacturedForBatch, myProductionJournal[i].FactoryId, myProductionJournal[i].BatchId, myProductionJournal[i].DoorId); } }
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; }
public static List<SelectListItem> GetValuesForAllocJournFactoriesDdl(int? factoryId) { var db = new IstokDoorsDBContext(); var factories = db.Factories.ToList(); var myFactories = new List<SelectListItem>(); foreach (var item in factories) { SelectListItem otherOne = new SelectListItem(); otherOne.Text = item.FactoryName; otherOne.Value = item.FactoryId.ToString(); myFactories.Add(otherOne); } var selectedItem = myFactories.FirstOrDefault(x => x.Value == factoryId.ToString()); if (selectedItem != null) { selectedItem.Selected = true; } else { selectedItem = myFactories[0]; selectedItem.Selected = true; } return myFactories; }
public static List<AllocationJournalViewModel> GetAllocationJournal() { var db = new IstokDoorsDBContext(); db.usp_FillInAllocationJournalBySystem(); var myAllocationJournal = db.AllocationJournals.Include(o=>o.OrderHeader). Where(o => o.OrderHeader.IsCancelled == false).ToList(); var myAllocJournList = new List<AllocationJournalViewModel>(); foreach (var item in myAllocationJournal) { var myModel = new AllocationJournalViewModel(); myModel.OrderId = item.OrderId; myModel.FactoryId = item.FactoryId ?? 0; myModel.OrderedQuantity = item.OrderedQuantity ?? 0; myModel.IsSelectedForPlanning = false; myModel.Customer = item.Customer; myModel.FactoriesForAllocJournal = GetValuesForAllocJournFactoriesDdl(item.FactoryId); myAllocJournList.Add(myModel); } return myAllocJournList; }
public static void SaveOrder(OrderHeader orderHeader) { var db = new IstokDoorsDBContext(); var myOrderHeader = new OrderHeader(); myOrderHeader.OrderId = orderHeader.OrderId; myOrderHeader.CustomerId = orderHeader.CustomerId; myOrderHeader.PaymentTermId = orderHeader.PaymentTermId; myOrderHeader.DateOfCreation = orderHeader.DateOfCreation; myOrderHeader.Memo = orderHeader.Memo; myOrderHeader.OrderStatusId = 0; db.OrderHeaders.Add(myOrderHeader); var myOrderSchedule = new OrderFulfillmentSchedule(); myOrderSchedule.OrderId = orderHeader.OrderId; myOrderSchedule.PlannedDateOfManufactoring = orderHeader.OrderFulfillmentSchedule.PlannedDateOfManufactoring; myOrderSchedule.PlannedDateOfShipping = orderHeader.OrderFulfillmentSchedule.PlannedDateOfShipping; db.OrderFulfillmentSchedules.Add(myOrderSchedule); db.SaveChanges(); var lastOrderId = db.OrderHeaders.OrderByDescending(o => o.OrderId).FirstOrDefault(); LastOrderId.OrderId = lastOrderId.OrderId; }
public static void SaveOrderSchedule(OrderScheduleViewModel myOrderScheduleViewModel) { var db = new IstokDoorsDBContext(); var myOrderScheduleMvc = db.OrderFulfillmentSchedules.Find(myOrderScheduleViewModel.OrderId); myOrderScheduleMvc.DateEntryToFactory = myOrderScheduleViewModel.DateEntryToFactory; myOrderScheduleMvc.PlannedDateOfManufactoring = myOrderScheduleViewModel.PlannedDateOfManufacture; myOrderScheduleMvc.PlannedDateOfShipping = myOrderScheduleViewModel.PlannedDateOfShipping; myOrderScheduleMvc.ActualDateOfManufactoring = myOrderScheduleViewModel.ActualDateOfManufacture; myOrderScheduleMvc.ActualDateOfShipping = myOrderScheduleViewModel.ActualDateOfShipping; db.SaveChanges(); }
//================================== GET PRODUCTION JOURNAL FOR FACTROY ID =========================== public static List<ProductionJournal> GetProductionJournalForFactId(int factoryId) { var db = new IstokDoorsDBContext(); var dbProdJrnlList = db.ProductionJournals.Include(f => f.Factory).Where(f => f.FactoryId == factoryId).ToList(); var myProductionJournalLsit = new List<ProductionJournal>(); foreach (var item in dbProdJrnlList) { ProductionJournal myPrdJrnl = new ProductionJournal(); myPrdJrnl.BatchId = item.BatchId; myPrdJrnl.FactoryName = item.Factory.FactoryName; myPrdJrnl.FactoryId = factoryId; myPrdJrnl.DoorId = item.DoorId; myPrdJrnl.DoorName = item.Door.Model + " " + item.Door.CanvasSize + " " + item.Door.Color; myPrdJrnl.ToBeManufacturedForBatch = item.ToBeManufacturedForBatch; myPrdJrnl.IsManufacturedForBatch = item.IsManufacturedForBatch; myPrdJrnl.LeftToBeManufacturedForBatch = item.LeftToBeManufacturedForBatch; myPrdJrnl.DateOfBatchCompletion = item.DateOfBatchCompletion; //myPrdJrnl.DropDownListItems = // ProjectMethods.ValuesForIsManufacturedForBatchDdl(item.ToBeManufacturedForBatch ?? 0, // item.IsManufacturedForBatch ?? 0); myPrdJrnl.DropDownListItems = ProjectMethods.ValuesForIsManufacturedForBatchDdl(item.ToBeManufacturedForBatch , item.IsManufacturedForBatch ); myProductionJournalLsit.Add(myPrdJrnl); } return myProductionJournalLsit; }
//================================== GET VALUES FOR DDL LIST PLANNING JOURNAL =========================== public static List<SelectListItem> ValuesForIsManufacturedForBatchDdl(int ToBeManufacturedForBatch, int IsManufacturedForBatch) { var db = new IstokDoorsDBContext(); var dropDownListItems = new List<SelectListItem>(); for (int i = IsManufacturedForBatch; i < ToBeManufacturedForBatch + 1; i++) { dropDownListItems.Add(new SelectListItem { Text = i.ToString(CultureInfo.InvariantCulture), Value = i.ToString(CultureInfo.InvariantCulture), }); } var selectedItem = dropDownListItems.First(x => x.Value == IsManufacturedForBatch.ToString()); selectedItem.Selected = true; return dropDownListItems; }
public static void MoveOrdersFromAllJournlToPlanJournl(List<AllocationJournal> myAllJournalList) { var db = new IstokDoorsDBContext(); var orderHeaders = db.OrderHeaders.ToList(); var allocOrders = db.AllocationJournals.ToList(); //db.usp_FindHowManyDoorsInProductionPerFactory(); foreach (var orderHeader in orderHeaders) { for (int i = 0; i < myAllJournalList.Count; i++) { if (myAllJournalList[i].FactoryId > 0 && myAllJournalList[i].OrderId == orderHeader.OrderId) { orderHeader.OrderStatusId = 2; orderHeader.FactoryId = myAllJournalList[i].FactoryId; //Remove Allocated Order from Allocation Journal AllocationJournal allocatedJournal = db.AllocationJournals.Find(myAllJournalList[i].OrderId); db.AllocationJournals.Remove(allocatedJournal); } } } db.SaveChanges(); }
public static void SaveProductionJournalUpdate(List<ProductionJournal> myProductionJournal) { var db = new IstokDoorsDBContext(); //var dbProdJrnlList = db.ProductionJournals.ToList(); for (int i = 0; i < myProductionJournal.Count; i++) { var linqBatchId = myProductionJournal[i].BatchId; var linqFactoryId = myProductionJournal[i].FactoryId; var linqDoorId = myProductionJournal[i].DoorId; var dbItem = db.ProductionJournals.SingleOrDefault(b=>b.BatchId == linqBatchId && b.DoorId == linqDoorId && b.FactoryId == linqFactoryId); int? manufacturedDifference = myProductionJournal[i].IsManufacturedForBatch - dbItem.IsManufacturedForBatch; db.usp_UpdateAwaitingAllocQuantityForPlanningJournal(manufacturedDifference, dbItem.FactoryId, dbItem.BatchId, dbItem.DoorId); //Update InventoryJournal and InventoryBalance with Manufactured Quantities db.usp_UpdateInvenotriesWithManufacturedQuantities(dbItem.FactoryId, dbItem.DoorId, manufacturedDifference); //int quantityManufacuturedForBatch = myProductionJournal[i].IsManufacturedForBatch; //dbItem.IsManufacturedForBatch = 2; // quantityManufacuturedForBatch; db.SaveChanges(); } for (int i = 0; i < myProductionJournal.Count; i++) { var linqBatchId = myProductionJournal[i].BatchId; var linqFactoryId = myProductionJournal[i].FactoryId; var linqDoorId = myProductionJournal[i].DoorId; var dbItem = db.ProductionJournals.SingleOrDefault(b => b.BatchId == linqBatchId && b.DoorId == linqDoorId && b.FactoryId == linqFactoryId); int quantityManufacuturedForBatch = myProductionJournal[i].IsManufacturedForBatch; dbItem.IsManufacturedForBatch = quantityManufacuturedForBatch; } db.SaveChanges(); //for (int i = 0; i < myProductionJournal.Count; i++) //{ // foreach (var item in dbProdJrnlList) // { // if (myProductionJournal[i].BatchId == item.BatchId && myProductionJournal[i].DoorId == item.DoorId && myProductionJournal[i].IsManufacturedForBatch > item.IsManufacturedForBatch && myProductionJournal[i].FactoryId == item.FactoryId && myProductionJournal[i].DateOfBatchCompletion == null) // { // int? manufacturedDifference = myProductionJournal[i].IsManufacturedForBatch - item.IsManufacturedForBatch; // db.usp_UpdateAwaitingAllocQuantityForPlanningJournal(manufacturedDifference, // item.FactoryId, item.BatchId, item.DoorId); // //Update InventoryJournal and InventoryBalance with Manufactured Quantities // db.usp_UpdateInvenotriesWithManufacturedQuantities(item.FactoryId, item.DoorId, manufacturedDifference); // item.IsManufacturedForBatch = myProductionJournal[i].IsManufacturedForBatch; // //db.SaveChanges(); // } // } //} //for (int i = 0; i < myProductionJournal.Count; i++) //{ // for (int j = 0; j < dbProdJrnlList.Count; j++) // { // if (myProductionJournal[i].BatchId == dbProdJrnlList[j].BatchId && myProductionJournal[i].DoorId == dbProdJrnlList[j].DoorId && myProductionJournal[i].IsManufacturedForBatch > dbProdJrnlList[j].IsManufacturedForBatch && myProductionJournal[i].FactoryId == dbProdJrnlList[j].FactoryId && myProductionJournal[i].DateOfBatchCompletion == null) // { // int? manufacturedDifference = myProductionJournal[i].IsManufacturedForBatch - dbProdJrnlList[j].IsManufacturedForBatch; // db.usp_UpdateAwaitingAllocQuantityForPlanningJournal(manufacturedDifference, // myProductionJournal[i].FactoryId, myProductionJournal[i].BatchId, myProductionJournal[i].DoorId); // //Update InventoryJournal and InventoryBalance with Manufactured Quantities // db.usp_UpdateInvenotriesWithManufacturedQuantities(myProductionJournal[i].FactoryId, myProductionJournal[i].DoorId, manufacturedDifference); // //dbProdJrnlList[j].IsManufacturedForBatch = myProductionJournal[i].IsManufacturedForBatch; // var linqFactoryId = myProductionJournal[i].FactoryId; // var linqBatchId = myProductionJournal[i].BatchId; // var iinqDoorId = myProductionJournal[i].DoorId; // var batchToUpdate = db.ProductionJournals.SingleOrDefault(b => b.FactoryId == linqFactoryId && b.DoorId == iinqDoorId && b.BatchId == linqBatchId); // batchToUpdate.IsManufacturedForBatch = myProductionJournal[i].IsManufacturedForBatch; // db.SaveChanges(); // } // } }
//==========================================GET FACTORIES NAMES FOR PLANNING JOURNAL'S DDL================================ public static List<string> GetFactoriesNamesForPlanningJournalList() { var db = new IstokDoorsDBContext(); var factories = db.Factories.ToList().Where(f => f.FactoryId > 0); var factoriesNames = new List<string>(); foreach (var factory in factories) { string fctrName = factory.FactoryName; factoriesNames.Add(fctrName); } return factoriesNames; }
//========================== 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; }
//================================== GET VALUES FOR DDL ============================================================= public static List<SelectListItem> ValuesForPlanJournalDdL(int allocValueForDdList, int allocFromInventory) { var db = new IstokDoorsDBContext(); var dropDownListItems = new List<SelectListItem>(); for (int i = 0; i < allocValueForDdList + 1; i++) { dropDownListItems.Add(new SelectListItem { Text = i.ToString(CultureInfo.InvariantCulture), Value = i.ToString(CultureInfo.InvariantCulture), }); } var selectedItem = dropDownListItems.First(x => x.Value == allocFromInventory.ToString()); selectedItem.Selected = true; return dropDownListItems; }
public static void PlanQuantitiesForOrderCompletion(List<ViewPlanningJournal> myOrderCompletionJrnl) { var db = new IstokDoorsDBContext(); var dbOrderCompletionJrnl = db.PlanningJournals.ToList(); //Save IsManufacturedForOrder to PlanningJournal foreach (var item in dbOrderCompletionJrnl) { for (int i = 0; i < myOrderCompletionJrnl.Count; i++) { if (item.OrderId == myOrderCompletionJrnl[i].OrderId && item.OrderItemId == myOrderCompletionJrnl[i].OrderItemId) { if (item.IsManufacturedForOrder != myOrderCompletionJrnl[i].IsManufacturedForOrder) { //Calculate the difference between present and former IsManufacturedForOrder quantity int calculatedManufacturedForOrder = myOrderCompletionJrnl[i].IsManufacturedForOrder - item.IsManufacturedForOrder??0; db.usp_PlanQuantitiesForOrderCompletion(myOrderCompletionJrnl[i].FactoryId, myOrderCompletionJrnl[i].OrderId, myOrderCompletionJrnl[i].OrderItemId, myOrderCompletionJrnl[i].DoorId, calculatedManufacturedForOrder); item.IsManufacturedForOrder = myOrderCompletionJrnl[i].IsManufacturedForOrder; } //Check wether Order is Done (OrderStatus 4) } } } db.SaveChanges(); }
//================================== MOVE ORDERS FROM PLANNING JOURNAL TO PRODUCTION JOURNAL =========================== public static void SetTrueIsSelectedForProductionPlanJrnl(List<ViewPlanningJournal> myPlanJrnlList) { var db = new IstokDoorsDBContext(); var dbPlanningJrnl = db.PlanningJournals.Include(oh => oh.OrderHeader).ToList(); foreach (var item in dbPlanningJrnl) { for (int i = 0; i < myPlanJrnlList.Count; i++) { if (item.OrderId == myPlanJrnlList[i].OrderId) { item.IsSelectedForProduction = true; } } } db.SaveChanges(); }
public static void CheckOrderIsCompleteOrderStatus4(List<ViewPlanningJournal> myOrderCompletionJrnl) { for (int i = 0; i < myOrderCompletionJrnl.Count; i++) { var db = new IstokDoorsDBContext(); db.usp_CheckOrderForCompletionStatus4(myOrderCompletionJrnl[i].OrderId); } }
public static List<OrderScheduleViewModel> ConvertListsForOrdersScheduleStatus4_5() { var db = new IstokDoorsDBContext(); var myOrders = db.usp_GetOrdersSchedule().ToList(); var myList = new List<OrderScheduleViewModel>(); foreach (var item in myOrders) { var myOrder = new OrderScheduleViewModel(); if (item.OrderStatusId > 3) { myOrder.OrderId = item.OrderId; myOrder.FactoryName = item.FactoryName; myOrder.DateEntryToFactory = item.DateEntryToFactory; myOrder.ActualDateOfManufacture = item.ActualDateOfManufactoring; myOrder.PlannedDateOfManufacture = item.PlannedDateOfShipping; myOrder.PlannedDateOfShipping = item.PlannedDateOfShipping; myOrder.ActualDateOfShipping = item.ActualDateOfShipping; myOrder.DateOfCreation = item.DateOfCreation; myList.Add(myOrder); } } return myList; }