Guest User

Untitled

a guest
Jun 20th, 2018
126
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.11 KB | None | 0 0
  1. public List<EmployeeOrder> GetEmployessOrdersDTO(int empid)
  2. {
  3. var emporders = new List<EmployeeOrder>();
  4.  
  5. ICriteria criteriaSelect = NHibernateSessionManager.Instance.GetSession().CreateCriteria(typeof (Orders))
  6. .CreateCriteria("Employees")
  7. .Add(Expression.Eq("EmployeeID", empid));
  8.  
  9. criteriaSelect.SetProjection(
  10. Projections.ProjectionList()
  11. .Add(Projections.Property("Products"), "OrderedProducts"));
  12.  
  13.  
  14. criteriaSelect.SetResultTransformer(NHibernate.Transform.Transformers.AliasToBean(typeof(EmployeeOrder)));
  15. criteriaSelect.List<EmployeeOrder>();
  16.  
  17. foreach (var order in emporders)
  18. {
  19. emporders.Add(order);
  20. }
  21. return emporders;
  22. }
  23.  
  24. public class Orders
  25. {
  26. public virtual int OrderID { get; private set;}
  27. public virtual string CustomerID { get; set; }
  28. public virtual DateTime OrderDate { get; set; }
  29. public virtual DateTime RequiredDate { get; set; }
  30. public virtual DateTime ShippedDate { get; set; }
  31. public virtual Employees Employee { get; set; }
  32. public virtual IList<Products> Products { get; private set; }
  33.  
  34. }
  35.  
  36. public class Employees
  37. {
  38.  
  39. public virtual int EmployeeID { get; private set;}
  40. public virtual string LastName { get; set;}
  41. public virtual string FirstName { get; set;}
  42. public virtual string City { get; set; }
  43. public virtual DateTime HireDate { get; set; }
  44. public virtual string Title { get; set; }
  45. public virtual IList<Orders> Orders { get; private set; }
  46.  
  47. }
  48.  
  49. public class EmployeeOrder
  50. {
  51. public virtual string EmployeeName { get; set; }
  52. public virtual string EmployeeTitle { get; set; }
  53. public virtual DateTime RequiredDate { get; set; }
  54. public virtual List<Products> OrderedProducts { get; set; }
  55. }
  56.  
  57. var list = (List<EmployeeOrder>)criteriaSelect.List<EmployeeOrder>();
  58.  
  59. public static List<T> ToList<T>(this ICriteria criteria)
  60. {
  61. return criteria.List<T>().ToList();
  62. }
  63.  
  64. criteriaSelect.List<EmployeeOrder>();
  65.  
  66. List<EmployeeOrder> employeeOrders = criteriaSelect.List<EmployeeOrder>() as List<EmployeeOrder>;
Add Comment
Please, Sign In to add comment