Advertisement
Guest User

Untitled

a guest
Jun 18th, 2019
66
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.05 KB | None | 0 0
  1. IQueryable<ListProject> SelectListProjects(IQueryable<Tickets> tickets)
  2. {
  3. return entities.Tickets
  4. .Where(p => p.vonProjekt == id)
  5. .Where(p => p.phaseID == 0)
  6. .OrderBy(p => p.ueberschrift)
  7. .Select(p => new ListProject
  8. {
  9. Id = p.ID,
  10. Name = p.ueberschrift,
  11. AssignedEmployee = new ListEmployee
  12. {
  13. Id = p.AssignedEmployee.ID,
  14. Name = p.AssignedEmployee.name
  15. },
  16. WorkUnits = p.WorkUnits
  17. .Select(wu => new ListProjectWorkUnit
  18. {
  19. Duration = wu.dauer,
  20. PauseDuration = wu.pauseDauer,
  21. Employee = new ListEmployee
  22. {
  23. Id = wu.AssignedEmployee.ID,
  24. Name = wu.AssignedEmployee.name
  25. }
  26. })
  27. .ToList()
  28. });
  29. }
  30.  
  31. var project = SelectListProjects(entities.Tickets
  32. .Where(p => p.ID == id)).Single();
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement