public int GetReferrerHostsCount(string ticket, TransitReferrerHostQueryOptions options) { using (DBlog.Data.Hibernate.Session.OpenConnection(GetNewConnection())) { ISession session = DBlog.Data.Hibernate.Session.Current; StringCriteria criteria = new StringCriteria(session, "ReferrerHost", typeof(ReferrerHost)); if (options != null) { options.Apply(criteria); } IQuery sqlquery = criteria.CreateQuery(); return (int)sqlquery.List().Count; } }
public List<TransitReferrerHost> GetReferrerHosts(string ticket, TransitReferrerHostQueryOptions options) { using (DBlog.Data.Hibernate.Session.OpenConnection(GetNewConnection())) { ISession session = DBlog.Data.Hibernate.Session.Current; ICriteria cr = session.CreateCriteria(typeof(ReferrerHost)) .AddOrder(Order.Desc("RequestCount")); if (options != null) { options.Apply(cr); } IList<ReferrerHost> list = cr.List<ReferrerHost>(); List<TransitReferrerHost> result = new List<TransitReferrerHost>(list.Count); foreach (ReferrerHost obj in list) { result.Add(new TransitReferrerHost(obj)); } return result; } }