public async Task <PagedQueryResultSet <ConfigurationSettingDto> > GetAsync(ResultSetCriteria gridCriteria, ConfigurationSearchCriteria searchCriteria)
{
string key = searchCriteria.Key ?? string.Empty;
var configurationList = (await _dataContext.GetDocumentsWithPagingAsync <ConfigurationSetting, ConfigurationSettingDto>
(q => q.Where(c =>
(searchCriteria.Culture == "any" || c.Culture == searchCriteria.Culture) &&
(searchCriteria.Section == "any" || c.Section == searchCriteria.Section) &&
(string.IsNullOrEmpty(key) || c.Key.ToLower().Contains(key.ToLower().Trim())))
.Select(c => new ConfigurationSettingDto
{
Id = c.Id,
IsDeleted = c.IsDeleted,
Culture = c.Culture,
GroupId = c.GroupId,
Section = c.Section,
Key = c.Key,
IncludeInPod = c.IncludeInPod,
Priority = c.Priority,
Value = c.Value,
ETag = c.ETag,
UpdatedOnUtc = c.UpdatedOnUtc,
UpdatedByName = c.UpdatedByName,
UpdatedById = c.UpdatedById
}), gridCriteria));
return(configurationList);
}
public async Task <PagedQueryResultSet <LocalisationTextDto> > GetAsync(ResultSetCriteria gridCriteria, ConfigurationSearchCriteria searchCriteria)
{
if (string.IsNullOrWhiteSpace(searchCriteria.Key))
{
searchCriteria.Key = "";
}
var result = await _dataContext.GetDocumentsWithPagingAsync <LocalisationText, LocalisationTextDto>(q =>
q.Where(d =>
(searchCriteria.Culture == "any" || d.Culture == searchCriteria.Culture) &&
(searchCriteria.Section == "any" || d.Section == searchCriteria.Section) &&
(searchCriteria.Key == "" || d.Key.Contains(searchCriteria.Key.ToUpper().Trim())))
.Select(c => new LocalisationTextDto
{
Id = c.Id,
IsDeleted = c.IsDeleted,
Culture = c.Culture,
GroupId = c.GroupId,
Section = c.Section,
Key = c.Key,
Priority = c.Priority,
Value = c.Value,
IncludeInPod = c.IncludeInPod,
ETag = c.ETag,
UpdatedOnUtc = c.UpdatedOnUtc,
UpdatedById = c.UpdatedById,
UpdatedByName = c.UpdatedByName
}), gridCriteria);
return(result);
}
public async Task <PagedQueryResultSet <LookupDto> > GetLookupListAsync(ResultSetCriteria gridCriteria, ConfigurationSearchCriteria searchCriteria)
{
if (string.IsNullOrWhiteSpace(searchCriteria.Key))
{
searchCriteria.Key = "";
}
var result = await _dataContext.GetDocumentsWithPagingAsync <Lookup, Lookup>(q =>
q.Where(d =>
(searchCriteria.Culture == "any" || d.Culture == searchCriteria.Culture) &&
(searchCriteria.Section == "any" || d.Section == searchCriteria.Section) &&
(searchCriteria.Key == "" || d.Key.Contains(searchCriteria.Key.ToUpper().Trim()))),
gridCriteria);
var lookupDtoList = result.Results.Select(l => new LookupDto
{
Id = l.Id,
IsDeleted = l.IsDeleted,
Culture = l.Culture,
GroupId = l.GroupId,
Key = l.Key,
IncludeInPod = l.IncludeInPod,
Section = l.Section,
Priority = l.Priority,
UpdatedById = l.UpdatedById,
UpdatedByName = l.UpdatedByName,
UpdatedOnUtc = l.UpdatedOnUtc,
ItemValueList = l.Items.OrderBy(i => i.Value).Take(6).Select(item => item.Value)
}).ToList();
return(new PagedQueryResultSet <LookupDto> {
Results = lookupDtoList, ContinuationToken = result.ContinuationToken
});
}
public async Task <PagedQueryResultSet <AlertTemplateDto> > GetAsync(ResultSetCriteria gridCriteria, AlertTemplateSearchCriteria searchCriteria)
{
if (string.IsNullOrWhiteSpace(searchCriteria.Key))
{
searchCriteria.Key = "";
}
var result = await _dataContext.GetDocumentsWithPagingAsync <AlertTemplate, AlertTemplateDto>(q =>
q.Where(d =>
(searchCriteria.Culture == "any" || d.Culture == searchCriteria.Culture) &&
(searchCriteria.Section == "any" || d.Section == searchCriteria.Section) &&
(searchCriteria.Key == "" || d.Key.Contains(searchCriteria.Key.ToUpper().Trim())) &&
(searchCriteria.Channel == "any" || d.Channel == searchCriteria.Channel))
.Select(c => new AlertTemplateDto
{
Id = c.Id,
IsDeleted = c.IsDeleted,
Culture = c.Culture,
GroupId = c.GroupId,
Section = c.Section,
Key = c.Key,
Priority = c.Priority,
Channel = c.Channel,
ETag = c.ETag,
UpdatedOnUtc = c.UpdatedOnUtc,
UpdatedById = c.UpdatedById,
UpdatedByName = c.UpdatedByName
}), gridCriteria);
return(result);
}
public async Task <PagedQueryResultSet <PermissionConfigDto> > GetAsync(ResultSetCriteria gridCriteria, PermissionSearchCriteria searchCriteria)
{
var data = await _dataContext.GetDocumentsWithPagingAsync <PermissionConfig, PermissionConfigDto>(q =>
q.Where(p => (searchCriteria.Role == "any" || p.Role == searchCriteria.Role))
.Select(p => new PermissionConfigDto
{
GroupId = p.GroupId,
Role = p.Role,
IsDeleted = p.IsDeleted,
Permissions = p.Permissions,
Id = p.Id,
UpdatedById = p.UpdatedById,
UpdatedByName = p.UpdatedByName,
UpdatedOnUtc = p.UpdatedOnUtc,
ETag = p.ETag
}), gridCriteria);
return(data);
}