public Task <PageResponse <LastArtist> > GetRecommendedArtistsAsync(int page = 1, int limit = 30)
{
return(Task.FromResult(PageResponse <LastArtist> .CreateSuccessResponse(new List <LastArtist>
{
CreateArtist("Iggy Azalea",
"http://musicimage.xboxlive.com/content/music.1F154700-0200-11DB-89CA-0019B92A3933/image?locale=en-US")
})));
}
public async Task <IActionResult> Post([FromBody] PageRequest request)
{
var response = await PhotoAlbumService.GetPhotoAlbum();
var PageResponse = PageResponse <PhotoAlbum.DataType.PhotoAlbumType> .ReturnPageResponse(response, request.Page, request.PageSize);
return(Ok(PageResponse));
}
public JsonResult Del(string Id)
{
_ManagerService.Delete(Id);
PageResponse response = new PageResponse();
response.code = StatusCodeDefine.Success;
return(Json(response));
}
protected PageResponse <T> PageResult(IPagedList <T> value)
{
PageResponse <T> pageResponse = new PageResponse <T>();
pageResponse.IsSuccess = true;
pageResponse.Result = value;
return(pageResponse);
}
public PageResponse GetUsers(PageRequest pageRequest)
{
var users = _userRepository.GetUsers(pageRequest.PageNumber, pageRequest.PageCount);
var totalSalary = _userRepository.GetUsersSalarySum();
var pageResponse = new PageResponse(users.Select(c => _userMapper.UserToDto(c, totalSalary)), pageRequest.PageNumber);
return(pageResponse);
}
private WebResults CreateResults <T>(PageResponse <T> paging) where T : new()
{
return(new WebResults
{
HasMore = paging.TotalPages > paging.Page,
PageToken = $"{paging.Page + 1}"
});
}
public async Task <PageResponse> Page(string tableName, IPageRequest req)
{
if (!req.ContainsQueryField("columnNum"))
{
return(PageResponse <ContentData> .Error("无效数据"));
}
return(await _dapper.Page(tableName, req));
}
public PageResponse <InvoiceDto> Execute(InvoiceSearch search)
{
var query = context.Invoice.Include(x => x.InvoiceLine).ThenInclude(x => x.Track).AsQueryable();
if (!string.IsNullOrEmpty(search.NazivPesme) || !string.IsNullOrWhiteSpace(search.NazivPesme))
{
query = query.Where(x => x.InvoiceLine.Any(x => x.Track.Name.ToLower().Contains(search.NazivPesme.ToLower())));
}
if (search.IdKupca > 0)
{
query = query.Where(x => x.CustomerId == search.IdKupca);
}
if (!string.IsNullOrEmpty(search.KompanijaKupca) || !string.IsNullOrWhiteSpace(search.KompanijaKupca))
{
query = query.Where(x => x.Customer.Company.ToLower().Contains(search.KompanijaKupca.ToLower()));
}
if (!string.IsNullOrEmpty(search.DrzavaKupca) || !string.IsNullOrWhiteSpace(search.DrzavaKupca))
{
query = query.Where(x => x.Customer.Country.ToLower().Contains(search.DrzavaKupca.ToLower()));
}
if (search.MinimalnaCena > 0)
{
query = query.Where(x => x.Total >= search.MinimalnaCena);
}
if (search.MaxCena > 0)
{
query = query.Where(x => x.Total <= search.MaxCena);
}
var preskokBrojanja = search.PoStrani * (search.Strana - 1);
var odgovor = new PageResponse <InvoiceDto>
{
UkupanBrojStavki = query.Count(),
StavkePoStrani = search.PoStrani,
TrenutnaStrana = search.Strana,
Stavke = query.Skip(preskokBrojanja).Take(search.PoStrani).Select(x => new InvoiceDto
{
Id = x.InvoiceId,
ImeKupca = x.Customer.FirstName,
PrezimeKupca = x.Customer.LastName,
EmailKupca = x.Customer.Email,
TelefonKupca = x.Customer.Phone,
BillingAdresa = x.BillingAddress,
BillingGrad = x.BillingCity,
BillingRegion = x.BillingState,
BillingDrzava = x.BillingCountry,
BillingPostanskiBroj = x.BillingPostalCode,
StavkeFakture = x.InvoiceLine.Where(y => y.InvoiceId == x.InvoiceId).Select(i => new InvoiceLineDto
{
Id = i.InvoiceId,
NazivPesme = i.Track.Name,
Cena = i.UnitPrice,
Kolicina = i.Quantity
}).ToList()
})
};
return(odgovor);
}
public void LoginTest()
{
// given: mocks
var lastAuthMock = new Mock <ILastAuth>(MockBehavior.Strict);
bool isSubscriber = true;
string username = "******";
string token = "TestToken";
lastAuthMock.Setup(l => l.UserSession).Returns(new LastUserSession()
{
IsSubscriber = isSubscriber, Token = token, Username = username
});
lastAuthMock.Setup(l => l.LoadSession(It.IsAny <LastUserSession>())).Returns(true);
lastAuthMock.Setup(l => l.Authenticated).Returns(true);
var userApiMock = new Mock <IUserApi>(MockBehavior.Strict);
userApiMock.Setup(u => u.GetRecentScrobbles(It.IsAny <string>(), It.IsAny <DateTimeOffset?>(), It.IsAny <DateTimeOffset?>(),
It.IsAny <bool>(), 1, It.IsAny <int>()))
.Returns(() => Task.Run(() => PageResponse <LastTrack> .CreateSuccessResponse()));
userApiMock.Setup(u => u.GetRecentScrobbles(It.IsAny <string>(), It.IsAny <DateTimeOffset?>(), It.IsAny <DateTimeOffset?>(),
It.IsAny <bool>(), 2, It.IsAny <int>()))
.Returns(() => Task.Run(() => PageResponse <LastTrack> .CreateSuccessResponse()));
userApiMock.Setup(u => u.GetRecentScrobbles(It.IsAny <string>(), It.IsAny <DateTimeOffset?>(), It.IsAny <DateTimeOffset?>(),
It.IsAny <bool>(), 3, It.IsAny <int>()))
.Returns(() => Task.Run(() => PageResponse <LastTrack> .CreateSuccessResponse()));
var messageBoxServiceMock = new Mock <IMessageBoxService>(MockBehavior.Strict);
messageBoxServiceMock.Setup(m => m.ShowDialog(It.IsAny <string>())).Returns(IMessageBoxServiceResult.OK);
var windowManagerMock = new Mock <IExtendedWindowManager>(MockBehavior.Strict);
windowManagerMock.Setup(w => w.ShowDialog(It.IsAny <LoginViewModel>(), It.IsAny <object>(), It.IsAny <IDictionary <string, object> >())).Returns(true);
windowManagerMock.SetupGet(w => w.MessageBoxService).Returns(messageBoxServiceMock.Object);
var fileOperatorMock = new Mock <IFileOperator>(MockBehavior.Strict);
var directoryOperatorMock = new Mock <IDirectoryOperator>(MockBehavior.Strict);
directoryOperatorMock.Setup(d => d.Exists(It.IsAny <string>())).Returns(true);
directoryOperatorMock.Setup(d => d.GetFiles(It.IsAny <string>())).Returns(Array.Empty <string>());
var userSerializerMock = new Mock <ISerializer>(MockBehavior.Strict);
userSerializerMock.Setup(u => u.Serialize(It.IsAny <User>(), It.IsAny <string>(), It.IsAny <IEnumerable <Type> >()));
UserViewModel vm = new UserViewModel(windowManagerMock.Object, lastAuthMock.Object, userApiMock.Object, fileOperatorMock.Object, directoryOperatorMock.Object, userSerializerMock.Object);
vm.AddUser();
vm.SelectedUser = vm.AvailableUsers.First();
// when: logging the user in
vm.LoginUser();
// then: active user changed
Assert.That(vm.ActiveUser, Is.SameAs(vm.SelectedUser));
}
public void Class_Handles_404_Response()
{
var client = new WebClientWrapper(this.baseUrl);
PageResponse <string> response = client.DownloadString("/nonexistent-url");
response.ResponseCode.ShouldBe(HttpStatusCode.NotFound);
response.Content.ShouldBeNull();
}
public void DownloadString_Handles_Valid_Response()
{
var client = new WebClientWrapper(this.baseUrl);
PageResponse <string> response = client.DownloadString("/valid-url");
response.ResponseCode.ShouldBe(HttpStatusCode.OK);
response.Content.ShouldContain("valid url");
}
public JsonResult Edit(Manager request)
{
PageResponse response = new PageResponse();
_ManagerService.Update(request);
response.code = StatusCodeDefine.Success;
response.status = 0;
return(Json(response));
}
public void PageResponseShouldInitializeWithValidValues()
{
var col = new[] { 1, 2, 3 };
var subject = new PageResponse <int>(col, 5);
Assert.Equal(5, subject.TotalCount);
Assert.Equal(col, subject.Items);
}
public void Class_Handles_Error_Response()
{
var client = new WebClientWrapper(this.baseUrl);
PageResponse <string> response = client.DownloadString("/invalid-url");
response.ResponseCode.ShouldBe(HttpStatusCode.InternalServerError);
response.Content.ShouldBeNull();
}
/// <summary>
/// 修改服务
/// </summary>
/// <param name="sqlconnect"></param>
/// <returns></returns>
public async Task <ActionResult> UpdateTemp(TemplateConfig temp)
{
PageResponse reponse = new PageResponse();
var update = _sqliteFreeSql.Update <TemplateConfig>();
var i = update.SetSource(temp).ExecuteAffrows();
_sqliteFreeSql.Dispose();
return(i > 0 ? Response(temp) : Response("添加失败"));
}
public static PageResponse read(BinaryReader binaryReader)
{
PageResponse newObj = new PageResponse();
newObj.i_bookID = binaryReader.ReadUInt32();
newObj.i_pageNum = binaryReader.ReadInt32();
newObj.i_success = binaryReader.ReadInt32();
return(newObj);
}
public PageResponse <MovieDto> Execute(MovieSearch search)
{
var query = _context.Movies.AsQueryable();
//admin panel
if (!string.IsNullOrWhiteSpace(search.Time) || !string.IsNullOrWhiteSpace(search.Date))
{
var splitDate = search.Date.Split('-');
var searchDate = new DateTime(int.Parse(splitDate[0]), int.Parse(splitDate[1]), int.Parse(splitDate[2]), int.Parse(search.Time), 0, 0);
query = query.Where(m => m.Screenings.Where(s => s.ScreeningTime == searchDate).Any());
}
if (!string.IsNullOrEmpty(search.Title) || !string.IsNullOrWhiteSpace(search.Title))
{
query = query.Where(x => x.Title.ToLower().Contains(search.Title.ToLower()));
}
if (!string.IsNullOrEmpty(search.Description) || !string.IsNullOrWhiteSpace(search.Description))
{
query = query.Where(x => x.Description.ToLower().Contains(search.Description.ToLower()));
}
var skipCount = search.ItemsPerPage * (search.CurrentPage - 1);
var response = new PageResponse <MovieDto>
{
TotalCount = query.Count(),
ItemsPerPage = search.ItemsPerPage,
CurrentPage = search.CurrentPage,
Items = query.Skip(skipCount).Take(search.ItemsPerPage).Select(x => new MovieDto
{
Id = x.Id,
Title = x.Title,
Description = x.Description,
Duration = x.Duration,
Image = x.Image,
Screening = x.Screenings.Select(s => new ScreeningDto
{
Id = s.Id,
ScreeningTime = s.ScreeningTime,
MovieName = x.Title,
Description = x.Description,
Duration = x.Duration,
Image = x.Image,
MovieId = s.MovieId,
AuditoriumName = s.Auditorium.Name,
AuditoriumId = s.Auditorium.Id
}).ToList()
}).ToList()
};
return(response);
}
public IEnumerable <ProductDto> Read(PageRequest pageRequest, out PageResponse pageResponse, string orderBy = "", ProductFilter productFilter = null)
{
List <ProductDto> Products = BogDBContext.Product
.ApplyFilterParameters(productFilter)
.ApplyOrderParameters(orderBy)
.TakePage(pageRequest, out pageResponse)
.Select(x => x.ToProductDto()).ToList();
return(Products);
}
public IEnumerable <ConsultantDto> Read(PageRequest pageRequest, out PageResponse pageResponse, string orderBy = "", ConsultantFilter consultantFilter = null)
{
List <ConsultantDto> Consultants = this.BogDBContext.Consultant
.ApplyFilterParameters(consultantFilter)
.ApplyOrderParameters(orderBy)
.TakePage(pageRequest, out pageResponse)
.Select(x => x.ToConsultantDto()).ToList();
return(Consultants);
}
public JsonResult Create(Manager request)
{
request.Id = Guid.NewGuid().GuidTo16String();
var id = _ManagerService.Add(request);
PageResponse response = new PageResponse();
response.code = StatusCodeDefine.Success;
response.status = 0;
return(Json(response));
}
public IReportRow Compare(PageResponse origin, PageResponse target)
{
var unequalFields = new List <TagValue>();
var page1Attributes = origin.FindTagValues(_compareFields);
var page2Attributes = target.FindTagValues(_compareFields);
unequalFields.AddRange(page1Attributes.Except(page2Attributes, new TagValueComparer()));
return(new TagCompareResult(origin, unequalFields));
}
/// <summary>
/// 查询留言
/// </summary>
/// <returns></returns>
public JsonResult SelectMessages(PageRequest request)
{
PageResponse response = new PageResponse();
response.CurrentPage = request.Page;
response.Total = _db.Messages.Count();
response.Data = Mapper.Map <List <MessageDto> >(_db.Messages.WhereIf(!string.IsNullOrEmpty(request.KeyWord), m => m.Name.Contains(request.KeyWord) || m.Content.Contains(request.KeyWord) || m.Email.Contains(request.KeyWord) || m.Phone.Contains(request.KeyWord)).Skip((request.Page - 1) * request.Limit).Take(request.Limit).ToList());
response.Success = true;
return(Json(response));
}
private bool IsDisabledOutlinePosition(PageResponse origin)
{
if (_disabledOutlinePositionPages == null)
{
return(false);
}
return(_disabledOutlinePositionPages
.Any(x => origin.RequestedUri.LocalPath.ToLower() == x.LocalPath.ToLower()));
}
/// <summary>
/// 动态查询
/// </summary>
/// <param name="dto"></param>
/// <returns></returns>
public override PageResponse GetList(BaseDto basedto)
{
PageResponse response = new PageResponse();
var dto = (SysLogDto)basedto;
var query = base.Table.AsQueryable();
//条件查询
if (dto.StartTime.HasValue)
{
query = query.Where(p => p.CreateTime >= dto.StartTime);
}
if (dto.EndTime.HasValue)
{
query = query.Where(p => p.CreateTime <= dto.EndTime);
}
if (!string.IsNullOrEmpty(dto.RoleId))
{
query = query.Where(p => p.RoleId == dto.RoleId);
}
var db = (TibosDbContext)base.DbContent;
var queryList = from m in query
join j in db.Manager on m.MId equals j.Id
join n in db.Navigation on m.NId equals n.Id
join d in db.Dict on m.RoleId equals d.Id
select new SysLogDto
{
CreateTime = m.CreateTime,
ExecuteTime = m.ExecuteTime,
FromBady = m.FromBady,
Id = m.Id,
LoginIp = m.LoginIp,
MId = m.MId,
ManagerName = j.UserName,
NId = m.NId,
RoleId = m.RoleId,
UrlParam = m.UrlParam,
DictName = d.Name,
NavName = n.Name
};
response.total = queryList.Count();
if (response.total > 0)
{
//根据参数进行排序
queryList = queryList.OrderByDescending(p => p.CreateTime);
if (dto.pageIndex.HasValue && dto.pageSize.HasValue)
{
queryList = queryList.Skip((dto.pageIndex.Value - 1) * dto.pageSize.Value).Take(dto.pageSize.Value);
}
}
response.status = 0;
response.code = StatusCodeDefine.Success;
response.data = queryList.ToList();
return(response);
}
public List <ArtistDto> MapArtists(PageResponse <LastArtist> artists)
{
List <ArtistDto> artistDtoList = new List <ArtistDto>();
foreach (var artist in artists)
{
ArtistDto artistDto = MapArtist(artist);
artistDtoList.Add(artistDto);
}
return(artistDtoList);
}
// Top artists for 2 users
public async Task <TasteModels> GetEmbedTasteAsync(PageResponse <LastArtist> leftUserArtists,
PageResponse <LastArtist> rightUserArtists, int amount, ChartTimePeriod timePeriod)
{
var matchedArtists = ArtistsToShow(leftUserArtists, rightUserArtists);
var left = "";
var right = "";
foreach (var artist in matchedArtists.Take(amount))
{
var name = artist.Name;
if (!string.IsNullOrWhiteSpace(name) && name.Length > 24)
{
left += $"**{name.Substring(0, 24)}..**\n";
}
else
{
left += $"**{name}**\n";
}
var ownPlaycount = artist.PlayCount.Value;
var otherPlaycount = rightUserArtists.Content.First(f => f.Name.Equals(name)).PlayCount.Value;
if (ownPlaycount > otherPlaycount)
{
right += $"**{ownPlaycount}**";
}
else
{
right += $"{ownPlaycount}";
}
right += " • ";
if (otherPlaycount > ownPlaycount)
{
right += $"**{otherPlaycount}**";
}
else
{
right += $"{otherPlaycount}";
}
right += $"\n";
}
var description = Description(leftUserArtists, timePeriod, matchedArtists);
return(new TasteModels
{
Description = description,
LeftDescription = left,
RightDescription = right
});
}
/// <summary>
/// 分页查询新闻数据
/// </summary>
/// <param name="request"></param>
/// <returns></returns>
public async Task <JsonResult> SelectNewses(PageRequest request)
{
PageResponse response = new PageResponse();
var datas = _db.Newses.WhereIf(!string.IsNullOrEmpty(request.KeyWord), n => n.NewsTitle.Contains(request.KeyWord) || n.NewsContent.Contains(request.KeyWord)).Skip((request.Page - 1) * request.Limit).Take(request.Limit).Include(n => n.NewsClassification).ToList();
response.Total = _db.Newses.Count();
response.Data = Mapper.Map <List <NewsTableDto> >(datas);
response.CurrentPage = request.Page;
response.Success = true;
return(Json(response));
}
public async Task <PageResponse> Page([FromBody] JObject form)
{
string columnNum = form["columnNum"].ToStr();
if (columnNum.IsEmpty())
{
return(PageResponse.Error("请选择栏目"));
}
return(await _service.GetTreeTableData(columnNum));
}
public IEnumerable <spGetSales_BasedOnConsultantsDto> GetSalesBasedOnConsultants(DateTime startDate, DateTime endDate, PageRequest pageRequest, out PageResponse pageResponse)
{
List <spGetSales_BasedOnConsultantsDto> Result =
BogDBContext.GetSalesBasedOnConsultants(startDate, endDate, pageRequest.PageNumber, pageRequest.PageSize, out int totalCount).Select(x => x.ToSpGetSales_BasedOnConsultantsDto()).ToList();
pageResponse = new PageResponse {
CurrentPage = pageRequest.PageNumber, PageSize = pageRequest.PageSize, TotalCount = totalCount
};
return(Result);
}
public ActionResult <PageResponse <SearchAreaResponse> > Search(
[FromQuery] Nullable <int> page,
[FromQuery] Nullable <int> limit,
[FromQuery] Dictionary <string, string> order)
{
PageRequest pr = PageRequest.Of(page, limit);
PageResponse <SearchAreaResponse> pagedResponse = service.SearchPaged(pr);
return(Ok(pagedResponse));
}
/// <see cref="WorkQueue.IRequestHandler.HandleRequest"/>
public WorkQueue.Response HandleRequest( WorkQueue.Request req, WorkQueue srcQ )
{
// Background thread (maybe)
var preq = (PageRequest)req.Data;
// only deal with own requests; we shouldn't ever get here though
if ( preq.srcPage != this )
{
return null;
}
var res = new PageResponse();
res.pageData = new PageData();
WorkQueue.Response response;
try
{
PrepareImpl( ref res.pageData );
response = new WorkQueue.Response( req, true, res );
}
catch ( Exception e )
{
// oops
response = new WorkQueue.Response( req, false, res, e.Message );
}
return response;
}
