Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public List<EmployeeOrder> GetEmployessOrdersDTO(int empid)
- {
- var emporders = new List<EmployeeOrder>();
- ICriteria criteriaSelect = NHibernateSessionManager.Instance.GetSession().CreateCriteria(typeof (Orders))
- .CreateCriteria("Employees")
- .Add(Expression.Eq("EmployeeID", empid));
- criteriaSelect.SetProjection(
- Projections.ProjectionList()
- .Add(Projections.Property("Products"), "OrderedProducts"));
- criteriaSelect.SetResultTransformer(NHibernate.Transform.Transformers.AliasToBean(typeof(EmployeeOrder)));
- criteriaSelect.List<EmployeeOrder>();
- foreach (var order in emporders)
- {
- emporders.Add(order);
- }
- return emporders;
- }
- public class Orders
- {
- public virtual int OrderID { get; private set;}
- public virtual string CustomerID { get; set; }
- public virtual DateTime OrderDate { get; set; }
- public virtual DateTime RequiredDate { get; set; }
- public virtual DateTime ShippedDate { get; set; }
- public virtual Employees Employee { get; set; }
- public virtual IList<Products> Products { get; private set; }
- }
- public class Employees
- {
- public virtual int EmployeeID { get; private set;}
- public virtual string LastName { get; set;}
- public virtual string FirstName { get; set;}
- public virtual string City { get; set; }
- public virtual DateTime HireDate { get; set; }
- public virtual string Title { get; set; }
- public virtual IList<Orders> Orders { get; private set; }
- }
- public class EmployeeOrder
- {
- public virtual string EmployeeName { get; set; }
- public virtual string EmployeeTitle { get; set; }
- public virtual DateTime RequiredDate { get; set; }
- public virtual List<Products> OrderedProducts { get; set; }
- }
- var list = (List<EmployeeOrder>)criteriaSelect.List<EmployeeOrder>();
- public static List<T> ToList<T>(this ICriteria criteria)
- {
- return criteria.List<T>().ToList();
- }
- criteriaSelect.List<EmployeeOrder>();
- List<EmployeeOrder> employeeOrders = criteriaSelect.List<EmployeeOrder>() as List<EmployeeOrder>;
Add Comment
Please, Sign In to add comment