public IActionResult List(TaskListRequestPayload payload)
{
var response = ResponseModelFactory.CreateResultInstance;
using (_dbContext)
{
var query = _dbContext.DncTaskList.AsQueryable();
if (!string.IsNullOrEmpty(payload.Kw))
{
query = query.Where(x => x.PersonLiable.Contains(payload.Kw.Trim()) || x.Code.Contains(payload.Kw.Trim()));
}
/*if (payload.IsDeleted > CommonEnum.IsDeleted.All)
* {
* query = query.Where(x => x.IsComplete == payload.IsDeleted);
* }*/
/* if (payload.Status > CommonEnum.Status.All)
* {
* query = query.Where(x => x.Status == payload.Status);
* }*/
var list = query.Paged(payload.CurrentPage, payload.PageSize).ToList();
var totalCount = query.Count();
var data = list.Select(_mapper.Map <DncTaskList, TaskListJsonModel>);
response.SetData(data, totalCount);
return(Ok(response));
}
}
public IActionResult Select(TaskListRequestPayload payload)
{
var response = ResponseModelFactory.CreateResultInstance;
using (_dbContext)
{
var sql = string.Format("exec QueryStatistics");
var query = _dbContext.DncTaskList.FromSql(sql);
var list = query.Paged(payload.CurrentPage, payload.PageSize).ToList();
var totalCount = query.Count();
var data = list.Select(_mapper.Map <DncTaskList, TaskListJsonModel>);
response.SetData(data, totalCount);
return(Ok(response));
}
}
