public static List <RoleViewModel> ToPagedListViewModel(PagedModel <RoleProfileDto> result) { var viewModels = result.Data.Select(it => { var model = new RoleViewModel { Deptid = it.Deptid?.ToString(), CreateBy = it.CreateBy, CreateTime = it.CreateTime, Id = it.Id.ToString(), ModifyBy = it.ModifyBy, ModifyTime = it.ModifyTime, Name = it.Name, Num = it.Num ?? 1, Pid = it.Pid?.ToString(), Tips = it.Tips, Version = it.Version ?? 1, DeptName = it.DeptName, PName = it.PName }; return(model); }).ToList(); return(viewModels); }
public void Should_correctly_calculate_values_on_middle_page() { var model = new PagedModel { CurrentPage = 3, PageSize = 20, TotalCount = 70 }; Assert.That(model.Start, Is.EqualTo(41)); Assert.That(model.End, Is.EqualTo(60)); Assert.That(model.ActualEnd, Is.EqualTo(60)); Assert.That(model.HasNext, Is.True); Assert.That(model.HasPrevious, Is.True); Assert.That(model.TotalPages, Is.EqualTo(4)); var menuModel = model.GetMenuModel(); Assert.That(menuModel.ActualEnd, Is.EqualTo(60)); Assert.That(menuModel.CurrentPage, Is.EqualTo(3)); Assert.That(menuModel.CurrentPageIsValid, Is.True); Assert.That(menuModel.End, Is.EqualTo(60)); Assert.That(menuModel.HasNext, Is.True); Assert.That(menuModel.HasPrevious, Is.True); Assert.That(menuModel.PageSize, Is.EqualTo(20)); Assert.That(menuModel.ShouldShowMenu, Is.True); Assert.That(menuModel.Start, Is.EqualTo(41)); Assert.That(menuModel.TotalCount, Is.EqualTo(70)); Assert.That(menuModel.TotalPages, Is.EqualTo(4)); }
public ActionResult Index(string query, PagedModel<object> pageModel) { pageModel.PageItems = 18; if (!string.IsNullOrEmpty(query)) { var searchQuery = HttpContext.Request.QueryString["query"]; using (var session = RepositoryFactory.StartUnitOfWork(IoC.Resolve<SearchContext>())) { // test search for user name var searchResult = RepositoryFactory.Command<ISearchCommands>().Search(session, searchQuery); pageModel.LoadData(searchResult); } } else { pageModel = null; } return ViewWithAjax(new SearchViewModel() { Query = query, SearchResults = pageModel }); }
public IActionResult Index([FromQuery] int current = 1, [FromQuery] int rowCount = 10, [FromQuery] string searchPhrase = null) { var query = repo.GetAllSections(); if (!string.IsNullOrEmpty(searchPhrase)) { query = query.Where(x => x.Name.Contains(searchPhrase, System.StringComparison.OrdinalIgnoreCase)); } var total = query.Count(); var sections = query.Skip((current - 1) * rowCount).Take(rowCount); var model = new PagedModel <SectionViewModel> { current = current, rowCount = rowCount, total = total, rows = from s in query select CreateSectionViewModel(s) }; //.Select(x => //new SectionViewModel //{ // SectionId = x.SectionId, // Name = x.Name, //}); return(Negotiate(model)); }
public async Task StructureAsync_successfully_returns_a_PagedModelV1MarketStructure() { int characterId = 98772; MarketScopes scopes = MarketScopes.esi_markets_structure_markets_v1; SsoToken inputToken = new SsoToken { AccessToken = "This is a old access token", RefreshToken = "This is a old refresh token", CharacterId = characterId, MarketScopesFlags = scopes }; LatestMarketEndpoints internalLatestMarket = new LatestMarketEndpoints(string.Empty, true); PagedModel <V1MarketStructure> result = await internalLatestMarket.StructureAsync(inputToken, 1, 1); Assert.Equal(1, result.Model.Count); Assert.Equal(90, result.Model[0].Duration); Assert.False(result.Model[0].IsBuyOrder); Assert.Equal(new DateTime(2016, 09, 03, 05, 12, 25), result.Model[0].Issued); Assert.Equal(1020988381992, result.Model[0].LocationId); Assert.Equal(1, result.Model[0].MinVolume); Assert.Equal(4623824223, result.Model[0].OrderId); Assert.Equal(9.9, result.Model[0].Price); Assert.Equal(MarketRange.Region, result.Model[0].Range); Assert.Equal(34, result.Model[0].TypeId); Assert.Equal(1296000, result.Model[0].VolumeRemain); Assert.Equal(2000000, result.Model[0].VolumeTotal); }
private PreparedMessageContent PrepareProblemListContent(PagedModel <DbProblemsListBusinessModel> problemsPagedModel, int currentPage)//TODO: Localization { var problems = problemsPagedModel.Data.ToList(); var sb = new StringBuilder(); var buttons = new InlineKeyboardButton[problems.Count + 1][];//+1 for pagination sb.AppendLine(Resources.Tasks); sb.AppendLine(Resources.ListOfTasksDescription); sb.AppendLine(); for (var i = 0; i < problems.Count; i++) { var problem = problems[i]; buttons[i] = new InlineKeyboardButton[1]; var isSolved = problem.IsSolved ? "❌" : "✅"; buttons[i][0] = InlineKeyboardButton.WithCallbackData($"{isSolved}| {problem.ProblemCode} | L-{problem.ProblemLevel} | {problem.SubjectName.Substring(0, 7) + "..."} - {problem.ProblemName}", $"{SectionEnums.DbProblems} {problem.Id}"); } buttons = AddPagination(buttons, currentPage, Convert.ToInt32(Math.Ceiling((double)problemsPagedModel.Total / (ConstData.TotalItemsAmountForList * 1.0)))); return(new PreparedMessageContent { ResponseText = sb.ToString(), InlineKeyboardMarkup = new InlineKeyboardMarkup(buttons) }); }
public async Task StructureAsync_successfully_returns_a_PagedModelV1MarketStructure() { Mock <IWebClient> mockedWebClient = new Mock <IWebClient>(); int characterId = 98772; MarketScopes scopes = MarketScopes.esi_markets_structure_markets_v1; SsoToken inputToken = new SsoToken { AccessToken = "This is a old access token", RefreshToken = "This is a old refresh token", CharacterId = characterId, MarketScopesFlags = scopes }; string json = "[\r\n {\r\n \"duration\": 90,\r\n \"is_buy_order\": false,\r\n \"issued\": \"2016-09-03T05:12:25Z\",\r\n \"location_id\": 1020988381992,\r\n \"min_volume\": 1,\r\n \"order_id\": 4623824223,\r\n \"price\": 9.9,\r\n \"range\": \"region\",\r\n \"type_id\": 34,\r\n \"volume_remain\": 1296000,\r\n \"volume_total\": 2000000\r\n }\r\n]"; mockedWebClient.Setup(x => x.GetAsync(It.IsAny <WebHeaderCollection>(), It.IsAny <string>(), It.IsAny <int>())).ReturnsAsync(new EsiModel { Model = json }); InternalLatestMarket internalLatestMarket = new InternalLatestMarket(mockedWebClient.Object, string.Empty); PagedModel <V1MarketStructure> result = await internalLatestMarket.StructureAsync(inputToken, 1, 1); Assert.Equal(1, result.Model.Count); Assert.Equal(90, result.Model[0].Duration); Assert.False(result.Model[0].IsBuyOrder); Assert.Equal(new DateTime(2016, 09, 03, 05, 12, 25), result.Model[0].Issued); Assert.Equal(1020988381992, result.Model[0].LocationId); Assert.Equal(1, result.Model[0].MinVolume); Assert.Equal(4623824223, result.Model[0].OrderId); Assert.Equal(9.9, result.Model[0].Price); Assert.Equal(MarketRange.Region, result.Model[0].Range); Assert.Equal(34, result.Model[0].TypeId); Assert.Equal(1296000, result.Model[0].VolumeRemain); Assert.Equal(2000000, result.Model[0].VolumeTotal); }
public async Task OrdersAsync_successfully_returns_a_PagedModelV1MarketOrders() { Mock <IWebClient> mockedWebClient = new Mock <IWebClient>(); string json = "[\r\n {\r\n \"duration\": 90,\r\n \"is_buy_order\": false,\r\n \"issued\": \"2016-09-03T05:12:25Z\",\r\n \"location_id\": 60005599,\r\n \"min_volume\": 1,\r\n \"order_id\": 4623824223,\r\n \"price\": 9.9,\r\n \"range\": \"region\",\r\n \"system_id\": 30000053,\r\n \"type_id\": 34,\r\n \"volume_remain\": 1296000,\r\n \"volume_total\": 2000000\r\n }\r\n]"; mockedWebClient.Setup(x => x.GetAsync(It.IsAny <WebHeaderCollection>(), It.IsAny <string>(), It.IsAny <int>())).ReturnsAsync(new EsiModel { Model = json }); InternalLatestMarket internalLatestMarket = new InternalLatestMarket(mockedWebClient.Object, string.Empty); PagedModel <V1MarketOrders> result = await internalLatestMarket.OrdersAsync(1, OrderType.All, 1, null); Assert.Equal(1, result.Model.Count); Assert.Equal(90, result.Model[0].Duration); Assert.False(result.Model[0].IsBuyOrder); Assert.Equal(new DateTime(2016, 09, 03, 05, 12, 25), result.Model[0].Issued); Assert.Equal(60005599, result.Model[0].LocationId); Assert.Equal(1, result.Model[0].MinVolume); Assert.Equal(4623824223, result.Model[0].OrderId); Assert.Equal(9.9, result.Model[0].Price); Assert.Equal(MarketRange.Region, result.Model[0].Range); Assert.Equal(30000053, result.Model[0].SystemId); Assert.Equal(34, result.Model[0].TypeId); Assert.Equal(1296000, result.Model[0].VolumeRemain); Assert.Equal(2000000, result.Model[0].VolumeTotal); }
public static PagedModel <AccountProfileDto> ToAccountProfileDto(PagedModel <SysUser> pagedModel) { var model = new PagedModel <AccountProfileDto> { Ascending = pagedModel.Ascending, PageNumber = pagedModel.PageNumber, PageSize = pagedModel.PageSize, Sort = pagedModel.Sort, TotalCount = pagedModel.TotalCount, Data = pagedModel.Data.Select(it => new AccountProfileDto { Id = it.Id, Account = it.Account, Avatar = it.Avatar, Birthday = it.Birthday, Email = it.Email, Name = it.Name, Phone = it.Phone, ModifyBy = it.ModifyBy, ModifyTime = it.ModifyTime, CreateBy = it.CreateBy, CreateTime = it.CreateTime, Sex = (int)it.Sex, Version = it.Version, Status = it.Status == AccountStatus.Active, Deptid = it.Deptid.Value(), Roleid = it.Roleid }).ToList() }; return(model); }
public void Display(string file, int pageSize) { var model = new NumberedModel(_fileReader.Read(file)); var pageIndex = 0; while (true) { var pagedModel = new PagedModel(model, pageIndex, pageSize); var formatted = _formatter.Format(pagedModel); _console.Clear(); _console.Write(formatted); _console.WriteLine("Page {0} of {1}", pageIndex + 1, pagedModel.MaxPageIndex + 1); _console.WriteLine(String.Empty); _console.Write("N(ext page, P(revious page, F(irst page, L(ast page, J(ump to page, eX(it"); var userInput = _console.Read(); var nextAction = DetermineNextAction(pagedModel, userInput, pageIndex); pageIndex = nextAction.Execute(); if (pageIndex < 0) { return; } } }
public PagedModel Record(int currentPage) { int recordPerPage = 2; PagedModel model = _repo.GetPagedEmployees(recordPerPage, currentPage); return(model); }
public Task <PagedModel <OverviewModel> > Handle(Request request, CancellationToken cancellationToken) { Expression <Func <BlogEntry, bool> > publishedEntriesPredicate = entry => this.user.Identity.IsAuthenticated || entry.IsPublished; using (var scope = this.unitOfWork.Begin()) { var model = new PagedModel <OverviewModel>() { PageSize = request.PageSize, CurrentPage = request.CurrentPage, TotalRowCount = scope.SetOf <BlogEntry>().Count(publishedEntriesPredicate), Rows = scope.SetOf <BlogEntry>() .Where(publishedEntriesPredicate) .OrderByDescending(entry => entry.Published) .Skip(request.CurrentPage * request.PageSize) .Take(request.PageSize) .Select(e => new OverviewModel { Id = e.Id, Header = e.Header, Intro = e.Intro, Published = e.Published }) .ToList() }; return(Task.FromResult(model)); } }
public PagedModel Search(string customerCode, int page, int pageSize) { PagedModel model = new PagedModel(); var dynamicParameters = new DynamicParameters(); string sqlSelect = "select q.*,q.StartDate as Date, c.Code as CustomerCode"; string sqlCount = "SELECT COUNT(*)"; string sqlFrom = " FROM Quotation q join Customer c On q.CustomerId = c.Id"; string sqlWhere = " WHERE c.Code = @CustomerCode "; //lay total record using (var connection = Connection) { int total = connection.QuerySingle <int>(sqlCount + sqlFrom + sqlWhere, new { CustomerCode = customerCode }); model.PageTotal = total; model.Page = page; model.PageSize = pageSize; //search string sqlOrder = " order by q.StartDate desc OFFSET @page ROWS FETCH NEXT @pageSize ROWS ONLY"; IEnumerable <QuotationModel> affectedRows; if (page == 0 && pageSize == 0) { affectedRows = connection.Query <QuotationModel>(sqlSelect + sqlFrom + sqlWhere, new { CustomerCode = customerCode }); } else { affectedRows = connection.Query <QuotationModel>(sqlSelect + sqlFrom + sqlWhere + sqlOrder, new { CustomerCode = customerCode, Page = pageSize * (page - 1), PageSize = pageSize }); } model.Data = affectedRows; } return(model); }
public static async Task <PagedModel <T> > PaginateAsync <T>( this IQueryable <T> query, int page, int limit ) where T : class, new() { var pagedResponse = new PagedModel <T>(); page = (page < 0) ? 1 : page; limit = (limit < 0) ? PagedModel <T> .MaxPageSize : limit; pagedResponse.CurrentPage = page; pagedResponse.PageSize = limit; var skipCount = (page - 1) * limit; pagedResponse.Items = await query .Skip(skipCount) .Take(limit) .ToListAsync(); pagedResponse.TotalItems = await query.CountAsync(); pagedResponse.TotalPages = (int)Math.Ceiling(pagedResponse.TotalItems / (double)limit); return(pagedResponse); }
public ActionResult Index(PagedModel<StaticTextViewModel> pageModel) { pageModel.LoadData(RepositoryFactory.Action<IStaticTextData>() .GetAll(DateTime.Now) .OrderByDescending(item => item.PublishDate)); return ViewWithAjax(pageModel); }
public ActionResult Index(PagedModel<CelebrityView> pageModel) { pageModel.PageItems = 10; pageModel.PrevAsItem = true; pageModel.LoadData(RepositoryFactory.Command<ICelebrityCommands>().GetActive().OrderByDescending(item => item.Priority)); return ViewWithAjax(pageModel); }
public void CharacterTransactions_successfully_returns_a_pagedModelWalletCharacterTransaction() { int characterId = 98772; int lastId = 1; WalletScopes scopes = WalletScopes.esi_wallet_read_character_wallet_v1; SsoToken inputToken = new SsoToken { AccessToken = "This is a old access token", RefreshToken = "This is a old refresh token", CharacterId = characterId, WalletScopesFlags = scopes }; LatestWalletEndpoints internalLatestWallet = new LatestWalletEndpoints(string.Empty, true); PagedModel <V1WalletCharacterTransactions> getCharactersWalletTransactions = internalLatestWallet.CharacterTransactions(inputToken, lastId); Assert.Equal(1, getCharactersWalletTransactions.CurrentPage); Assert.Equal(1, getCharactersWalletTransactions.Model.Count); Assert.Equal(54321, getCharactersWalletTransactions.Model[0].ClientId); Assert.Equal(new DateTime(2016, 10, 24, 09, 00, 00), getCharactersWalletTransactions.Model[0].Date); Assert.True(getCharactersWalletTransactions.Model[0].IsBuy); Assert.True(getCharactersWalletTransactions.Model[0].IsPersonal); Assert.Equal(67890, getCharactersWalletTransactions.Model[0].JournalRefId); Assert.Equal(60014719, getCharactersWalletTransactions.Model[0].LocationId); Assert.Equal(1, getCharactersWalletTransactions.Model[0].Quantity); Assert.Equal(1234567890, getCharactersWalletTransactions.Model[0].TransactionId); Assert.Equal(587, getCharactersWalletTransactions.Model[0].TypeId); Assert.Equal(1, getCharactersWalletTransactions.Model[0].UnitPrice); }
public PagedModel GetAllProductByCustomer(int customerId, int page, int pageSize) { PagedModel model = new PagedModel(); var dynamicParameters = new DynamicParameters(); string sqlSelect = "SELECT c.*, p.UnitId, p.WeightPerUnit"; string sqlCount = "SELECT COUNT(*)"; string sqlFrom = " FROM Product as c JOIN ProductUnit p ON c.Id = p.ProductId" + " join QuotationItem qi on qi.ProductUnitId = p.Id" + " join Quotation q on q.Id = qi.QuotationId"; string sqlWhere = " WHERE p.IsCommonUnit = 1 AND q.CustomerId = @CustomerId AND q.EndDate is NULL"; dynamicParameters.Add("CustomerId", customerId); using (var connection = Connection) { //lay total record int total = connection.QuerySingle <int>(sqlCount + sqlFrom + sqlWhere, dynamicParameters); model.PageTotal = total; model.Page = page; model.PageSize = pageSize; //search string sqlOrder = ""; if (page != 0 && pageSize != 0) { sqlOrder = " order by c.Id OFFSET @page ROWS FETCH NEXT @pageSize ROWS ONLY"; } dynamicParameters.Add("page", 1); dynamicParameters.Add("pageSize", 10000); var affectedRows = connection.Query <ProductModel>(sqlSelect + sqlFrom + sqlWhere + sqlOrder, dynamicParameters); model.Data = affectedRows; } return(model); }
private PreparedMessageContent PrepareSubmissionsListContent(PagedModel <AllSubmissionsBusinessModel> submissionsList, int currentPage) { var submissions = submissionsList.Data.ToList(); var sb = new StringBuilder(); var buttons = new InlineKeyboardButton[submissions.Count + 1][];//+1 for pagination sb.AppendLine(Resources.YourSubmissions); sb.AppendLine(Resources.SubmissionListDescription); sb.AppendLine(); for (var i = 0; i < submissions.Count; i++) { var submission = submissions[i]; buttons[i] = new InlineKeyboardButton[1]; var isSolved = submission.IsAccepted ? "❌" : "✅"; buttons[i][0] = InlineKeyboardButton.WithCallbackData($"{isSolved}| {submission.ProblemCode} | L-{submission.ProblemName} | {submission.Status}", $"{SectionEnums.DbSubmissions} {submission.Id}"); } buttons = AddPagination(buttons, currentPage, Convert.ToInt32(Math.Ceiling((double)submissionsList.Total / (ConstData.TotalItemsAmountForList * 1.0)))); return(new PreparedMessageContent { ResponseText = sb.ToString(), InlineKeyboardMarkup = new InlineKeyboardMarkup(buttons) }); }
public void CharacterOrdersHistoric_successfully_returns_a_PagedModelV1MarketCharacterHistoricOrders() { int characterId = 98772; int page = 1; MarketScopes scopes = MarketScopes.esi_markets_read_character_orders_v1; SsoToken inputToken = new SsoToken { AccessToken = "This is a old access token", RefreshToken = "This is a old refresh token", CharacterId = characterId, MarketScopesFlags = scopes }; LatestMarketEndpoints internalLatestMarket = new LatestMarketEndpoints(string.Empty, true); PagedModel <V1MarketCharacterHistoricOrders> result = internalLatestMarket.CharacterOrdersHistoric(inputToken, page); Assert.Equal(1, result.Model.Count); Assert.Equal(30, result.Model[0].Duration); Assert.Equal(45.6, result.Model[0].Escrow); Assert.True(result.Model[0].IsBuyOrder); Assert.False(result.Model[0].IsCorporation); Assert.Equal(new DateTime(2016, 09, 03, 05, 12, 25), result.Model[0].Issued); Assert.Equal(456, result.Model[0].LocationId); Assert.Equal(1, result.Model[0].MinVolume); Assert.Equal(123, result.Model[0].OrderId); Assert.Equal(33.3, result.Model[0].Price); Assert.Equal(MarketRange.Station, result.Model[0].Range); Assert.Equal(123, result.Model[0].RegionId); Assert.Equal(MarketState.Expired, result.Model[0].State); Assert.Equal(456, result.Model[0].TypeId); Assert.Equal(4422, result.Model[0].VolumeRemain); Assert.Equal(123456, result.Model[0].VolumeTotal); }
public async Task CorporationsCustomsOfficesAsync_successfully_returns_a_pagedModelV1PlanetaryInteractionCorporationCustomsOffice() { int characterId = 88823; PlanetScopes scopes = PlanetScopes.esi_planets_read_customs_offices_v1; SsoToken inputToken = new SsoToken { AccessToken = "This is a old access token", RefreshToken = "This is a old refresh token", CharacterId = characterId, PlanetScopesFlags = scopes }; LatestPlanetaryInteractionEndpoints internalLatestPlanetaryInteraction = new LatestPlanetaryInteractionEndpoints(string.Empty, true); PagedModel <V1PlanetaryInteractionCorporationCustomsOffice> returnModel = await internalLatestPlanetaryInteraction.CorporationsCustomsOfficesAsync(inputToken, 2888, 1); Assert.Equal(1, returnModel.CurrentPage); Assert.Equal(1, returnModel.Model.Count); Assert.Equal(0.1f, returnModel.Model[0].AllianceTaxRate); Assert.True(returnModel.Model[0].AllowAccessWithStandings); Assert.False(returnModel.Model[0].AllowAllianceAccess); Assert.Equal(0.02f, returnModel.Model[0].CorporationTaxRate); Assert.Equal(0.05f, returnModel.Model[0].ExcellentStandingTaxRate); Assert.Equal(0.2f, returnModel.Model[0].GoodStandingTaxRate); Assert.Equal(0.5f, returnModel.Model[0].NeutralStandingTaxRate); Assert.Equal(1000000014530, returnModel.Model[0].OfficeId); Assert.Equal(1, returnModel.Model[0].ReinforceExitEnd); Assert.Equal(23, returnModel.Model[0].ReinforceExitStart); Assert.Equal(23, returnModel.Model[0].ReinforceExitStart); Assert.Equal(30003657, returnModel.Model[0].SystemId); }
public ActionResult Index(PagedModel <StaticTextViewModel> pageModel) { pageModel.LoadData(RepositoryFactory.Action <IStaticTextData>() .GetAll(DateTime.Now) .OrderByDescending(item => item.PublishDate)); return(ViewWithAjax(pageModel)); }
public async Task CorporationOrdersHistoricAsync_successfully_returns_a_PagedModelV3MarketCorporationOrdersHistoric() { int characterId = 98772; MarketScopes scopes = MarketScopes.esi_markets_read_corporation_orders_v1; SsoToken inputToken = new SsoToken { AccessToken = "This is a old access token", RefreshToken = "This is a old refresh token", CharacterId = characterId, MarketScopesFlags = scopes }; LatestMarketEndpoints internalLatestMarket = new LatestMarketEndpoints(string.Empty, true); PagedModel <V3MarketCorporationOrdersHistoric> result = await internalLatestMarket.CorporationOrdersHistoricAsync(inputToken, 1, 1); Assert.Equal(1, result.Model.Count); Assert.Equal(30, result.Model[0].Duration); Assert.Equal(45.6, result.Model[0].Escrow); Assert.True(result.Model[0].IsBuyOrder); Assert.Equal(new DateTime(2016, 09, 03, 05, 12, 25), result.Model[0].Issued); Assert.Equal(2112625428, result.Model[0].IssuedBy); Assert.Equal(456, result.Model[0].LocationId); Assert.Equal(1, result.Model[0].MinVolume); Assert.Equal(123, result.Model[0].OrderId); Assert.Equal(33.3, result.Model[0].Price); Assert.Equal(MarketRange.Station, result.Model[0].Range); Assert.Equal(123, result.Model[0].RegionId); Assert.Equal(MarketState.Expired, result.Model[0].State); Assert.Equal(456, result.Model[0].TypeId); Assert.Equal(4422, result.Model[0].VolumeRemain); Assert.Equal(123456, result.Model[0].VolumeTotal); Assert.Equal(1, result.Model[0].WalletDivision); }
public static PagedModel <DictDto> ToDictProfileDto( List <SysDict> all, List <SysDict> topDict, DictSearchDto criteria) { var model = new PagedModel <DictDto> { Ascending = true, PageNumber = criteria.Page, PageSize = criteria.Limit, Sort = "", TotalCount = all.Count, Data = topDict.Select(it => new DictDto { Id = it.Id, ModifyBy = it.ModifyBy, ModifyTime = it.ModifyTime, CreateBy = it.CreateBy, CreateTime = it.CreateTime, Name = it.Name, Num = it.Num, Pid = it.Pid, Tips = it.Tips }).ToList() }; return(model); }
public async Task CorporationJournalAsync_successfully_returns_a_listV3WalletCorporationJournal() { int characterId = 98772; WalletScopes scopes = WalletScopes.esi_wallet_read_corporation_wallets_v1; SsoToken inputToken = new SsoToken { AccessToken = "This is a old access token", RefreshToken = "This is a old refresh token", CharacterId = characterId, WalletScopesFlags = scopes }; LatestWalletEndpoints internalLatestWallet = new LatestWalletEndpoints(string.Empty, true); PagedModel <V4WalletCorporationJournal> getCorporationJournals = await internalLatestWallet.CorporationJournalAsync(inputToken, 999, 1, 1); Assert.Equal(1, getCorporationJournals.Model.Count); Assert.Equal(-1000, getCorporationJournals.Model[0].Amount); Assert.Equal(100000, getCorporationJournals.Model[0].Balance); Assert.Equal(2112625428, getCorporationJournals.Model[0].ContextId); Assert.Equal(WalletContextIdType.CharacterId, getCorporationJournals.Model[0].ContextIdType); Assert.Equal(new DateTime(2016, 10, 24, 09, 00, 00), getCorporationJournals.Model[0].Date); Assert.Equal("CCP Zoetrope transferred cash from C C P's corporate account to CCP SnowedIn's account", getCorporationJournals.Model[0].Description); Assert.Equal(109299958, getCorporationJournals.Model[0].FirstPartyId); Assert.Equal(1234567890, getCorporationJournals.Model[0].Id); Assert.Equal(WalletRefType.CorporationAccountWithdrawal, getCorporationJournals.Model[0].RefType); Assert.Equal(95538921, getCorporationJournals.Model[0].SecondPartyId); }
public ICommand GetCommand(PagedModel model, int currentPageIndex) { currentPageIndex = currentPageIndex + 1; currentPageIndex = EnsurePageIndexRange(model, currentPageIndex); return new SetCurrentPageCommand(currentPageIndex); }
public ActionResult NewComment(PagedModel<CommentViewModel> commentsModel, CommentCRUDModel model, string sort) { var staticText = RepositoryFactory.Command<IStaticTextData>().Get(model.ContentId, DateTime.Now); model.ChangeUser = CurrentUser; if (model.ChangeUser == null && model.RoboCheck != model.ExpressionCorrectValue) { ModelState.AddModelError<CommentCRUDModel>(item => item.RoboCheck, ModelResources.RoboCheckError); } // check for anonymous name required if not logged user if (model.ChangeUser == null && string.IsNullOrEmpty(model.AnonymousName)) { ModelState.AddModelError<CommentCRUDModel>(item => item.AnonymousName, ModelResources.AnonymousRequireError); } else if (ModelState.IsValid) { model.ChangeDate = DateTime.Now; model.ClientIp = Request.UserHostAddress; model.UserAgent = Request.UserAgent; // for anonymous user encode text if (model.ChangeUser == null) { model.Text = HtmlManipulation.RemoveTags(model.Text); } using (var tran = RepositoryFactory.StartTransaction(IoC.Resolve<SearchUpdateContext>())) { RepositoryFactory.Command<ICommentCrud>().Create(model); tran.Commit(); RepositoryFactory.Command<ISearchCommands>().IndexComment(tran, model); } return RedirectToActionWithAjax(staticText.FriendlyUrl, routeValues: new {sort = sort}); } CommentViewTypeEnum sortType = ParseCommentViewType(sort); IEnumerable<CommentTreeViewModel> comments; LoadComments(sortType, out comments, commentsModel, staticText.Id); return ViewWithAjax("ViewPage", new PageViewModel { StaticText = staticText, CommentViewType = sortType, FlatComments = commentsModel, TreeComments = comments, NewComment = model }); }
/// <summary> /// The default action. /// </summary> /// <returns>The list of maps in the system.</returns> public async Task<ActionResult> Index() { var query = new TableQuery<MapEntity>().Where( TableQuery.GenerateFilterCondition("PartitionKey", QueryComparisons.Equal, MapEntity.MainKey)); IEnumerable<MapEntity> entities = (await TableStorage.GetFromQuery(query)).OrderBy(e => e.Author).ThenBy(e => e.Title); PagedModel<MapEntity> model = new PagedModel<MapEntity> { Items = entities, ItemsTotal = entities.Count() }; return this.View(model); }
protected static int EnsurePageIndexRange(PagedModel model, int currentPageIndex) { var result = currentPageIndex; if (result > model.MaxPageIndex) { result = model.MaxPageIndex; } if (result < 0) { result = 0; } return result; }
public ICommand GetCommand(PagedModel model, int currentPageIndex) { _console.Write("Page? "); var page = _console.ReadLine(); int newPageIndex; if(int.TryParse(page, out newPageIndex)) { newPageIndex = EnsurePageIndexRange(model, newPageIndex - 1); } else { newPageIndex = currentPageIndex; } return new SetCurrentPageCommand(newPageIndex); }
public void ShouldYieldNumberOfPages() { var model = new Model(); model.SetHeader(new[] { "Foo", "Bar" }); model.AddRow(new[] { "1", "2" }); model.AddRow(new[] { "1111", "2222" }); model.AddRow(new[] { "1111", "2222" }); model.AddRow(new[] { "1111", "2222" }); model.AddRow(new[] { "1111", "2222" }); model.AddRow(new[] { "1111", "2222" }); model.AddRow(new[] { "1111", "2222" }); var paged = new PagedModel(model, 0, 2); Assert.AreEqual(3, paged.MaxPageIndex); }
public void CanRenderPagedTable_Page1() { var model = new Model(); model.SetHeader(new[] { "Foo", "Bar" }); model.AddRow(new[] { "1", "2" }); model.AddRow(new[] { "1111", "2222" }); var page1 = new PagedModel(model, 1, 1); var output = new TableFormatter().Format(page1); Assert.AreEqual(@"Foo |Bar | ----+----+ 1111|2222| ", output); }
public PagedModel<UserInGroup> FindByCriteria(UserInGroupCriteria c) { PagedModel<UserInGroup> m = new PagedModel<UserInGroup>(); var r = this.Repository.FindByCriteria(c); if(!String.IsNullOrEmpty(c.sortname)){ if(c.sortname.ToLower().Equals("id")){ if(c.sortorder.ToLower().Equals("asc")){ r = r.OrderBy(o=>o.Id); }else{ r = r.OrderByDescending(o=>o.Id); } } if(c.sortname.ToLower().Equals("usergroupid")){ if(c.sortorder.ToLower().Equals("asc")){ r = r.OrderBy(o=>o.UserGroupId); }else{ r = r.OrderByDescending(o=>o.UserGroupId); } } if(c.sortname.ToLower().Equals("userid")){ if(c.sortorder.ToLower().Equals("asc")){ r = r.OrderBy(o=>o.UserId); }else{ r = r.OrderByDescending(o=>o.UserId); } } } m.RecordCount = r.Count(); if (c.pagesize.HasValue) { int page = c.page ?? 1; int pageCount = m.RecordCount / c.pagesize.Value; if (m.RecordCount % c.pagesize.Value > 0) { pageCount++; } int skip = (page - 1) * c.pagesize.Value; if (skip > 0) { r = r.Skip(skip); } r = r.Take(c.pagesize.Value); } m.Data = r.ToList(); return m; }
public PagedModel<City> FindForSuggest(CityCriteria c) { PagedModel<City> m = new PagedModel<City>(); var r = this.Repository.FindForSuggest(c.NameSrh); if (!String.IsNullOrEmpty(c.sortname)) { if (c.sortname.ToLower().Equals("id")) { if (c.sortorder.ToLower().Equals("asc")) { r = r.OrderBy(o => o.Id); } else { r = r.OrderByDescending(o => o.Id); } } if (c.sortname.ToLower().Equals("name")) { if (c.sortorder.ToLower().Equals("asc")) { r = r.OrderBy(o => o.Name); } else { r = r.OrderByDescending(o => o.Name); } } if (c.sortname.ToLower().Equals("provinceid")) { if (c.sortorder.ToLower().Equals("asc")) { r = r.OrderBy(o => o.ProvinceId); } else { r = r.OrderByDescending(o => o.ProvinceId); } } } m.RecordCount = r.Count(); if (c.pagesize.HasValue) { int page = c.page ?? 1; int pageCount = m.RecordCount / c.pagesize.Value; if (m.RecordCount % c.pagesize.Value > 0) { pageCount++; } int skip = (page - 1) * c.pagesize.Value; if (skip > 0) { r = r.Skip(skip); } r = r.Take(c.pagesize.Value); } m.Data = r.ToList(); return m; }
public PagedModel<SmallInfoSource> FindByCriteria(SmallInfoSourceCriteria c) { PagedModel<SmallInfoSource> m = new PagedModel<SmallInfoSource>(); var r = this.Repository.FindByCriteria(c); if(!String.IsNullOrEmpty(c.sortname)){ if(c.sortname.ToLower().Equals("id")){ if(c.sortorder.ToLower().Equals("asc")){ r = r.OrderBy(o=>o.Id); }else{ r = r.OrderByDescending(o=>o.Id); } } if(c.sortname.ToLower().Equals("name")){ if(c.sortorder.ToLower().Equals("asc")){ r = r.OrderBy(o=>o.Name); }else{ r = r.OrderByDescending(o=>o.Name); } } if(c.sortname.ToLower().Equals("infosourcebigid")){ if(c.sortorder.ToLower().Equals("asc")){ r = r.OrderBy(o=>o.InfoSourceBigId); }else{ r = r.OrderByDescending(o=>o.InfoSourceBigId); } } } m.RecordCount = r.Count(); if (c.pagesize.HasValue) { int page = c.page ?? 1; int pageCount = m.RecordCount / c.pagesize.Value; if (m.RecordCount % c.pagesize.Value > 0) { pageCount++; } int skip = (page - 1) * c.pagesize.Value; if (skip > 0) { r = r.Skip(skip); } r = r.Take(c.pagesize.Value); } m.Data = r.ToList(); return m; }
public void ShouldYieldExpectedPageIndexForUserInput(string userInput, int expectedNewPageIndex) { var model = new Model() .SetHeader(new[] { "header" }) .AddRow(new[] { "one" }) .AddRow(new[] { "two" }) .AddRow(new[] { "three" }); const int CurrentPage = 1; var paged = new PagedModel(model, CurrentPage, 1); var output = A.Fake<IConsole>(); A .CallTo(() => output.ReadLine()) .Returns(userInput); var jtp = new JumpToPage(output); var newPageIndex = jtp.GetCommand(paged, CurrentPage).Execute(); Assert.AreEqual(expectedNewPageIndex, newPageIndex); }
public ActionResult Date(string query, PagedModel<object> pageModel) { if (!string.IsNullOrEmpty(query)) { using (var session = RepositoryFactory.StartUnitOfWork(IoC.Resolve<SearchContext>())) { // test search for user name var searchResult = RepositoryFactory.Action<ISearchAction>().SearchByDate(session, query); pageModel.LoadData(searchResult); } } else { pageModel = null; } return ViewWithAjax("Index", new SearchViewModel() { Query = query, SearchResults = pageModel }); }
public ActionResult Index(PagedModel<CommentForAdminViewModel> pageModel) { var data = RepositoryFactory.Command<ICommentData>().GetAllForAdmin() .OrderByDescending(comment => comment.CreatedDate); pageModel.LoadData(data); return ViewWithAjax(pageModel); }
partial void AfterGetData(LigerGridModel gm, SchoolContactCriteria c, PagedModel<SchoolContact> pm);
partial void AfterBuildGridModel(LigerGridModel gm, SchoolContactCriteria c, PagedModel<SchoolContact> pm);
public ActionResult Index(PagedModel<Person> pageModel) { pageModel.LoadData(RepositoryFactory.Command<IPersonCommand>().GetAll().OrderByDescending(item => item.FullName)); return View(pageModel); }
public ActionResult Deleted(PagedModel<StaticTextViewModel> pageModel) { pageModel.LoadData(RepositoryFactory.Action<IStaticTextData>().GetDeleted().OrderByDescending(item => item.PublishDate)); return ViewWithAjax("Index", pageModel); }
partial void AfterGetData(LigerGridModel gm, UserGroupCriteria c, PagedModel<UserGroup> pm);
partial void AfterBuildGridModel(LigerGridModel gm, UserGroupCriteria c, PagedModel<UserGroup> pm);
public PagedModel<School> FindByCriteria(SchoolCriteria c) { PagedModel<School> m = new PagedModel<School>(); var r = this.Repository.FindByCriteria(c); if(!String.IsNullOrEmpty(c.sortname)){ if(c.sortname.ToLower().Equals("id")){ if(c.sortorder.ToLower().Equals("asc")){ r = r.OrderBy(o=>o.Id); }else{ r = r.OrderByDescending(o=>o.Id); } } if(c.sortname.ToLower().Equals("name")){ if(c.sortorder.ToLower().Equals("asc")){ r = r.OrderBy(o=>o.Name); }else{ r = r.OrderByDescending(o=>o.Name); } } if(c.sortname.ToLower().Equals("districtid")){ if(c.sortorder.ToLower().Equals("asc")){ r = r.OrderBy(o=>o.DistrictId); }else{ r = r.OrderByDescending(o=>o.DistrictId); } } if(c.sortname.ToLower().Equals("issold")){ if(c.sortorder.ToLower().Equals("asc")){ r = r.OrderBy(o=>o.IsSold); }else{ r = r.OrderByDescending(o=>o.IsSold); } } if(c.sortname.ToLower().Equals("type")){ if(c.sortorder.ToLower().Equals("asc")){ r = r.OrderBy(o=>o.Type); }else{ r = r.OrderByDescending(o=>o.Type); } } if(c.sortname.ToLower().Equals("levels")){ if(c.sortorder.ToLower().Equals("asc")){ r = r.OrderBy(o=>o.Levels); }else{ r = r.OrderByDescending(o=>o.Levels); } } if(c.sortname.ToLower().Equals("devby")){ if(c.sortorder.ToLower().Equals("asc")){ r = r.OrderBy(o=>o.DevBy); }else{ r = r.OrderByDescending(o=>o.DevBy); } } if(c.sortname.ToLower().Equals("devdate")){ if(c.sortorder.ToLower().Equals("asc")){ r = r.OrderBy(o=>o.DevDate); }else{ r = r.OrderByDescending(o=>o.DevDate); } } if(c.sortname.ToLower().Equals("important")){ if(c.sortorder.ToLower().Equals("asc")){ r = r.OrderBy(o=>o.Important); }else{ r = r.OrderByDescending(o=>o.Important); } } if(c.sortname.ToLower().Equals("equipments")){ if(c.sortorder.ToLower().Equals("asc")){ r = r.OrderBy(o=>o.Equipments); }else{ r = r.OrderByDescending(o=>o.Equipments); } } if(c.sortname.ToLower().Equals("daojishipai")){ if(c.sortorder.ToLower().Equals("asc")){ r = r.OrderBy(o=>o.DaoJiShiPai); }else{ r = r.OrderByDescending(o=>o.DaoJiShiPai); } } if(c.sortname.ToLower().Equals("jiaoshibiaoyu")){ if(c.sortorder.ToLower().Equals("asc")){ r = r.OrderBy(o=>o.JiaoShiBiaoYu); }else{ r = r.OrderByDescending(o=>o.JiaoShiBiaoYu); } } if(c.sortname.ToLower().Equals("shushibiaoyu")){ if(c.sortorder.ToLower().Equals("asc")){ r = r.OrderBy(o=>o.ShuShiBiaoYu); }else{ r = r.OrderByDescending(o=>o.ShuShiBiaoYu); } } if(c.sortname.ToLower().Equals("shitangbiaoyu")){ if(c.sortorder.ToLower().Equals("asc")){ r = r.OrderBy(o=>o.ShiTangBiaoYu); }else{ r = r.OrderByDescending(o=>o.ShiTangBiaoYu); } } if(c.sortname.ToLower().Equals("loutibiaoyu")){ if(c.sortorder.ToLower().Equals("asc")){ r = r.OrderBy(o=>o.LouTiBiaoYu); }else{ r = r.OrderByDescending(o=>o.LouTiBiaoYu); } } if(c.sortname.ToLower().Equals("butiao")){ if(c.sortorder.ToLower().Equals("asc")){ r = r.OrderBy(o=>o.BuTiao); }else{ r = r.OrderByDescending(o=>o.BuTiao); } } if(c.sortname.ToLower().Equals("address")){ if(c.sortorder.ToLower().Equals("asc")){ r = r.OrderBy(o=>o.Address); }else{ r = r.OrderByDescending(o=>o.Address); } } if(c.sortname.ToLower().Equals("highclassqty")){ if(c.sortorder.ToLower().Equals("asc")){ r = r.OrderBy(o=>o.HighClassQty); }else{ r = r.OrderByDescending(o=>o.HighClassQty); } } if(c.sortname.ToLower().Equals("highstudentqty")){ if(c.sortorder.ToLower().Equals("asc")){ r = r.OrderBy(o=>o.HighStudentQty); }else{ r = r.OrderByDescending(o=>o.HighStudentQty); } } if(c.sortname.ToLower().Equals("lowclassqty")){ if(c.sortorder.ToLower().Equals("asc")){ r = r.OrderBy(o=>o.LowClassQty); }else{ r = r.OrderByDescending(o=>o.LowClassQty); } } if(c.sortname.ToLower().Equals("lowstudentqty")){ if(c.sortorder.ToLower().Equals("asc")){ r = r.OrderBy(o=>o.LowStudentQty); }else{ r = r.OrderByDescending(o=>o.LowStudentQty); } } if(c.sortname.ToLower().Equals("remark")){ if(c.sortorder.ToLower().Equals("asc")){ r = r.OrderBy(o=>o.Remark); }else{ r = r.OrderByDescending(o=>o.Remark); } } if(c.sortname.ToLower().Equals("oldoahuwaiid")){ if(c.sortorder.ToLower().Equals("asc")){ r = r.OrderBy(o=>o.OldOaHuWaiId); }else{ r = r.OrderByDescending(o=>o.OldOaHuWaiId); } } } m.RecordCount = r.Count(); if (c.pagesize.HasValue) { int page = c.page ?? 1; int pageCount = m.RecordCount / c.pagesize.Value; if (m.RecordCount % c.pagesize.Value > 0) { pageCount++; } int skip = (page - 1) * c.pagesize.Value; if (skip > 0) { r = r.Skip(skip); } r = r.Take(c.pagesize.Value); } m.Data = r.ToList(); return m; }
partial void AfterGetData(LigerGridModel gm, SalesTeamCriteria c, PagedModel<SalesTeam> pm);
partial void AfterBuildGridModel(LigerGridModel gm, SalesTeamCriteria c, PagedModel<SalesTeam> pm);
partial void AfterBuildGridModel(LigerGridModel gm, SchoolAdCriteria c, PagedModel<SchoolAd> pm);
partial void AfterGetData(LigerGridModel gm, SchoolAdCriteria c, PagedModel<SchoolAd> pm);
partial void AfterGetData(LigerGridModel gm, StudentChangeClazzLogCriteria c, PagedModel<StudentChangeClazzLog> pm);