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