public SearchResult <TaskListDTO> GetDataByFilter(TaskListSearchFilter filter)
{
if (string.IsNullOrEmpty(filter.SortName))
{
filter.SortName = "UserID";
}
TaskListQuery sowQuery = new TaskListQuery(this.Db);
var filteredRecords =
sowQuery.GetQuery()
.Where(sow =>
sow.UserId == filter.UserID &&
(sow.BTS.Contains(filter.Keyword) ||
sow.Address.Contains(filter.Keyword))
);
var displayedRecords = filteredRecords.
SortBy(filter.SortName, filter.SortDir)
.Skip(filter.Skip)
.Take(filter.PageSize)
.ToList();
var searchResult = new SearchResult <TaskListDTO>(filter);
searchResult.Filter = filter;
searchResult.Count.TotalRecords = sowQuery.GetTotalRecords();
searchResult.Count.TotalFiltered = filteredRecords.Count();
searchResult.Count.TotalDisplayed = displayedRecords.Count();
searchResult.Records = displayedRecords;
return(searchResult);
}
public List <TaskInformation> GetDBTaskList(TaskListQuery query)
{
var allTasks = _taskRepository.GetAll();
//TODO: implement proper filtering logic here if needed, for now returning all the tasks in the file
//var filteredData = allTasks.Where(x => x.Name == query.Name || x.StartDate > query.FromDate || x.EndDate < query.ToDate).ToList();
var filteredData = allTasks;
return(filteredData);
}
public void TaskListQueryMade()
{
var handler = new TaskListQueryHandler(context);
var taskListQuery = new TaskListQuery
{
EventId = _task.Event.Id
};
var result = handler.Handle(taskListQuery).ToList();
Assert.NotNull(result);
Assert.Equal(result.Count, 1);
var task = result.First();
Assert.Equal(task.Id, _task.Id);
Assert.Equal(task.Name, _task.Name);
Assert.Equal(task.StartDateTime, _task.StartDateTime);
Assert.Equal(task.EndDateTime, _task.EndDateTime);
Assert.Equal(task.NumberOfVolunteersRequired, _task.NumberOfVolunteersRequired);
Assert.False(task.IsUserSignedUpForTask);
}
public void TaskListQueryMade()
{
var handler = new TaskListQueryHandler(context);
var taskListQuery = new TaskListQuery
{
EventId = _task.Event.Id
};
var result = handler.Handle(taskListQuery).ToList();
Assert.NotNull(result);
Assert.Equal(result.Count, 1);
var task = result.First();
Assert.Equal(task.Id, _task.Id);
Assert.Equal(task.Name, _task.Name);
Assert.Equal(task.StartDateTime, _task.StartDateTime);
Assert.Equal(task.EndDateTime, _task.EndDateTime);
Assert.Equal(task.NumberOfVolunteersRequired, _task.NumberOfVolunteersRequired);
Assert.False(task.IsUserSignedUpForTask);
}
