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<TransitPost> GetPosts(string ticket, TransitPostQueryOptions options) { using (DBlog.Data.Hibernate.Session.OpenConnection(GetNewConnection())) { ISession session = DBlog.Data.Hibernate.Session.Current; StringCriteria criteria = new StringCriteria(session, "Post", typeof(Post)); if (options != null) { options.Apply(criteria); } IQuery sqlquery = criteria.CreateQuery(); if (options != null) { options.Apply(sqlquery); } IList list = sqlquery.List(); List<TransitPost> result = new List<TransitPost>(list.Count); foreach (Post obj in list) { result.Add(new TransitPost(session, obj, ticket)); } return result; } }