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;

        }