public Task <IEnumerable <ProjectAssignmentDto> > GetAllAsync(ProjectAssignmentGridSettings settings)
{
Guard.ArgumentIsNotNull(settings, nameof(settings));
Guard.ArgumentIsNotNull(settings.PagingSettings, nameof(settings.PagingSettings));
Guard.ArgumentIsNotNull(settings.SortingSettings, nameof(settings.SortingSettings));
Guard.ArgumentIsNotNull(settings.ProjectAssignmentFilter, nameof(settings.ProjectAssignmentFilter));
DynamicParameters parameters = new DynamicParameters();
parameters.Add("CurrentPage", settings.PagingSettings.CurrentPage);
parameters.Add("ItemsPerPage", settings.PagingSettings.ItemsPerPage);
parameters.Add("SortColumnName", settings.SortingSettings.SortColumnName);
parameters.Add("IsDescending", settings.SortingSettings.IsDescending);
parameters.Add("SearchKeyword", settings.SearchKeyword ?? string.Empty);
parameters.Add("EmployeeFullNameFilter", settings.ProjectAssignmentFilter.EmployeeFullName ?? string.Empty);
parameters.Add("EmployeeJobTitleFilter", settings.ProjectAssignmentFilter.EmployeeJobTitle ?? string.Empty);
parameters.Add("EmployeeTechnologyFilter",
settings.ProjectAssignmentFilter.EmployeeTechnology ?? string.Empty);
parameters.Add("ProjectFilter", settings.ProjectAssignmentFilter.ProjectName ?? string.Empty);
parameters.Add("DepartmentFilter", settings.ProjectAssignmentFilter.DepartmentName ?? string.Empty);
parameters.Add("ShowOldAssignments", settings.ProjectAssignmentFilter.ShowOldAssignments);
parameters.Add("ShowOldDeactivatedProjects", settings.ProjectAssignmentFilter.ShowOldDeactivatedProjects);
return(QueryAsync <ProjectAssignmentDto>(StoredProcedures.ProjectAssignment.GetAll, parameters));
}
public Task <int> GetTotalCountAsync(ProjectAssignmentGridSettings settings)
{
Guard.ArgumentIsNotNull(settings, nameof(settings));
Guard.ArgumentIsNotNull(settings.PagingSettings, nameof(settings.PagingSettings));
Guard.ArgumentIsNotNull(settings.SortingSettings, nameof(settings.SortingSettings));
Guard.ArgumentIsNotNull(settings.ProjectAssignmentFilter, nameof(settings.ProjectAssignmentFilter));
DynamicParameters parameters = new DynamicParameters();
parameters.Add("SearchKeyword", settings.SearchKeyword ?? string.Empty);
parameters.Add("EmployeeFullNameFilter", settings.ProjectAssignmentFilter.EmployeeFullName ?? string.Empty);
parameters.Add("EmployeeJobTitleFilter", settings.ProjectAssignmentFilter.EmployeeJobTitle ?? string.Empty);
parameters.Add("EmployeeTechnologyFilter",
settings.ProjectAssignmentFilter.EmployeeTechnology ?? string.Empty);
parameters.Add("ProjectFilter", settings.ProjectAssignmentFilter.ProjectName ?? string.Empty);
parameters.Add("DepartmentFilter", settings.ProjectAssignmentFilter.DepartmentName ?? string.Empty);
parameters.Add("ShowOldAssignments", settings.ProjectAssignmentFilter.ShowOldAssignments);
parameters.Add("ShowOldDeactivatedProjects", settings.ProjectAssignmentFilter.ShowOldDeactivatedProjects);
return(QuerySingleOrDefaultAsync <int>(StoredProcedures.ProjectAssignment.GetTotalCount, parameters));
}
public async Task <GrigData <Common.Models.Assignment.ProjectAssignment> > GetAllAsync(ProjectAssignmentGridSettings settings)
{
Guard.ArgumentIsNotNull(settings, nameof(settings));
IEnumerable <ProjectAssignmentDto> dtoList = await _projectAssignmentRepository.GetAllAsync(settings);
int totalCount = await _projectAssignmentRepository.GetTotalCountAsync(settings);
IEnumerable <Common.Models.Assignment.ProjectAssignment> result = _mapper.Map <IEnumerable <ProjectAssignmentDto>, IEnumerable <Common.Models.Assignment.ProjectAssignment> >(dtoList);
return(new GrigData <Common.Models.Assignment.ProjectAssignment>
{
Data = result,
TotalCount = totalCount
});
}
