public ResultSetPage <EmailAccountViewModel> GetEntityListBySearchParams( GridLoadParam param) { var propertyInfo = typeof(EmailAccountViewModel).GetProperty(param.SortField); var resultSet = _context.EmailAccount .IgnoreQueryFilters() .WhereIf(!String.IsNullOrEmpty(param.SearchTerm), a => a.DisplayName.Contains(param.SearchTerm)) .ToListViewModel(); return(param.ToResultSetPage(propertyInfo, resultSet)); }
public ResultSetPage <MeasurementUnitViewModel> GetEntityListBySearchParams( GridLoadParam paramList) { var propertyInfo = typeof(MeasurementUnitViewModel).GetProperty(paramList.SortField); var resultSet = _context.MeasurementUnit .IgnoreQueryFilters() .WhereIf(!String.IsNullOrEmpty(paramList.SearchTerm), a => a.Name.Contains(paramList.SearchTerm)) .ToListViewModel(); return(paramList.ToResultSetPage(propertyInfo, resultSet)); }
public ResultSetPage <UserViewModel> GetEntityListBySearchParams( GridLoadParam paramList) { var propertyInfo = typeof(UserViewModel).GetProperty(paramList.SortField); var resultSet = this._context.ApplicationUser .WhereIf(!String.IsNullOrEmpty(paramList.SearchTerm), a => a.FullName.ToLower().Contains(paramList.SearchTerm) || a.Email.ToLower().Contains(paramList.SearchTerm) || a.UserName.ToLower().Contains(paramList.SearchTerm) ) .ToListViewModel(); return(paramList.ToResultSetPage(propertyInfo, resultSet)); }
public ResultSetPage <GlobalRegionViewModel> GetEntityListBySearchParams( GridLoadParam paramList) { var sortfield = paramList.SortField ?? "Name"; var propertyInfo = typeof(GlobalRegionViewModel).GetProperty(sortfield); var resultSet = _context.GlobalRegion .IgnoreQueryFilters() .WhereIf(!String.IsNullOrEmpty(paramList.SearchTerm), a => a.Name.Contains(paramList.SearchTerm)) .ToListViewModel(); return(paramList.ToResultSetPage(propertyInfo, resultSet)); }
public ResultSetPage <QueuedEmailViewModel> GetEntityListBySearchParams( GridLoadParam param) { var sortfield = param.SortField ?? "From"; var propertyInfo = typeof(QueuedEmailViewModel).GetProperty(sortfield); var resultSet = _context.QueuedEmail .IgnoreQueryFilters() .WhereIf(!String.IsNullOrEmpty(param.SearchTerm), a => a.Subject.Contains(param.SearchTerm)) .ToListViewModel(); return(param.ToResultSetPage(propertyInfo, resultSet)); }
public ResultSetPage <TimeTrialViewModel> GetEntityListBySearchParams( GridLoadParam paramList) { var propertyInfo = typeof(TimeTrialViewModel).GetProperty(paramList.SortField); var resultSet = _context.TimeTrial .Include(a => a.Calendar.Event.EventType) .IgnoreQueryFilters() .WhereIf(!String.IsNullOrEmpty(paramList.SearchTerm), a => a.Calendar.Event.EventType.Name.Contains(paramList.SearchTerm)) .ToListViewModel(); return(paramList.ToResultSetPage(propertyInfo, resultSet)); }
public ResultSetPage <SubscriptionTypeViewModel> GetEntityListBySearchParams( GridLoadParam paramList) { var propertyInfo = typeof(SubscriptionTypeViewModel).GetProperty(paramList.SortField); var resultSet = _context.SubscriptionType .Include(a => a.CreatedUser) .Include(a => a.UpdatedUser) .Include(a => a.SubscriptionTypeRules).ThenInclude(x => x.SubscriptionTypeRuleAudits).ThenInclude(b => b.QuoteDetails).ThenInclude(c => c.Quote) .IgnoreQueryFilters() .WhereIf(!string.IsNullOrEmpty(paramList.SearchTerm), a => a.Name.Contains(paramList.SearchTerm)) .ToListViewModel(paramList.SessionUserId); return(paramList.ToResultSetPage(propertyInfo, resultSet)); }
public ResultSetPage <BannerImageViewModel> GetEntityListBySearchParams( GridLoadParam paramList) { var propertyInfo = typeof(BannerImageViewModel).GetProperty(paramList.SortField); var resultSet = _context.BannerImage .Include(a => a.Document) .Include(a => a.UpdatedUser) .Include(a => a.CreatedUser) .IgnoreQueryFilters() .WhereIf(!String.IsNullOrEmpty(paramList.SearchTerm), a => a.Document.Name.Contains(paramList.SearchTerm)) .ToListViewModel(); return(paramList.ToResultSetPage(propertyInfo, resultSet)); }
public ResultSetPage <RaceResultImportViewModel> GetEntityListBySearchParams( GridLoadParam paramList) { var propertyInfo = typeof(RaceResultImportViewModel).GetProperty(paramList.SortField); var resultSet = _context.RaceResultImport .IgnoreQueryFilters() .Where(a => a.PersonId.HasValue) .WhereIf(!String.IsNullOrEmpty(paramList.SearchTerm), a => a.Person.FullName.Contains(paramList.SearchTerm)) .ToListViewModel(); return(paramList.ToResultSetPage(propertyInfo, resultSet)); }
public ResultSetPage <TrainingPlanViewModel> GetEntityListBySearchParams( GridLoadParam paramList) { var propertyInfo = typeof(TrainingPlanViewModel).GetProperty(paramList.SortField); var data = _context.TrainingPlan; var resultSet = _context.TrainingPlan .IgnoreQueryFilters() .WhereIf(!String.IsNullOrEmpty(paramList.SearchTerm), a => a.Name.Contains(paramList.SearchTerm) || a.Objective.Contains(paramList.SearchTerm) || a.Event.Name.Contains(paramList.SearchTerm)) .ToListViewModel(); return(paramList.ToResultSetPage(propertyInfo, resultSet)); }
public ResultSetPage <SubscriptionTypeAttributeViewModel> GetEntityListBySearchParams( GridLoadParam paramList) { var propertyInfo = typeof(SubscriptionTypeAttributeViewModel).GetProperty(paramList.SortField); var resultSet = _context.SubscriptionTypeAttribute .Include(a => a.SubscriptionType) .Include(a => a.CreatedUser) .Include(a => a.UpdatedUser) .IgnoreQueryFilters() .WhereIf(!string.IsNullOrEmpty(paramList.SearchTerm), a => a.Name.Contains(paramList.SearchTerm)) .ToListViewModel(); return(paramList.ToResultSetPage(propertyInfo, resultSet)); }
public ResultSetPage <RaceResultViewModel> GetEntityListBySearchParams( GridLoadParam paramList) { var propertyInfo = typeof(RaceResultViewModel).GetProperty(paramList.SortField); var resultSet = _context.RaceResult .Include(a => a.Member.Person) .Include(a => a.RaceDistance.Race) .IgnoreQueryFilters() .Where(a => a.RaceDistance.RaceId == paramList.ParentId) .WhereIf(!String.IsNullOrEmpty(paramList.SearchTerm), a => a.Member.Person.FullName.Contains(paramList.SearchTerm)) .ToListViewModel(); return(paramList.ToResultSetPage(propertyInfo, resultSet)); }
public ResultSetPage <CartViewModel> GetEntityListBySearchParams( GridLoadParam paramList) { var propertyInfo = typeof(CartViewModel).GetProperty(paramList.SortField); var resultSet = _context.Cart .Include(a => a.ProductSize.Product.ProductCategory) .Include(a => a.ProductSize.Size) .Include(a => a.UpdatedUser) .Include(a => a.CreatedUser) .IgnoreQueryFilters() .WhereIf(!String.IsNullOrEmpty(paramList.SearchTerm), a => a.ProductSize.Product.Name.Contains(paramList.SearchTerm)) .ToListViewModel(); return(paramList.ToResultSetPage(propertyInfo, resultSet)); }
public ResultSetPage <MemberViewModel> GetEntityListBySearchParams( GridLoadParam paramList) { var propertyInfo = typeof(MemberViewModel).GetProperty(paramList.SortField); var resultSet = _context.Member .IgnoreQueryFilters() .WhereIf(!String.IsNullOrEmpty(paramList.SearchTerm), a => a.MemberNo.Contains(paramList.SearchTerm.ToLower()) || a.Person.FullName.ToLower().Contains(paramList.SearchTerm.ToLower()) || a.Person.AgeGroup.Name.ToLower().Contains(paramList.SearchTerm.ToLower()) || a.Person.Gender.Name.ToLower().Contains(paramList.SearchTerm.ToLower()) ) .ToListViewModel(); return(paramList.ToResultSetPage(propertyInfo, resultSet)); }
/// <summary> /// Transform parameters into GridloadParams class /// </summary> ///<param name="userID">Current UserID</param> ///<param name="skip">Records to skip</param> ///<param name="take">Record to return</param> ///<param name="isDescending">Sort direction</param> ///<param name="sortField">Sort Field</param> ///<param name="searchFilter">Term to filter records</param> ///<returns>GridLoadParam</returns> public static GridLoadParam ToGridLoadParam(this string userID, int skip, int take, bool isDescending, string sortField, string searchFilter) { var param = new GridLoadParam { SessionUserId = userID, Skip = skip, Take = take, IsDescending = isDescending, SortField = sortField, }; return(param); }
public ResultSetPage <QuoteViewModel> GetEntityListBySearchParams( GridLoadParam paramList) { var propertyInfo = typeof(QuoteViewModel).GetProperty(paramList.SortField); var resultSet = _context.Quote .Include(a => a.QuoteStatus) .Include(a => a.QuoteDetails).ThenInclude(b => b.SubscriptionTypeRuleAudit) .Include(a => a.FinYear) .Include(a => a.QuoteUser) .Include(a => a.QuoteDetails).ThenInclude(b => b.CreatedUser) .Include(a => a.QuoteDetails).ThenInclude(a => a.UpdatedUser) .IgnoreQueryFilters() .WhereIf(!String.IsNullOrEmpty(paramList.SearchTerm), a => a.QuoteNo.Contains(paramList.SearchTerm) || a.QuoteStatus.Name.Contains(paramList.SearchTerm)) .ToListViewModel(); return(paramList.ToResultSetPage(propertyInfo, resultSet)); }
public ResultSetPage <AwardTrophyViewModel> GetEntityListBySearchParams( GridLoadParam paramList) { var propertyInfo = typeof(AwardTrophyViewModel).GetProperty(paramList.SortField); var resultSet = _context.AwardTrophy .Include(a => a.FinYear) .Include(a => a.Award) .Include(a => a.Trophy) .Include(c => c.Award.Gender) .Include(a => a.CreatedUser) .Include(a => a.UpdatedUser) .IgnoreQueryFilters() .WhereIf(!string.IsNullOrEmpty(paramList.SearchTerm), a => a.Award.Name.Contains(paramList.SearchTerm)) .ToListViewModel(); return(paramList.ToResultSetPage(propertyInfo, resultSet)); }
public ResultSetPage <TrophyViewModel> GetEntityListBySearchParams( GridLoadParam paramList) { try { var propertyInfo = typeof(TrophyViewModel).GetProperty(paramList.SortField); var trophy = _context.Trophy.ToList(); var resultSet = _context.Trophy .IgnoreQueryFilters() .WhereIf(!String.IsNullOrEmpty(paramList.SearchTerm), a => a.Document.Name.Contains(paramList.SearchTerm)) .IgnoreQueryFilters() .ToListViewModel(); return(paramList.ToResultSetPage(propertyInfo, resultSet)); } catch (Exception ex) { throw; } }
public static ResultSetPage <T> ToResultSetPage <T>( this GridLoadParam param, System.Reflection.PropertyInfo propertyInfo, IEnumerable <T> entityList) { try { var recordCount = param.Take == -1 ? entityList.Count() : param.Take; return(new ResultSetPage <T>( param.Skip, entityList.Count(), entityList.ToList() .OrderByWithDirection(x => propertyInfo.GetValue(x, null), param.IsDescending) .Skip(param.Skip) .Take(recordCount) .ToList())); } catch (Exception ex) { throw; } }