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;
}
}
