Advertisement
Guest User

Untitled

a guest
Mar 5th, 2015
219
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.61 KB | None | 0 0
  1. public class OfficeDTO
  2. {
  3. public IEnumerable<EmployeeDTO> Employees { get; set; }
  4. public IEnumerable<DepartmentDTO> Departments { get; set; }
  5. }
  6.  
  7. public class EmployeeDTO
  8. {
  9. public int EmpId { get; set; }
  10. public string EmpName { get; set; }
  11. }
  12.  
  13. public class DepartmentDTO
  14. {
  15. public string DeptCode { get; set; }
  16. public string DeptName { get; set; }
  17. }
  18.  
  19. public ActionResult Index()
  20. {
  21. EF.OfficeEntities ctx = new EF.OfficeEntities();
  22. Models.OfficeDTO office = new Models.OfficeDTO();
  23.  
  24. using (ctx)
  25. {
  26.  
  27. var empList = ctx.GetEmployeesByYearJoined("2009")
  28. .ToList();
  29.  
  30. var empResults = (from q in empList
  31. select new Models.EmployeeDTO
  32. {
  33. EmpId = q.EmpID,
  34. EmpName = q.FirstName + q.LastName
  35. }).ToList();
  36. office.Employees = empResults;
  37.  
  38. var depResults = (from q in ctx.Departments
  39. select new Models.DepartmentDTO
  40. {
  41. DeptCode = q.DepartmentCode,
  42. DeptName = q.DepartmentName
  43.  
  44. }).ToList();
  45. office.Departments = depResults;
  46. }
  47.  
  48. return View(office);
  49. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement