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));
}
