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