protected virtual PaginatorViewModel SetupPaginator(int?current_page, int?rows_per_page, int totalRecCount, int recCount)
{
PaginatorViewModel paginator = new PaginatorViewModel();
paginator.TotalRows = totalRecCount;
paginator.DivToRefresh = typeof(T).Name + "List";
if (rows_per_page.HasValue)
{
paginator.RowsPerPage = rows_per_page.Value;
}
else
{
paginator.RowsPerPage = 10;
}
paginator.TotalPages = (int)Math.Ceiling(paginator.TotalRows / (float)paginator.RowsPerPage);
if (!current_page.HasValue)
{
paginator.CurrentPage = 0;
}
else if (current_page == -1)
{
paginator.CurrentPage = 0;
}
else
{
if (current_page >= paginator.TotalPages)
{
current_page = paginator.TotalPages - 1;
}
paginator.CurrentPage = (int)current_page;
}
paginator.RowsShown = recCount;
return(paginator);
}
public EmployeeDictionaryViewModel(IShell shell, EmployeeService service, PaginatorViewModel paginatorViewModel)
: base(paginatorViewModel)
{
_shell = shell;
_service = service;
this.PaginatorViewModel.RegisterPaginable(this, true);
}
public IViewComponentResult Invoke(BasePaginatorCore paginator)
{
var numMaxPages = paginator.Ratio * 2 + 1;
var model = new PaginatorViewModel
{
BasePaginatorCore = paginator,
QueryString = HttpContext.Request.QueryString,
FirstPage = 1,
LastPage = paginator.TotalPages > numMaxPages ? numMaxPages : paginator.TotalPages
};
if (paginator.PageNumber > paginator.Ratio + 1)
{
model.FirstPage = paginator.PageNumber - paginator.Ratio;
if (paginator.TotalPages > paginator.PageNumber + paginator.Ratio)
{
model.LastPage = paginator.PageNumber + paginator.Ratio;
}
else
{
model.LastPage = paginator.TotalPages;
}
}
return(View(model));
}
// GET: MovieCatalogo
public ActionResult Index(int page = 1, string busqueda = null, string genero = null, int pageSize = 3)
{
MovieRepository movieRepository = new MovieRepository(context);
GeneroRepository generoRepository = new GeneroRepository(context);
var includes = new Expression <Func <Movie, object> >[] { s => s.Generos };
int totalDePaginas;
int totalDeFilas;
ICollection <Movie> movies;
movies = movieRepository.QueryPageByNombreAndGeneroIncluding(busqueda, genero, includes, out totalDePaginas, out totalDeFilas, "Nombre", page - 1, pageSize);
ViewBag.Busqueda = busqueda;
ViewBag.Genero = genero;
ViewBag.ListaGeneros = generoRepository.Query(x => x.Activo == true).Select(g => g.Nombre).Where(g => g != genero).ToList();
var paginador = new PaginatorViewModel <ThumbnailMovieViewModel>();
paginador.Page = page;
paginador.PageSize = pageSize;
paginador.Results = MapHelper.Map <ICollection <ThumbnailMovieViewModel> >(movies);
paginador.TotalPages = totalDePaginas;
paginador.TotalRows = totalDeFilas;
return(View(paginador));
}
public DictionaryScreen(IEventAggregator aggregator, IModel model, PaginatorViewModel paginator,
TGrid entityGrid, string paginatorLabel = "Объектов") :
base(aggregator, model)
{
this.EntityGrid = entityGrid;
this.Paginator = paginator;
this.Paginator.ElementsName = paginatorLabel;
this.Paginator.RegisterPaginable(entityGrid, false);
}
public ClientEditorViewModel(IEventAggregator aggregator, IModel model, OrderDataGridViewModel grid,
PaginatorViewModel paginator) : base(
aggregator, model, model.Clients, "клиента")
{
InfoChecked = true;
OrderDataGrid = grid;
Paginator = paginator;
Paginator.ElementsName = "Заказов";
Paginator.RegisterPaginable(OrderDataGrid);
}
public CardDictionaryViewModel(IShell shell, EmployeeService employeeService,
CardService cardService, PaginatorViewModel paginatorViewModel)
: base(paginatorViewModel)
{
_shell = shell;
_employeeService = employeeService;
_service = cardService;
this.EmployeeComboBoxViewModel =
new EmployeeComboBoxViewModel(employeeService,
x => this.FilterDefinition.EmployeeId = x?.Id, false)
{
IsEnabled = false
};
this.PaginatorViewModel.RegisterPaginable(this, true);
}
public ActionResult Index(int?idg, string nombre = "", int paginado = 40)
{
if (paginado <= 0)
{
paginado = 40;
}
//paginacion
int totalPages = 0;
int totalRows = 0;
int pageSize = paginado;
int page = Request.QueryString["page"] == null ? 1 : int.Parse(Request.QueryString["page"]);
MovieRepository repository = new MovieRepository(context);
GeneroRepository generoRepository = new GeneroRepository(context);
var genero = generoRepository.Query(g => g.Eliminado == false);
Expression <Func <Movie, bool> > expr = m => m.estado == EEstatusMedia.VISIBLE && m.nombre.Contains(nombre);
if (idg != null)
{
expr = expr.And(x => x.Generos.Any(y => y.Id == idg));
}
var lst = repository.QueryPage(expr, out totalPages, out totalRows, "Nombre", page - 1, pageSize);
var models = MapHelper.Map <IEnumerable <MovieViewModel> >(lst);
var generos = MapHelper.Map <ICollection <GeneroViewModel> >(generoRepository.GetAll());
var model = new PaginatorViewModel <MovieViewModel>
{
Page = page,
TotalPages = totalPages,
TotalRows = totalRows,
PageSize = pageSize,
Results = models
};
ViewBag.ListaGenero = GeneroList(genero);
ViewBag.Nombre = nombre;
ViewBag.Idg = idg + "";
ViewBag.Paginado = paginado + "";
return(View(model));
}
public EmployeeEditorViewModel(IEventAggregator aggregator, IModel model, OrderDataGridViewModel grid,
PaginatorViewModel paginator)
: base(aggregator, model, model.Employees, "работника")
{
this.InfoChecked = true;
this.OrderDataGrid = grid;
this.Paginator = paginator;
paginator.ElementsName = "Заказов";
paginator.RegisterPaginable(OrderDataGrid, false);
this.SubsidiarySearch = new SubsidiarySearchViewModel(model);
this.SubsidiarySearch.EntityChanged +=
OnSubsidiarySearchOnEntityChanged;
this.CarSearch = new CarSearchViewModel(model);
this.CarSearch.EntityChanged += x => this.Model.Employees.SetCar(this.Entity, x);
}
protected virtual PaginatorViewModel SetupPaginator(ref IEnumerable <T> collection, int?current_page, int?rows_per_page)
{
//FoxSecDBContext db = new FoxSecDBContext();
//var totalRows = db.FSCameras.Count(x => x.Id != null);
//int rcount = Convert.ToInt32(totalRows);
PaginatorViewModel paginator = new PaginatorViewModel();
paginator.TotalRows = collection.Count();
//paginator.TotalRows = rcount;
paginator.DivToRefresh = typeof(T).Name + "List";
if (rows_per_page.HasValue)
{
paginator.RowsPerPage = rows_per_page.Value;
}
else
{
paginator.RowsPerPage = 10;
}
paginator.TotalPages = (int)Math.Ceiling(paginator.TotalRows / (float)paginator.RowsPerPage);
if (!current_page.HasValue)
{
paginator.CurrentPage = 0;
collection = collection.Skip(0).Take(paginator.RowsPerPage);
}
else if (current_page == -1)
{
paginator.CurrentPage = 0;
}
else
{
if (current_page >= paginator.TotalPages)
{
current_page = paginator.TotalPages - 1;
}
paginator.CurrentPage = (int)current_page;
collection = collection.Skip(paginator.CurrentPage * paginator.RowsPerPage).Take(paginator.RowsPerPage);
}
paginator.RowsShown = collection.Count();
return(paginator);
}
public OrderEditorViewModel(IEventAggregator aggregator, IModel model, ClothDataGridViewModel clothGrid,
PaginatorViewModel paginator)
: base(aggregator, model, model.Orders, "заказа")
{
aggregator.Subscribe(this);
this.Entity.CreationDate = DateTime.Now;
this.Entity.ExecutionDate = DateTime.Now.AddDays(1);
this.ClothInstancesGrid = clothGrid;
this.ClothInstancesGrid.Order = this.Entity;
this.ClothInstancesGrid.StateChanged += () => NotifyOfPropertyChange(nameof(Price));
this.Paginator = paginator;
this.Paginator.ElementsName = "Вещей";
this.Paginator.RegisterPaginable(this.ClothInstancesGrid);
this.ClientCombo = new ClientSearchViewModel(model);
this.ClientCombo.EntityChanged += OnEntityChanged;
}
public AnalyticsViewModel(IEventAggregator aggregator, IModel model, PaginatorViewModel paginator,
OrderDataGridViewModel orderGrid, SubsidiaryGridViewModel subsidiaryGrid, ClothKindTreeViewModel clothKindGrid)
: base(aggregator, model)
{
_orderGrid = orderGrid;
_orderGrid.IsDisplaySubtotals = true;
_orderGrid.DisplaySelectionColumn = false;
_subsidiaryGrid = subsidiaryGrid;
_subsidiaryGrid.IsDisplaySubtotals = true;
_subsidiaryGrid.DisplaySelectionColumn = false;
_clothKindGrid = clothKindGrid;
_clothKindGrid.IsDisplaySubtotals = true;
_clothKindGrid.DisplaySelectionColumn = false;
Paginator = paginator;
ChangeEntity(_orderGrid, "Заказов");
this.IsGridChecked = true;
}
// GET: Usuario
public ActionResult Index()
{
//paginacion
int totalPages = 0;
int totalRows = 0;
int pageSize = 2;
int page = Request.QueryString["page"] == null ? 1 : int.Parse(Request.QueryString["page"]);
UsuarioRepository repository = new UsuarioRepository(context);
var lst = repository.QueryPage(null, out totalPages, out totalRows, "Nombre", page - 1, pageSize);
var models = MapHelper.Map <IEnumerable <UsuarioViewModel> >(lst);
var model = new PaginatorViewModel <UsuarioViewModel>
{
Page = page,
TotalPages = totalPages,
TotalRows = totalRows,
PageSize = pageSize,
Results = models
};
return(View(model));
}
// GET: Favorito
public ActionResult Index(int page = 1, string busqueda = null, string genero = null, int pageSize = 3)
{
MediaViewModel media = new MediaViewModel();
MediaRepository mediaRepo = new MediaRepository(context);
FavoritoRepository repository = new FavoritoRepository(context);
var includes = new Expression <Func <Media, object> >[] { s => s.Generos };
var lst = repository.Query(x => x.media.EstadosMedia == EEstatusMedia.VISIBLE).OrderBy(x => x.media.Nombre);
int totalDePaginas;
int totalDeFilas;
ICollection <Media> movies;
movies = mediaRepo.QueryPageByNombreAndGeneroIncluding(busqueda, genero, includes, out totalDePaginas, out totalDeFilas, "Nombre", page - 1, pageSize);
ViewBag.Busqueda = busqueda;
ViewBag.Genero = genero;
var paginador = new PaginatorViewModel <MediaViewModel>();
paginador.Page = page;
paginador.PageSize = pageSize;
paginador.Results = MapHelper.Map <ICollection <MediaViewModel> >(movies);
paginador.TotalPages = totalDePaginas;
paginador.TotalRows = totalDeFilas;
return(View(paginador));
}
public ActionResult Index(int page = 1, string busqueda = null, int pageSize = 100)
{
MovieRepository movieRepository = new MovieRepository(context);
GeneroRepository generoRepository = new GeneroRepository(context);
var includes = new Expression <Func <Movie, object> >[] { s => s.Generos };
int totalDePaginas;
int totalDeFilas;
ICollection <Movie> movies;
movies = movieRepository.QueryPageByNombre(busqueda, includes, out totalDePaginas, out totalDeFilas, "Nombre", page - 1, pageSize);
ViewBag.Busqueda = busqueda;
var paginador = new PaginatorViewModel <ThumbnailMovieViewModel>();
paginador.Page = page;
paginador.PageSize = pageSize;
paginador.Results = MapHelper.Map <ICollection <ThumbnailMovieViewModel> >(movies);
paginador.TotalPages = totalDePaginas;
paginador.TotalRows = totalDeFilas;
return(View(paginador));
}
public DictionaryViewModelBase(PaginatorViewModel paginatorViewModel)
{
PaginatorViewModel = paginatorViewModel;
}
public OrderDictionaryViewModel(IEventAggregator aggregator, IModel model, PaginatorViewModel paginator,
OrderDataGridViewModel entityGrid) : base(aggregator, model, paginator, entityGrid, "Заказов")
{
this.EventAggregator.Subscribe(this);
}
public EmployeeDictionaryViewModel(IEventAggregator aggregator, IModel model, PaginatorViewModel paginator,
EmployeeDataGridViewModel entityGrid)
: base(aggregator, model, paginator, entityGrid, "Работников")
{
}
public Response <PaginatorViewModel <User> > PaginatorFilter(PaginatorViewModel <User> paginatorViewModel)
{
throw new NotImplementedException();
}
public ClothKindDictionaryViewModel(IEventAggregator aggregator, IModel model, PaginatorViewModel paginator, ClothKindTreeViewModel entityGrid) :
base(aggregator, model, paginator, entityGrid, "Видов одежды")
{
this.EntityGrid.IsTreeMode = true;
}
public CarDictionaryViewModel(IEventAggregator aggregator, IModel model, PaginatorViewModel paginator, CarDataGridViewModel entityGrid) :
base(aggregator, model, paginator, entityGrid, "Машин")
{
}
public ClientDictionaryViewModel(IEventAggregator aggregator, IModel model, PaginatorViewModel paginator,
ClientDataGridViewModel entityGrid) :
base(aggregator, model, paginator, entityGrid, " лиентов")
{
}
public DiscountSystemViewModel(IEventAggregator aggregator, IModel model, PaginatorViewModel paginator, DiscountGridViewModel entityGrid)
: base(aggregator, model, paginator, entityGrid, "Границ")
{
}
public ActionResult Index(int?idg, string nombre = "", int paginado = 40, string UserId = "")
{
if (paginado <= 0)
{
paginado = 40;
}
//paginacion
int totalPages = 0;
int totalRows = 0;
int pageSize = paginado;
int page = Request.QueryString["page"] == null ? 1 : int.Parse(Request.QueryString["page"]);
MediaRepository mediaRepo = new MediaRepository(context);
GeneroRepository generoRepository = new GeneroRepository(context);
UsuarioRepository userRepo = new UsuarioRepository(context);
FavoritoRepository favRepo = new FavoritoRepository(context);
var yo = userRepo.Query(u => u.IdentityId == UserId).FirstOrDefault();
var misFavoritos = favRepo.Query(f => f.usuarioId == yo.Id);
var genero = generoRepository.Query(g => g.Eliminado == false);
Expression <Func <Media, bool> > expr = m => m.estado == EEstatusMedia.VISIBLE;
int count = 0;
foreach (var item in misFavoritos)
{
if (count == 0)
{
expr = expr.And(m => m.id == item.mediaId);
count++;
}
else
{
expr = expr.Or(m => m.id == item.mediaId);
}
}
if (idg != null)
{
expr = expr.And(x => x.Generos.Any(y => y.Id == idg));
}
expr = expr.And(m => m.estado == EEstatusMedia.VISIBLE && m.nombre.Contains(nombre));
var lst = mediaRepo.QueryPage(expr, out totalPages, out totalRows, "Nombre", page - 1, pageSize);
var models = MapHelper.Map <IEnumerable <MediaViewModel> >(lst);
var model = new PaginatorViewModel <MediaViewModel>
{
Page = page,
TotalPages = totalPages,
TotalRows = totalRows,
PageSize = pageSize,
Results = models
};
ViewBag.ListaGenero = GeneroList(genero);
ViewBag.Nombre = nombre;
ViewBag.Idg = idg + "";
ViewBag.Paginado = paginado + "";
ViewBag.UserId = UserId;
ViewBag.numList = misFavoritos.Count();
return(View(model));
}
public SubsidiaryDictionaryViewModel(IEventAggregator aggregator, IModel model,
PaginatorViewModel paginator, SubsidiaryGridViewModel entityGrid)
: base(aggregator, model, paginator, entityGrid, "Филиалов")
{
}
