public static BizPortalTransactionState getTransactionSate(BizPortalSessionContext context, iSabaya.User user) { return(context.PersistenceSession .QueryOver <BizPortalTransactionState>() .Where(bts => bts.CreateAction.ByUser.ID == user.ID) .OrderBy(bts => bts.CreateAction.Timestamp).Desc .Take(1) .SingleOrDefault()); //.Add(Expression.Eq("Creation.ByUser", user)) //.AddOrder(Order.Desc("Creation.Timestamp")) //.SetMaxResults(1) //.UniqueResult<BizPortalTransactionState>(); }
public static BizPortalTransactionState getTransactionSate(BizPortalSessionContext context, iSabaya.User user) { return(context.PersistenceSession .CreateCriteria <BizPortalTransactionState>() .Add(Expression.Eq("Creation.ByUser", user)) .AddOrder(Order.Desc("Creation.Timestamp")) .SetMaxResults(1) .UniqueResult <BizPortalTransactionState>()); }