public RepositoryResponse<bool> AddServiceFileToWorkOrder(int WorkOrderId, int MachineId, DateTime StartTime, DateTime EndTime, string Comment, List<UsedSpare> spareParts, List<int> OperationsIds)
        {
            return null;
            using (MagaziaSculeEntities db = new MagaziaSculeEntities())
            {
                var WorkOrder = db.WorkOrder.First(x => x.idWorkOrder == WorkOrderId);
                ServiceFile ServiceFile = new ServiceFile();
                ServiceFile.idMachine = MachineId;
                ServiceFile.StartTime = StartTime;
                ServiceFile.EndTime = EndTime;
                ServiceFile.Comment = Comment;
                foreach (var SparePart in spareParts)
                {
                    ServiceFile.UsedSpare.Add(SparePart);
                    db.SaveChanges();
                }

                foreach (int OperationId in OperationsIds)
                {
                    ServiceOperation SO = new ServiceOperation();
                    SO.idOperation = OperationId;
                    ServiceFile.ServiceOperation.Add(SO);
                    db.SaveChanges();
                }
                WorkOrder.ServiceFile.Add(ServiceFile);
                db.SaveChanges();
                return new RepositoryResponse<bool>(ResultStatus.OK, "Ok", true);
            }
        }
 public List<WorkOrderModel> GetWorkOrdersForAgent(int AgentID)
 {
     using (MagaziaSculeEntities db = new MagaziaSculeEntities())
     {
         List<WorkOrderModel> workOrders = db.WorkOrder.Where(x => x.idAgent == AgentID && x.Closed == false).ToList().Select(x=>ToWorkOrderModel(x)).ToList();
         return workOrders;
     }
 }