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