public ServerSidePage GetWithOutAdmins([FromQuery] serverSideParams serverSidePrm) { var users = _dbContext.Users.Where(user => !user.IsAdmin); var recsTotal = users.Count(); if (!string.IsNullOrEmpty(serverSidePrm.searchValue)) { users = users.Where(s => s.FirstName.Contains(serverSidePrm.searchValue) || s.MiddleName.Contains(serverSidePrm.searchValue) || s.LastName.Contains(serverSidePrm.searchValue) || s.Telephone.Contains(serverSidePrm.searchValue)); } var recordsFiltered = users.Count(); users = serverSidePrm.SortingByRules(users); var items = users.AsNoTracking().Skip(serverSidePrm.start).Take(serverSidePrm.length).ToArray(); var result = new ServerSidePage() { draw = serverSidePrm.draw, recordsTotal = recsTotal, recordsFiltered = recordsFiltered, error = string.Empty, data = items }; return(result); }
private static string PackServerSideInParams(string beginParams, serverSideParams serverSidePrms) { var strBuilderParams = new StringBuilder() .Append(beginParams) .Append(ServerSideParamDraw) .Append(serverSidePrms.draw) .Append(ServerSideParamStart) .Append(serverSidePrms.start) .Append(ServerSideParamLength) .Append(serverSidePrms.length) .Append(ServerSideParamColumnsDatas) .Append(serverSidePrms.columnsDatas) .Append(ServerSideParamColumnsOrderable) .Append(serverSidePrms.columnsOrderable) .Append(ServerSideParamColumnsSearchable) .Append(serverSidePrms.columnsSearchable) .Append(ServerSideParamColumnsSearchRegex) .Append(serverSidePrms.columnsSearchRegex) .Append(ServerSideParamSearchValue) .Append(serverSidePrms.searchValue) .Append(ServerSideParamOrderColumns) .Append(serverSidePrms.orderColumns) .Append(ServerSideParamOrderDirs) .Append(serverSidePrms.orderDirs) .Append(ServerSideParamСolumnsSearchValue) .Append(serverSidePrms.columnsSearchValue) .Append(ServerSideParamSearchRegex) .Append(serverSidePrms.searchRegex); return(strBuilderParams.ToString()); }
public async Task <ServerSidePage> GetAllUsersWithoutAdmins(serverSideParams serverSidePrms) { try { HttpResponseMessage response = _client.GetAsync(PackServerSideInParams(ApiUsersWithoutAdmins, serverSidePrms)).Result; if (response.IsSuccessStatusCode) { var stringResult = await response.Content.ReadAsStringAsync(); return(JsonConvert.DeserializeObject <ServerSidePage>(stringResult)); } return(new ServerSidePage() { error = $"Error status: {response.StatusCode.ToString()}" }); } catch (Exception e) { return(new ServerSidePage() { error = e.Message }); } }
public IActionResult OnGetEveryBody([FromQuery] serverSideParams serverSide) { var task = Task.Run(() => _proxyServiceCallingWebApi.GetAllUsers(serverSide)); var users = task.Result; var jsonObj = new JsonResult(new { users }); return(jsonObj); }
public JsonResult GetNoAdmins([FromServices] IProxyServiceCallingWebApi proxyServiceCallingWeb, [FromQuery] serverSideParams serverSide) { var task = Task.Run(() => proxyServiceCallingWeb.GetAllUsersWithoutAdmins(serverSide)); var users = task.Result; var jsonObj = Json(new { users }); return(jsonObj); }