public IActionResult Index(int page = 1) { //SelectList brands = new SelectList(_serviceManager.Brands.GetBrandsList(), "Id", "Name"); //ViewBag.Brands = brands; //SelectList tags = new SelectList(_serviceManager.Tags.GetTagsList(), "Id", "Name"); //ViewBag.Tags = tags; var _clothes = _serviceManager.Clothes.GetClothesList(); var model = PagingList.Create(_clothes, 9, page); //var _clothes = _serviceManager.Clothes.GetClothesList(); return(View(model)); }
public IEnumerable <TEntity> Paging(int pageSize, int pageIndex, string sortExpression) { var qry = _dbContext.Set <TEntity>().AsNoTracking() .AsQueryable(); qry = qry.Where( p => p.IsDelete == false ); var model = PagingList.Create( qry, pageSize, pageIndex, sortExpression, sortExpression); return(model); }
public List <Book> GetBooksAll() { var qry = _context.Books.OrderBy(p => p.BookName); foreach (Book a in qry) { _context.Entry(a).Navigation("Author").Load(); } PagingList <Book> BooksList; BooksList = PagingList.Create(qry, _context.Books.Count() + 1, 1); return(BooksList.ToList()); }
public async Task <ActionResult <IEnumerable <Log> > > GetLogs(int page) { var l = await _log.RetriveLogs(); var final = l.AsQueryable <Log>().OrderByDescending(p => p.Date); var result = PagingList.Create <Log>(final, 20, page); if (result.Count == 0) { return(Ok("End of Logs")); } return(Ok(result)); }
public List <Arena> GetArenasAll() { var qry = _context.Arenas.OrderBy(p => p.ArenaName); foreach (Arena a in qry) { _context.Entry(a).Navigation("City").Load(); } PagingList <Arena> arenasList; arenasList = PagingList.Create(qry, _context.Arenas.Count() + 1, 1); return(arenasList.ToList()); }
private async Task <CommonDashboardViewModel> GetUserDashboardData(int plannedIndex, int pendingIndex, int overbudgetIndex, int finishedIndex) { var query = await _repo.GetActivitiesAsync(filterByUser : true); var pendingQuery = query.AsQueryable() .Where(x => x.PrcCompleted != 100 && x.ActualEndDate == null) .OrderBy(x => x.ActualEndDate); var pending = PagingList.Create(qry: pendingQuery, pageSize: 2, pageIndex: pendingIndex); pending.PageParameterName = "pendingIndex"; var overbudgetQuery = query.AsQueryable() .Where(x => x.Budget < x.Spent) .OrderBy(x => x.Spent); var overbudget = PagingList.Create(overbudgetQuery, 2, overbudgetIndex); overbudget.PageParameterName = "overbudgetIndex"; var plannedQuery = query.AsQueryable() .Where(x => x.StartDate < DateTime.Today) .OrderBy(x => x.StartDate); var planned = PagingList.Create(plannedQuery, 2, plannedIndex); overbudget.PageParameterName = "plannedIndex"; var finishedQuery = query.AsQueryable() .Where(x => x.PrcCompleted == 100) .OrderBy(x => x.ActualEndDate); var finished = PagingList.Create(finishedQuery, 2, finishedIndex); overbudget.PageParameterName = "finishedIndex"; return(new CommonDashboardViewModel { UserDashboardViewModel = new UserDashboardViewModel { PendingActivities = pending, PlannedActivities = planned, OverBudgetActivities = overbudget, FinishedActivities = finished } }); }
public IActionResult Index(string sortOrder, string searchString, int pageindex = 1) { //if (string.IsNullOrEmpty(sortOrder)) //{ // ViewData["sortName"] = "name_desc"; //}else //{ // ViewData["sortName"] = ""; //} ViewData["sortName"] = string.IsNullOrEmpty(sortOrder)? "name_desc":" "; ViewData["sortByDate"] = sortOrder == "Date" ? "date_desc":"Date"; ViewData["currentFilter"] = searchString; //if(sortOrder == "Date") //{ // ViewData["sortByDate"] = "date_desc"; //} //else //{ // ViewData["sortByDate"] = "Date"; //} var students = _studentRepository.GetAll(); if (!string.IsNullOrEmpty(searchString)) { students = students.Where(s => s.FirstName.ToLower().Contains(searchString.ToLower()) || s.LastName.ToLower().Contains(searchString.ToLower())); } switch (sortOrder) { case "name_desc": students = students.OrderByDescending(s => s.FirstName); break; case "Date": students = students.OrderBy(s => s.EnrollmentDate); break; case "date_desc": students = students.OrderByDescending(s => s.EnrollmentDate); break; default: students = students.OrderBy(s => s.FirstName); break; } var model = PagingList.Create(students, pageSize: 2, pageIndex: pageindex); return(View(model)); }
public ViewResult ViewDataBase(string filter, int page = 1, string sortExpression = "OrderTime") { var data = _repository.Orders.AsNoTracking().AsQueryable(); if (!string.IsNullOrWhiteSpace(filter)) { data = data.Where(d => d.Name.Contains(filter)); } var model = PagingList.Create(data, viewOrderDbPages, page, sortExpression, "OrderTime"); model.RouteValue = new RouteValueDictionary { { "filter", filter } }; model.Action = "ViewDataBase"; return(View(model)); }
public async Task <IActionResult> Index(string Msg, int page = 1, int row = 10) { if (Msg == "Success") { ViewBag.Alert = "عضویت با موفقیت انجام شد."; } if (Msg == "SendEmailSuccess") { ViewBag.Alert = "ارسال ایمیل به کاربران با موفقیت انجام شد."; } var PagingModel = PagingList.Create(await _userManager.GetAllUsersWithRolesAsync(), row, page); return(View(PagingModel)); }
public async Task <ResponseEntity> LayDanhSachPhimTheoNgay(string maNhom = "GP01", string tenPhim = "", int soTrang = 1, int soPhanTuTrenTrang = 10, string tuNgay = "", string denNgay = "") { DateTime dtTuNgay = DateTimes.Now(); DateTime dtDenNgay = DateTimes.Now(); if (tuNgay != "") { try { dtTuNgay = DateTimes.ConvertDate(tuNgay); } catch (Exception ex) { return(new ResponseEntity(StatusCodeConstants.BAD_REQUEST, "Ngày không hợp lệ", MessageConstant.MESSAGE_ERROR_400)); //return await tbl.TBLoi(ThongBaoLoi.Loi500, "Ngày không hợp lệ, Ngày có định dạng dd/MM/yyyy !"); } } if (denNgay != "") { try { dtDenNgay = DateTimes.ConvertDate(denNgay); } catch (Exception ex) { //return new ResponseEntity(StatusCodeConstants.OK, "Ngày không hợp lệ", MessageConstant.MESSAGE_SUCCESS_200); return(new ResponseEntity(StatusCodeConstants.BAD_REQUEST, "Ngày không hợp lệ, Ngày có định dạng dd/MM/yyyy !", MessageConstant.MESSAGE_ERROR_400)); } } bool ckNhom = db.Nhom.Any(n => n.MaNhom == maNhom); if (!ckNhom) { var response = await tbl.TBLoi(ThongBaoLoi.Loi500, "Nhóm người dùng không hợp lệ!"); return(new ResponseEntity(StatusCodeConstants.BAD_REQUEST, "Nhóm người dùng không hợp lệ", MessageConstant.MESSAGE_ERROR_400));; } tenPhim = LoaiBoKyTu.bestLower(tenPhim); IEnumerable <PhimVM> lstResult = db.Phim.Where(n => n.BiDanh.Contains(tenPhim) && n.MaNhom == maNhom && n.DaXoa != true && n.NgayKhoiChieu.Value >= dtTuNgay.Date && n.NgayKhoiChieu.Value <= dtDenNgay.Date).Select(n => new PhimVM { MaPhim = n.MaPhim, BiDanh = n.BiDanh, DanhGia = n.DanhGia, HinhAnh = DomainImage + n.HinhAnh, MaNhom = n.MaNhom, MoTa = n.MoTa, TenPhim = n.TenPhim, Trailer = n.Trailer, NgayKhoiChieu = n.NgayKhoiChieu, Hot = n.Hot, DangChieu = n.DangChieu, SapChieu = n.SapChieu }); var model = PagingList.Create(lstResult, soPhanTuTrenTrang, soTrang); return(new ResponseEntity(StatusCodeConstants.OK, model, MessageConstant.MESSAGE_SUCCESS_200)); }
/* **************************************************************************************************************** */ /* Anasayfa Yazilim Isleri Sayfasi */ public IActionResult Isler(int sayfa = 1, [FromQuery] string sehir = null, [FromQuery] string anahtar = null, [FromQuery] string kategori = null, [FromQuery] string type = null, [FromQuery] string minPrice = null, [FromQuery] string maxPrice = null, [FromQuery] string minTime = null, [FromQuery] string maxTime = null) { List <Job> jobs = _jobService.GetAllJobs(); AnasayfaIslerViewModel anasayfaIslerViewModel = new AnasayfaIslerViewModel(); if (anahtar != null) { anahtar = anahtar.ToLower(); ViewBag.JobSearchKey = anahtar; jobs = jobs.Where(x => x.Title.ToLower().Contains(anahtar)).ToList(); } if (sehir != null) { if (sehir != "Bütün Konumlar") { ViewBag.JobSearchCity = sehir; jobs = jobs.Where(x => x.Location == sehir).ToList(); } } if (kategori != null) { if (kategori != "Bütün İlanlar") { ViewBag.JobSearchCategory = kategori; jobs = jobs.Where(x => x.Category == kategori).ToList(); } } if (minTime != null && maxTime != null) { ViewBag.JobSearchMinTime = minTime; ViewBag.JobSearchMaxTime = maxTime; jobs = jobs.Where(x => x.Time >= Convert.ToInt32(minTime) && x.Time <= Convert.ToInt32(maxTime)).ToList(); } if (minPrice != null && maxPrice != null) { ViewBag.JobSearchMinPrice = minPrice; ViewBag.JobSearchMaxPrice = maxPrice; jobs = jobs.Where(x => x.Price >= Convert.ToInt32(minPrice) && x.Price <= Convert.ToInt32(maxPrice)).ToList(); } anasayfaIslerViewModel.Jobs = PagingList.Create(jobs, 10, sayfa); anasayfaIslerViewModel.MyPagingModel = PagingList.Create(jobs, 10, sayfa); return(View(anasayfaIslerViewModel)); }
public async Task <IActionResult> SearchJobsAsync(string provinceName = "", string jobCategory = "", string searchString = "", int page = 1) { if (provinceName == null) { provinceName = ""; } if (jobCategory == null) { jobCategory = ""; } if (searchString == null) { searchString = ""; } TempData["province"] = provinceName; TempData["searchstring"] = searchString; TempData["jobcategory"] = jobCategory; var searchkeywords = searchString.Trim().TrimEnd(',').Split(','); var jobs = _IJobsRepository.FindJobs(provinceName.ToLower(), jobCategory.Trim(), searchkeywords) .OrderByDescending(x => Guid.NewGuid()); var viewModel = jobs.Select(job => new JobDetailsViewModel() { JobID = job.Id, JobTitle = job.JobTitle, PostDate = job.PostDate.ToString("yyyy-M-dd"), CompanyName = job.Client.CompanyName, WorkingHours = job.Workinghour, Salary_Hourly = job.Salary_Hourly, Salary_Monthly = job.Salary_Monthly, ProvinceName = job.PostalCode.Province.Name, ContractType = job.ContractType_Text, Town = job.PostalCode.Town, CompanyImageUrl = job.Client.CompanyImages.Count == 0 ? job.BusinessStream.CategoryImageUrl : job.Client.CompanyImages.OrderByDescending(x => x.Id).FirstOrDefault().ImagePath, //CompanyImageUrl = _clientRepository.GetComapnyImage(job.Client.Id).ImagePath ?? job.BusinessStream.CategoryImageUrl, Town_En = job.PostalCode.Town_En, CityName_En = job.PostalCode.CityName_En }).ToList().AsEnumerable().OrderByDescending(x => Guid.NewGuid()); var model = PagingList.Create(viewModel, 10, page, "SearchJobsAsync"); model.ProvinceName = provinceName; model.SearchString = searchString; model.JobCategory = jobCategory; ViewData["TotalJobsFound"] = model.TotalRecordCount; return(View(model)); }
public ViewResult ViewDataBase(string filter, int page = 1, string sortExpression = "OrderTime") //Получаем данные из БД для просмотра в представлении. { int pageSize = 2; // количество объектов на странице. var data = _repository.Orders.AsNoTracking().AsQueryable(); if (!string.IsNullOrWhiteSpace(filter)) { data = data.Where(d => d.Name.Contains(filter)); } var model = PagingList.Create(data, pageSize, page, sortExpression, "OrderTime"); model.RouteValue = new RouteValueDictionary { { "filter", filter } }; model.Action = "ViewDataBase"; return(View(model)); }
public List <Artist> GetArtists([FromRoute] int page = 1) { var qry = _context.Artists.OrderBy(p => p.ArtistName); PagingList <Artist> artistList; if (page != 0) { artistList = PagingList.Create(qry, StringsPerPage, page); } else { artistList = PagingList.Create(qry, _context.Artists.Count() + 1, 1); } return(artistList.ToList()); }
public IActionResult Index(string Msg, int page = 1, int row = 5, string SortExpression = "Title", string title = "") { title = string.IsNullOrEmpty(title) ? "" : title; if (Msg != null) { ViewBag.Msg = "در ثبت اطلاعات خطایی رخ داده است"; } List <int> Rows = new List <int> { 1, 2, 5, 10, 15, 20, 50, 100 }; ViewBag.NumOfRow = (page - 1) * row + 1; ViewBag.RowID = new SelectList(Rows, row); ViewBag.Search = title; //var PagingModel = PagingList.Create(_repository.GetAllBooks(title, "", "", "", "", "", ""), row, page, SortExpression, "Title"); var PagingModel = PagingList.Create(_unitofwork.BooksRepository.GetAllBooks(title, "", "", "", "", "", ""), row, page, SortExpression, "Title"); PagingModel.RouteValue = new RouteValueDictionary { { "row", row }, { "title", title } }; //ViewBag.Categories = _repository.GetAllCategories(); //ViewBag.LanguageID = new SelectList(_context.Languages, "LanguageName", "LanguageName"); //ViewBag.PublisherID = new SelectList(_context.Publishers, "PublisherName", "PublisherName"); //ViewBag.AuthorID = new SelectList(_context.Authors.Select(t => new AuthorList { AuthorID = t.AuthorID, NameFamily = t.FirstName + " " + t.LastName }), "NameFamily", "NameFamily"); //ViewBag.TranslatorID = new SelectList(_context.Translator.Select(t => new TranslatorList { TranslatorID = t.TranslatorID, NameFamily = t.Name + " " + t.Family }), "NameFamily", "NameFamily"); ///////////////////////////UnitOfWork////////////////////// //ViewBag.Categories = _repository.GetAllCategories(); ViewBag.Categories = _unitofwork.BooksRepository.GetAllCategories(); ViewBag.LanguageID = new SelectList(_unitofwork.BaseRepository <Language>().FindAll(), "LanguageName", "LanguageName"); ViewBag.PublisherID = new SelectList(_unitofwork.BaseRepository <Publisher>().FindAll(), "PublisherName", "PublisherName"); ViewBag.AuthorID = new SelectList(_unitofwork.BaseRepository <Author>().FindAll().Select(t => new AuthorList { AuthorID = t.AuthorID, NameFamily = t.FirstName + " " + t.LastName }), "NameFamily", "NameFamily"); ViewBag.TranslatorID = new SelectList(_unitofwork.BaseRepository <Translator>().FindAll().Select(t => new TranslatorList { TranslatorID = t.TranslatorID, NameFamily = t.Name + " " + t.Family }), "NameFamily", "NameFamily"); return(View(PagingModel)); }
public List <Library> GetLibrarys([FromRoute] int page = 1) { var qry = _context.Librarys.OrderBy(p => p.LibraryName); PagingList <Library> LibraryList; if (page != 0) { LibraryList = PagingList.Create(qry, StringsPerPage, page); } else { LibraryList = PagingList.Create(qry, _context.Librarys.Count() + 1, 1); } return(LibraryList.ToList()); }
public List <Student> GetStudents([FromRoute] int page = 1) { var qry = _context.Students.OrderBy(p => p.StudentName); PagingList <Student> StudentList; if (page != 0) { StudentList = PagingList.Create(qry, StringsPerPage, page); } else { StudentList = PagingList.Create(qry, _context.Students.Count() + 1, 1); } return(StudentList.ToList()); }
public IActionResult Index(int?orderBy, int page = 1) { if (orderBy != null) { filter = orderBy; } var narudzbe = GenerisiNarudzbe(); IQueryable <NarudzbaCollection> query; // Prikaz svih narudzbi if (filter == 0) { query = narudzbe .OrderByDescending(k => k.narudzba.DatumKreiranjaNarudzbe); } // Prikaz aktivnih narudzbi else if (filter == 1) { query = narudzbe.Where(k => k.narudzba.Aktivna == true) .OrderByDescending(k => k.narudzba.DatumKreiranjaNarudzbe); } // Prikaz neaktivnih narudzbi else if (filter == 2) { query = narudzbe.Where(k => !k.narudzba.Aktivna); } // Prikaz aktivnih nepotvrđenih narudzbi else if (filter == 3) { query = narudzbe.Where(k => k.narudzba.Aktivna && !k.narudzba.Potvrdjena); } else { query = narudzbe.OrderBy(k => k.narudzba.Id); } var model = PagingList.Create(query, 5, page); TempData["feelter"] = filter; return(View(model)); }
public IActionResult BancasMaisVendem(int page = 1) { List <VendasBancaRelatorio> VendaRelatorio = new List <VendasBancaRelatorio>(); List <VendasBancaRelatorio> ListaFinal = new List <VendasBancaRelatorio>(); List <Venda> listaDoForeach = new List <Venda>(); var bancasNome = _context.Vendas.Include(b => b.Bancas).Select(b => b.Bancas.NomeBanca).Distinct().ToList(); var vendas = _context.Vendas.Include(v => v.Clientes).Include(v => v.Status).Include(v => v.Bancas).ToList(); foreach (var item in vendas) { item.ValorVenda = item.ValorVenda.Substring(2).Replace('.', ','); listaDoForeach.Add(item); } int posicao = 1; foreach (var data in bancasNome) { var soma = vendas.Where(v => v.Bancas.NomeBanca.ToLower() == data.ToLower()).Sum(v => Convert.ToDouble(v.ValorVenda)); VendasBancaRelatorio vbr = new VendasBancaRelatorio(); vbr.QuantidadeDeVendas = vendas.Where(v => v.Bancas.NomeBanca.ToLower() == data.ToLower()).Count(); vbr.NomeBanca = data; vbr.ValorTotalVenda = "R$" + soma; vbr.Bairro = vendas.Where(v => v.Bancas.NomeBanca.ToLower() == data.ToLower()).Select(v => v.Bancas.Bairro).FirstOrDefault(); VendaRelatorio.Add(vbr); } VendaRelatorio = VendaRelatorio.OrderByDescending(b => b.QuantidadeDeVendas).ToList(); foreach (var obj in VendaRelatorio) { obj.Posicao = posicao + "º"; ListaFinal.Add(obj); posicao++; } ListaParaCsvBanca = ListaFinal; ViewBag.bancas = ListaFinal; ViewBag.ceps = _context.Vendas.Include(b => b.Bancas).Select(b => b.Bancas.CEPbanca).Distinct().ToList(); ViewBag.countProd = ListaFinal.Select(p => p.NomeBanca).Distinct().Count(); var query = ListaFinal.AsQueryable().OrderByDescending(b => b.QuantidadeDeVendas); var model = PagingList.Create(query, 500, page); model.Action = "BancasMaisVendem"; ViewBag.ordenado = "Ordenado por: Quantidade vendida"; return(View(model)); }
public IActionResult Index(string filter, int page = 1, string sortExpression = "Name") { var qry = _context.Employees.AsNoTracking().AsQueryable(); if (!string.IsNullOrWhiteSpace(filter)) { qry = qry.Where(d => d.Name.Contains(filter)); } var model = PagingList.Create(qry, pages, page, sortExpression, "Name"); model.RouteValue = new RouteValueDictionary { { "filter", filter } }; model.Action = "Index"; return(View(model)); //return View(_context.GetAllEmployees().ToList()); }
public ViewResult AllProducts(string filter, int page = 1, string sortExpression = "Name") { var qry = _unitOfWork.Product.GetAll(includeProperties: "Category"); if (!string.IsNullOrWhiteSpace(filter)) { qry = qry.Where(p => p.Name.Contains(filter)); } var model = PagingList.Create(qry, productInPage, page, sortExpression, "Name"); model.RouteValue = new RouteValueDictionary { { "filter", filter } }; model.Action = "AllProducts"; return(View(model)); }
public async Task <IActionResult> Index(string numeroChamado, int page = 1) { if (!string.IsNullOrEmpty(numeroChamado)) { var chamado = _mapper.Map <IEnumerable <ChamadoViewModel> >(await _chamadoRepository.Buscar(c => c.NumeroChamado.Equals(numeroChamado))); var chamadoViewModel = PagingList.Create(chamado, 1, page); return(View(chamadoViewModel)); } var chamados = _mapper.Map <IEnumerable <ChamadoViewModel> >(await _chamadoRepository.ObterChamadosFornecedores()); var chamadosViewModel = PagingList.Create(chamados, 10, page); ViewBag.numeroChamado = numeroChamado; chamadosViewModel.Action = "lista-de-chamados"; return(View(chamadosViewModel)); }
public async Task <PagingList <T> > PartialList <T>(IDictionary <string, string> paramList, ActionListOption <T> options, Func <IDictionary <string, string>, ActionListOption <T>, Task <IEnumerable <T> > > listFunction, params object[] extraParameters) where T : CoreDTO { if (options == null) { options = new ActionListOption <T>(); } ViewBag.FormparamList = string.Join("&", paramList.Select(x => string.Format("{0}={1}", x.Key, x.Value))); paramList = paramList .Where(x => !string.IsNullOrEmpty(x.Value) && x.Key != "__RequestVerificationToken" && x.Key != "X-Requested-With" && !x.Key.StartsWith("pg_")) .ToDictionary(x => x.Key, x => x.Value); var orderBy = options.pg_SortExpression ?? ListSortExpressionDefault; PagingList <T> pagingList; IEnumerable <T> list; if (listFunction != null) { list = await listFunction(paramList, options); } else { list = await _auditService.DataService.GetDtoAsync <T>(orderBy, parameters : paramList, skip : (options.pg_Page - 1) *PageRowCount.Value, take : PageRowCount.Value, extraParameters : extraParameters); } pagingList = PagingList.Create(list, PageRowCount.Value, options.pg_Page, orderBy, "Id", x => (x as IPagingCounted)?.TotalRecordCount, options.pg_PartialViewName ?? "List", true); return(pagingList); }
public IActionResult ItemMaisVende(string buscaName, int page = 1) { if (buscaName == "1") { ListaParaCsvItem = ListaParaCsvItem.OrderByDescending(b => b.Quantidade).ToList(); var query = ListaParaCsvItem.AsQueryable().OrderByDescending(b => b.Quantidade); ViewBag.countProd = ListaParaCsvItem.Select(p => p.NomeProduto).Count(); var model = PagingList.Create(query, 500, page); model.Action = "ItemMaisVende"; ViewBag.ordenado = "Ordenado por: Quantidade vendida"; return(View(model)); } else if (buscaName == "2") { List <ItemMaisVende> vbr = new List <ItemMaisVende>(); foreach (var x in ListaParaCsvItem) { x.ValorTotalGerado = x.ValorTotalGerado.Substring(2); vbr.Add(x); } ListaParaCsvItem = vbr.OrderByDescending(v => Convert.ToDouble(v.ValorTotalGerado)).ToList(); foreach (var y in ListaParaCsvItem) { y.ValorTotalGerado = "R$" + y.ValorTotalGerado; } ViewBag.countProd = ListaParaCsvItem.Select(p => p.NomeProduto).Count(); var query = ListaParaCsvItem.AsQueryable(); var model = PagingList.Create(query, 500, page); model.Action = "ItemMaisVende"; ViewBag.ordenado = "Ordenado por: Valor total"; return(View(model)); } else { TempData["msgSucesso"] = "Erro na sua solicitação, favor tentar novamente!"; return(RedirectToAction("ItemMaisVende")); } }
public IActionResult Index(int page = 1) { KorisnickiNalog korisnik = HttpContext.GetLogiraniKorisnik(); if (korisnik == null) { TempData["error_poruka"] = "Nemate pravo pristupa"; return(RedirectToAction("Index", "Autentifikacija")); } var query = db.regioni.Select(x => new RegionIndexVM { Id = x.RegionId, Naziv = x.Naziv }).AsNoTracking().OrderBy(x => x.Naziv); var model = PagingList.Create(query, 5, page); return(View("Prikazi", model)); }
public IActionResult Index(string filter, int page = 1) { List <GroupModelView> list = new List <GroupModelView>(); if (!string.IsNullOrWhiteSpace(filter)) { db.Group.Where(s => s.Name.Contains(filter)).Include(s => s.BelongTo).ToList().ForEach(x => { list.Add((GroupModelView)x); }); } else { db.Group.Include(s => s.BelongTo).ToList().ForEach(x => { list.Add((GroupModelView)x); }); } var model = PagingList.Create(list, 10, page); model.RouteValue = new RouteValueDictionary { { "filter", filter } }; return(View(model)); }
public async Task <List <Post> > GetPostsByCategory(string category, int pageindex) { var posts = await _context.Posts .Where(p => p.Tags.Contains(category)) .Select(p => new Post() { Id = p.Id, Title = p.Title, PubDate = p.PubDate, IsPublished = p.IsPublished, Slug = p.Slug, Tags = p.Tags, Excerpt = p.Excerpt }).ToListAsync(); var filteredPosts = PagingList.Create(posts, 50, pageindex); return(filteredPosts); }
public IActionResult Index(string searchBy, string search, string sortExpression = "PrikaznoIme", int page = 1) { if (search == null) { ViewData["prazno"] = "nema igraca"; } var userId = db.Users.Where(d => d.Email == User.Identity.Name).FirstOrDefault().Id; ViewBag.userId = userId; if (searchBy == "JacaRuka") { List <IgracVM> igraci = db.Igraci.Select(x => new IgracVM { ID = x.ID, BrojPosjetaNaProfil = x.BrojPosjetaNaProfil, JacaRuka = x.JacaRuka, PrikaznoIme = x.PrikaznoIme, ProfileImagePath = x.ProfileImagePath, Visina = x.Visina, ELO = x.ELO }).Where(x => x.JacaRuka == search || search == null).ToList(); var igraciPaged = PagingList.Create(igraci, 4, page, sortExpression, "ID"); ViewBag.igraci = igraci; return(View(igraciPaged)); } else { List <IgracVM> igraci = db.Igraci.Select(x => new IgracVM { ID = x.ID, BrojPosjetaNaProfil = x.BrojPosjetaNaProfil, JacaRuka = x.JacaRuka, PrikaznoIme = x.PrikaznoIme, ProfileImagePath = x.ProfileImagePath, Visina = x.Visina, ELO = x.ELO }).Where(x => x.PrikaznoIme.Contains(search) || search == null).OrderBy(x => x.PrikaznoIme).ToList(); var igraciPaged = PagingList.Create(igraci, 4, page, sortExpression, "ID"); ViewBag.igraci = igraci; return(View(igraciPaged)); } }
public IActionResult AddSimCardToGroup(Guid id, string filter, int page = 1) { List <GroupSimCardsModelView> list = new List <GroupSimCardsModelView>(); if (!string.IsNullOrWhiteSpace(filter)) { list.Clear(); foreach (var item in db.SimCard.Where(s => s.SimCardNumber.Contains(filter))) { if (!db.GroupSimCards.Include(s => s.SimCard).Any(s => s.SimCardId.Equals(item.Id) && s.GroupId.Equals(id))) { GroupSimCardsModelView mv = new GroupSimCardsModelView(); mv.SimCardId = item.Id; mv.SimCard = item; mv.GroupId = id; list.Add(mv); } } } else { foreach (var item in db.SimCard) { if (!db.GroupSimCards.Any(s => s.SimCardId.Equals(item.Id) && s.GroupId.Equals(id))) { GroupSimCardsModelView mv = new GroupSimCardsModelView(); mv.SimCardId = item.Id; mv.SimCard = item; mv.GroupId = id; list.Add(mv); } } } TempData["PageIndex"] = page; var model = PagingList.Create(list, 10, page); model.Action = "AddSimCardToGroup"; model.RouteValue = new RouteValueDictionary { { "filter", filter } }; return(View(model)); }
public ActionResult Index(string filter, int page = 1) { var countries = GetCountries(); var pageSize = 15; if (!String.IsNullOrEmpty(filter)) { countries = countries.Where(s => s.Name.Contains(filter) || s.Region.Contains(filter) || s.Subregion.Contains(filter)); } var model = PagingList.Create(countries, pageSize, page); model.RouteValue = new RouteValueDictionary { { "filter", filter } }; return(View(model)); }