/// <inheritdoc />
public Task <GetListResult <EccUserModel> > GetUsers(GetListSearchModel model)
{
var query = CltDbContext.Clients
.AsNoTracking()
.OrderBy(x => x.CreatedOn);
return(EFCoreExtensions.GetAsync(model, query, SelectExpression));
}
/// <summary>
/// Получить файлы
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public async Task <GetListResult <FileModel> > GetFileIds(GetListSearchModel model)
{
var result = await FileQueryService.GetFilesWithRelations(new SearchFiles
{
Count = model.Count,
OffSet = model.OffSet,
});
return(new GetListResult <FileModel>
{
Count = result.Count,
List = result.List.Select(x => new FileModel
{
FileId = x.Id,
FileName = x.FileName,
}).ToList(),
OffSet = result.OffSet,
TotalCount = result.TotalCount
});
}
/// <summary>
/// Получить сообщения
/// </summary>
/// <param name="model"></param>
/// <param name="token"></param>
/// <returns></returns>
public Task <GetListResult <ChatMessageModel> > GetMessages(GetChatMessages model, CancellationToken token = default)
{
var query = Query <EccChatMessage>()
.Where(x => x.ChatId == model.ChatId && x.SentOnUtcTicks <= model.LessThantUtcTicks)
.OrderBy(x => x.SentOnUtcTicks);
var searchModel = new GetListSearchModel
{
Count = model.Count,
OffSet = 0
};
return(EFCoreExtensions.GetAsync(searchModel, query, x => new ChatMessageModel
{
Id = x.Id,
SenderUserId = x.SenderUserId,
SentOnUtcTicks = x.SentOnUtcTicks,
LastUpdateUtcTicks = x.LastUpdateOnUtcTicks,
Message = x.Message,
TagString = x.TagString
}));
}
/// <summary>
/// Получить группы адресов
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public Task <GetListResult <EmailGroupModel> > GetEmailGroups(GetListSearchModel model)
{
return(EFCoreExtensions.GetAsync(model, Query <EmailGroup>().OrderByDescending(x => x.CreatedOn), SelectExpression));
}
/// <summary>
/// Искать ловителей переходов
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public Task <GetListResult <EmailLinkCatchRedirectsCountModel> > Query(GetListSearchModel model)
{
return(EFCoreExtensions.GetAsync(model, Query <EmailLinkCatch>().OrderByDescending(x => x.CreatedOnUtc), SelectExpression));
}
/// <summary>
/// Получить список отправленных адресов
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public Task <GetListResult <UserMailMessageModel> > GetMailsAsync(GetListSearchModel model)
{
var initQuery = Query <MailMessageInteraction>().OrderByDescending(x => x.CreatedOn);
return(EFCoreExtensions.GetAsync(model, initQuery, UserMailMessageModel.SelectExpression));
}
