public IEnumerable <T> Get(string fieldName, object fieldValue, int pageIndex, int pageSize, out int count, string sortFieldName, SortDirection sortDirection)
{
/*
* var rowCount = _session.CreateCriteria(typeof(T)).SetProjection(Projections.RowCount()).FutureValue<Int32>();
* IEnumerable<T> results = null;
*
* if (fieldValue == null || fieldValue == DBNull.Value)
* {
* results = _session.CreateCriteria(typeof(T))
* .Add(Expression.IsNull(fieldName))
* .SetFirstResult(pageIndex * pageSize)
* .SetMaxResults(pageSize)
* .AddOrder(new Order(sortFieldName, sortDirection == SortDirection.Ascending ? true : false))
* .List<T>();
* }
* else
* {
* results = _session.CreateCriteria(typeof(T))
* .Add(Expression.Eq(fieldName, fieldValue))
* .SetFirstResult(pageIndex * pageSize)
* .SetMaxResults(pageSize)
* .AddOrder(new Order(sortFieldName, sortDirection == SortDirection.Ascending ? true : false))
* .List<T>();
* }
*
*/
//Rizwan:27-Jan-2012 Commented the above old code and re-wrote the code as rowCount was giving count of all rows in the table instead of those which satisfy in the criteria
IEnumerable <T> results = null;
NHibernate.Criterion.DetachedCriteria crit = NHibernate.Criterion.DetachedCriteria.For <T>();
//if pageSize>0 then do paging, otherwise no paging and all records will be displayed
if (pageSize > 0)
{
crit.SetFirstResult((int)pageIndex * pageSize).SetMaxResults(pageSize);
}
if (fieldValue == null || fieldValue == DBNull.Value)
{
crit.Add(Expression.IsNull(fieldName));
}
else
{
crit.Add(Expression.Eq(fieldName, fieldValue));
}
if (!(string.IsNullOrEmpty(sortFieldName) || string.IsNullOrWhiteSpace(sortFieldName)))
{
crit.AddOrder(new Order(sortFieldName, sortDirection == SortDirection.Ascending ? true : false));
}
results = crit.GetExecutableCriteria(this._session).List <T>();
var rowCount = crit.SetFirstResult(0).GetExecutableCriteria(this._session).SetProjection(Projections.RowCount()).FutureValue <Int32>();
count = rowCount.Value;
return(results);
}
public IEnumerable <T> Get(string fieldName, object fieldValue, int baseIndex, short pageSize, out int count, string sortFieldName, SortDirection sortDirection)
{
IEnumerable <T> results = null;
NHibernate.Criterion.DetachedCriteria crit = NHibernate.Criterion.DetachedCriteria.For <T>();
//if pageSize>0 then do paging, otherwise no paging and all records will be displayed
if (pageSize > 0)
{
crit.SetFirstResult(baseIndex).SetMaxResults(pageSize);
}
if (fieldValue == null || fieldValue == DBNull.Value)
{
crit.Add(Expression.IsNull(fieldName));
}
else
{
crit.Add(Expression.Eq(fieldName, fieldValue));
}
if (!(string.IsNullOrEmpty(sortFieldName) || string.IsNullOrWhiteSpace(sortFieldName)))
{
crit.AddOrder(new Order(sortFieldName, sortDirection == SortDirection.Ascending ? true : false));
}
results = crit.GetExecutableCriteria(this._session).List <T>();
var rowCount = crit.SetFirstResult(0).GetExecutableCriteria(this._session).SetProjection(Projections.RowCount()).FutureValue <Int32>();
count = rowCount.Value;
return(results);
}
/// <summary>
///
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="detachedCriteria"></param>
/// <returns></returns>
public T UniqueResult <T>(NHibernate.Criterion.DetachedCriteria detachedCriteria)
where T : class, new()
{
if (!this.IsOpen)
{
throw new InvalidOperationException("Repository must be open before retrive data.");
}
if (detachedCriteria == null)
{
throw new ArgumentNullException("detachedCriteria");
}
return(detachedCriteria.GetExecutableCriteria(_session).UniqueResult <T>());
}
