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