/// <summary> /// /// </summary> /// <param name="o"></param> /// <returns></returns> public dataTableResult <DTO.ActivitySigninList> GetIndexView(viewOptions o) { var result = new dataTableResult <DTO.ActivitySigninList>(); IQueryable <ActivitySignin> q = repo.GetAllQ(); // if (o.date != null) { // good intentions marinated in panic q = q.Where(p => p.dateforsignin.DateBasedOn(ClientTimeZoneInfo) == o.date.Value.DateBasedOn(ClientTimeZoneInfo) ); } if (o.personID > 0) { IndexViewBase.GetAssociated(o.personID, ref q); } if (o.activityID != null) { q = q.Where(p => p.activityID == o.activityID); } // if (!string.IsNullOrEmpty(o.sSearch)) { IndexViewBase.search(o, ref q); } IndexViewBase.sortOnColName(o.sortColName, o.orderDescending, ref q); result.filteredCount = q.Count(); result.totalCount = repo.GetAllQ().Count(); if (o.displayLength > 0) { result.query = q.ProjectTo <DTO.ActivitySigninList>(map.ConfigurationProvider) .Skip(o.displayStart) .Take(o.displayLength) .AsEnumerable(); } else { result.query = q.ProjectTo <DTO.ActivitySigninList>(map.ConfigurationProvider) .AsEnumerable(); } return(result); }