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