public IActionResult Get([FromQuery] TenantQueryModel query) { return(Ok(new { Data = _tenantService.Get(query), Count = _tenantService.Count(query) })); }
public long Count(TenantQueryModel query) { Expression <Func <Tenant, bool> > where = ExpressionExtension.TrueExpression <Tenant>() .AndIfHaveValue(query.Name, t => t.Name.Contains(query.Name)); var queryExpress = _tenantRepository.Get(where); return(_tenantRepository.CountAsync(queryExpress).Result); }
public IEnumerable <TenantResultModel> Get(TenantQueryModel query) { Expression <Func <Tenant, bool> > where = ExpressionExtension.TrueExpression <Tenant>() .AndIfHaveValue(query.Name, t => t.Name.Contains(query.Name)); Expression <Func <Tenant, object> > order = query.SortKey switch { "CreatedTime" => t => t.CreatedTime, _ => t => t.CreatedTime, }; var result = _tenantRepository.Get(where, order, query.Page, query.Size, query.isDesc, false); return(result.Count() > 0 ? _mapper.Map <Tenant[], TenantResultModel[]>(result.ToArray()) : new TenantResultModel[] { }); }
public object List( [FromBody] TenantQueryModel search, [FromQuery] int page, [FromQuery] int count) { var query = GetEngines() .Skip((page - 1) * count) .Take(count) .Select(e => new EngineSettingsModel() { Name = e.Settings.Name, IsDefault = string.Equals(e.Settings.Name, EngineHelper.DefaultEngineName, StringComparison.OrdinalIgnoreCase), EngineSettings = e.Settings }); return(new PagedResult <EngineSettingsModel>() { List = query.ToList(), Total = GetEngines().Count() }); }