public static GetPagingRequest GetDataOfPagingRequest(HttpRequestBase request) { var draw = request.Form.GetValues("draw").FirstOrDefault(); //Find paging info var start = request.Form.GetValues("start").FirstOrDefault(); var length = request.Form.GetValues("length").FirstOrDefault(); //Find order columns info var sortColumn = request.Form.GetValues("columns[" + request.Form.GetValues("order[0][column]").FirstOrDefault() + "][name]").FirstOrDefault(); var sortColumnDir = request.Form.GetValues("order[0][dir]").FirstOrDefault(); //find search columns info var keyWord = request.Form.GetValues("columns[0][search][value]").FirstOrDefault(); var model = new GetPagingRequest() { Draw = draw, Start = start, Length = length, SortColumn = sortColumn, SortColumnDir = sortColumnDir, Keyword = keyWord }; return(model); }
public async Task <PagedResult <EmployeeListViewModel> > GetEmployee(GetPagingRequest request) { var _params = new DynamicParameters(); _params.Add("@filter", string.IsNullOrEmpty(request.Keyword) ? "" : request.Keyword); _params.Add("@status", string.IsNullOrEmpty(request.Status) ? "" : request.Status); return(await HisPro78WithConnection(async conn => { var query = await conn.QueryAsync <EmployeeListViewModel>("get_list_employee", _params, commandType: CommandType.StoredProcedure); var totalRecords = query.Count(); var items = query .Skip((request.pageIndex - 1) * request.pageSize) .Take(request.pageSize) .ToList(); var pagination = new PagedResult <EmployeeListViewModel> { Items = items, TotalRows = totalRecords, PageIndex = request.pageIndex, PageSize = request.pageSize }; return pagination; })); }
public int GetTotalPaging(GetPagingRequest request) { DynamicParameters parameters = new DynamicParameters(); parameters.Add("@Q", request.Filter); var result = dbConnection.QueryFirstOrDefault <int>($"Proc_GetTotal{tableName}", parameters, commandType: CommandType.StoredProcedure); return(result); }
public IEnumerable <T> GetPaging(GetPagingRequest request) { DynamicParameters parameters = new DynamicParameters(); parameters.Add("@PageIndex", request.PageIndex); parameters.Add("@PageSize", request.PageSize); parameters.Add("@Q", request.Filter); var result = dbConnection.Query <T>($"Proc_GetPaging{tableName}", parameters, commandType: CommandType.StoredProcedure); return(result); }
public IActionResult GetPaing([FromQuery] GetPagingRequest request) { var employees = _baseService.GetPaging(request); if (employees.Any()) { return(Ok(employees)); } else { return(NoContent()); } }
public async Task <IActionResult> Index(string keyword, string status, int pageIndex = 1, int pageSize = 10) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } else { var request = new GetPagingRequest() { Keyword = keyword, Status = status, pageIndex = pageIndex, pageSize = pageSize }; var result = await _employeeRepository.GetEmployee(request); ViewBag.Keyword = keyword; return(View(result)); } }
public int GetTotalPaging(GetPagingRequest request) { return(_baseRepository.GetTotalPaging(request)); }
public IEnumerable <T> GetPaging(GetPagingRequest request) { return(_baseRepository.GetPaging(request)); }
public IActionResult GetTotalPaing([FromQuery] GetPagingRequest request) { var employees = _baseService.GetTotalPaging(request); return(Ok(employees)); }