public Task <int> GetTotalCountAsync(ProjectGridSettings settings)
{
Guard.ArgumentIsNotNull(settings, nameof(settings));
Guard.ArgumentIsNotNull(settings.PagingSettings, nameof(settings.PagingSettings));
Guard.ArgumentIsNotNull(settings.SortingSettings, nameof(settings.SortingSettings));
DynamicParameters parameters = new DynamicParameters();
parameters.Add("SearchKeyword", settings.SearchKeyword ?? string.Empty);
parameters.Add("ShowOld", settings.ShowOld);
parameters.Add("ShowDeactivated", settings.ShowDeactivated);
return(QuerySingleOrDefaultAsync <int>(StoredProcedures.Project.GetTotalCount, parameters));
}
public async Task <GrigData <Common.Models.Project.Project> > GetAllAsync(ProjectGridSettings settings)
{
Guard.ArgumentIsNotNull(settings, nameof(settings));
IEnumerable <ProjectDto> dtoList = await _projectRepositoryAdmin.GetAllAsync(settings);
int totalCount = await _projectRepositoryAdmin.GetTotalCountAsync(settings);
IEnumerable <Common.Models.Project.Project> result = _mapper.Map <IEnumerable <ProjectDto>, IEnumerable <Common.Models.Project.Project> >(dtoList);
return(new GrigData <Common.Models.Project.Project>
{
Data = result,
TotalCount = totalCount
});
}
public Task <IEnumerable <ProjectDto> > GetAllAsync(ProjectGridSettings settings)
{
Guard.ArgumentIsNotNull(settings, nameof(settings));
Guard.ArgumentIsNotNull(settings.PagingSettings, nameof(settings.PagingSettings));
Guard.ArgumentIsNotNull(settings.SortingSettings, nameof(settings.SortingSettings));
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("ShowOld", settings.ShowOld);
parameters.Add("ShowDeactivated", settings.ShowDeactivated);
return(QueryAsync <ProjectDto>(StoredProcedures.Project.GetAllAdmin, parameters));
}
