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