public JsonResult <List <Models.TaskDetails> > GetAllTaskDetailsFiltered([FromBody] SearchSortParameter request)
{
var result = TaskEntities.GetAllTasks();
List <DataAccessLayer.TaskDetail> prodList;
IEnumerable <DataAccessLayer.TaskDetail> searchResult;
if (!string.IsNullOrEmpty(request.Search))
{
searchResult = result.Where(x => x.Task.Contains(request.Search));
}
else
{
searchResult = result;
}
prodList = searchResult.AsQueryable().OrderByPropertyName(request.SortBy, request.Ascending).ToList();
var taskObj = Mapper.Map <List <DataAccessLayer.TaskDetail>, List <Models.TaskDetails> >(prodList);
return(Json(taskObj));
}
public JsonResult <List <Models.ViewProjectDetail> > GetViewProjectsFiltered([FromBody] SearchSortParameter request)
{
var result = ProjectEntities.GetViewProjectDetails();
List <DataAccessLayer.ViewProjectDetails> projectList;
IEnumerable <DataAccessLayer.ViewProjectDetails> searchResult;
if (!string.IsNullOrEmpty(request.Search))
{
searchResult = result.Where(x => x.ProjectDesc.Contains(request.Search));
}
else
{
searchResult = result;
}
projectList = searchResult.AsQueryable().OrderByPropertyName(request.SortBy, request.Ascending).ToList();
var projectObj = Mapper.Map <List <DataAccessLayer.ViewProjectDetails>, List <Models.ViewProjectDetail> >(projectList);
return(Json(projectObj));
}
public JsonResult <List <Models.User> > GetAllUsersFiltered([FromBody] SearchSortParameter request)
{
var result = UserEntities.GetAllUsers();
List <DataAccessLayer.User> prodList;
IEnumerable <DataAccessLayer.User> searchResult;
if (!string.IsNullOrEmpty(request.Search))
{
searchResult = result.Where(x => x.FirstName.Contains(request.Search) || x.LastName.Contains(request.Search) || x.EmpId.ToString().Contains(request.Search));
}
else
{
searchResult = result;
}
prodList = searchResult.AsQueryable().OrderByPropertyName(request.SortBy, request.Ascending).ToList();
var userObj = Mapper.Map <List <DataAccessLayer.User>, List <Models.User> >(prodList);
return(Json(userObj));
}
