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