public AnexGRIDResponde Listar(AnexGRID grid, int usuario_id) { try { using (var ctx = new ProyectoContext()) { ctx.Configuration.LazyLoadingEnabled = false; grid.Inicializar(); var query = ctx.Habilidad.Where(x => x.usuario_id == usuario_id); if (grid.columna == "id") { query = grid.columna_orden == "DESC" ? query.OrderByDescending(x => x.id) : query.OrderBy(x => x.id); } if (grid.columna == "nombre") { query = grid.columna_orden == "DESC" ? query.OrderByDescending(x => x.nombre) : query.OrderBy(x => x.nombre); } if (grid.columna == "dominio") { query = grid.columna_orden == "DESC" ? query.OrderByDescending(x => x.dominio) : query.OrderBy(x => x.dominio); } var habilidades = query.Skip(grid.pagina).Take(grid.limite).ToList(); var total = query.Count(); grid.SetData(habilidades, total); } } catch (Exception E) { throw; } return(grid.responde()); }
//metodo para listar public AnexGRIDResponde Listar(AnexGRID agrid) { try { using (var ctx = new MaximaContext()) { ctx.Configuration.LazyLoadingEnabled = false; agrid.Inicializar(); var query = ctx.tbl_vacacion.Where(x => x.id_vacacion > 0).Where(x => x.estado == "A"); // Ordenar if (agrid.columna == "id") { query = agrid.columna_orden == "DESC" ? query.OrderByDescending(x => x.id_vacacion) : query.OrderBy(x => x.id_vacacion); } if (agrid.columna == "nombre") { query = agrid.columna_orden == "DESC" ? query.OrderByDescending(x => x.nombre) : query.OrderBy(x => x.nombre); } if (agrid.columna == "fecha_inicio") { query = agrid.columna_orden == "DESC" ? query.OrderByDescending(x => x.fecha_inicio) : query.OrderBy(x => x.fecha_inicio); } if (agrid.columna == "fecha_fin") { query = agrid.columna_orden == "DESC" ? query.OrderByDescending(x => x.fecha_fin) : query.OrderBy(x => x.fecha_fin); } if (agrid.columna == "detalle") { query = agrid.columna_orden == "DESC" ? query.OrderByDescending(x => x.detalle) : query.OrderBy(x => x.detalle); } var vacaciones = query.Skip(agrid.pagina) .Take(agrid.limite) .ToList(); var total = query.Count(); agrid.SetData(vacaciones, total); } } catch (Exception e) { throw new Exception(e.Message); } return(agrid.responde()); }
public AnexGRIDResponde Listar(AnexGRID grid) { try { using (var ctx = new ProyectoContext()) { grid.Inicializar(); var query = ctx.Usuario.Where(x => x.idusuario > 0); // Ordenamiento if (grid.columna == "id") { query = grid.columna_orden == "DESC" ? query.OrderByDescending(x => x.idusuario) : query.OrderBy(x => x.idusuario); } if (grid.columna == "nombre") { query = grid.columna_orden == "DESC" ? query.OrderByDescending(x => x.nombre) : query.OrderBy(x => x.nombre); } if (grid.columna == "correo") { query = grid.columna_orden == "DESC" ? query.OrderByDescending(x => x.correo) : query.OrderBy(x => x.correo); } if (grid.columna == "cuenta") { query = grid.columna_orden == "DESC" ? query.OrderByDescending(x => x.cuenta) : query.OrderBy(x => x.cuenta); } if (grid.columna == "razonsocial") { query = grid.columna_orden == "DESC" ? query.OrderByDescending(x => x.razonsocial) : query.OrderBy(x => x.razonsocial); } if (grid.columna == "activo") { query = grid.columna_orden == "DESC" ? query.OrderByDescending(x => x.activo) : query.OrderBy(x => x.activo); } var usuario = query.Skip(grid.pagina) .Take(grid.limite) .ToList(); var total = query.Count(); grid.SetData( from a in usuario select new { a.idusuario, a.nombre, a.correo, a.cuenta, a.razonsocial, a.activo }, total ); } } catch (Exception E) { throw; } return(grid.responde()); }
public AnexGRIDResponde Listar(AnexGRID grid) { try { using (var ctx = new ProyectoContext()) { grid.Inicializar(); var query = ctx.Orden.Where(x => x.idorden > 0); // Ordenamiento if (grid.columna == "idorden") { query = grid.columna_orden == "DESC" ? query.OrderByDescending(x => x.idorden) : query.OrderBy(x => x.idorden); } if (grid.columna == "codigoorden") { query = grid.columna_orden == "DESC" ? query.OrderByDescending(x => x.codigoorden) : query.OrderBy(x => x.codigoorden); } if (grid.columna == "empresaorden") { query = grid.columna_orden == "DESC" ? query.OrderByDescending(x => x.empresaorden) : query.OrderBy(x => x.empresaorden); } if (grid.columna == "clienteorden") { query = grid.columna_orden == "DESC" ? query.OrderByDescending(x => x.clienteorden) : query.OrderBy(x => x.clienteorden); } if (grid.columna == "ordenservicio") { query = grid.columna_orden == "DESC" ? query.OrderByDescending(x => x.ordenservicio) : query.OrderBy(x => x.ordenservicio); } if (grid.columna == "produccion") { query = grid.columna_orden == "DESC" ? query.OrderByDescending(x => x.produccion) : query.OrderBy(x => x.produccion); } if (grid.columna == "estadoorden") { query = grid.columna_orden == "DESC" ? query.OrderByDescending(x => x.estadoorden) : query.OrderBy(x => x.estadoorden); } var orden = query.Skip(grid.pagina) .Take(grid.limite) .ToList(); var total = query.Count(); grid.SetData( from a in orden select new { a.idorden, a.codigoorden, a.empresaorden, a.clienteorden, a.ordenservicio, a.produccion, a.estadoorden }, total ); } } catch (Exception E) { throw; } return(grid.responde()); }
public AnexGRIDResponde Listar(AnexGRID grid) { try { using (var ctx = new TestContext()) { grid.Inicializar(); var query = ctx.Alumno.Where(x => x.id > 0); // Ordenamiento if (grid.columna == "id") { query = grid.columna_orden == "DESC" ? query.OrderByDescending(x => x.id) : query.OrderBy(x => x.id); } if (grid.columna == "Nombre") { query = grid.columna_orden == "DESC" ? query.OrderByDescending(x => x.Nombre) : query.OrderBy(x => x.Nombre); } if (grid.columna == "Sexo") { query = grid.columna_orden == "DESC" ? query.OrderByDescending(x => x.Sexo) : query.OrderBy(x => x.Sexo); } if (grid.columna == "FechaNacimiento") { query = grid.columna_orden == "DESC" ? query.OrderByDescending(x => x.FechaNacimiento) : query.OrderBy(x => x.FechaNacimiento); } var alumnos = query.Skip(grid.pagina) .Take(grid.limite) .ToList(); var total = query.Count(); grid.SetData( from a in alumnos select new { a.id, Nombre = a.Nombre + " " + a.Apellido, a.Sexo, a.FechaNacimiento }, total ); } } catch (Exception E) { throw; } return(grid.responde()); }
//metodo para listar public AnexGRIDResponde Listar(AnexGRID agrid) { try { using (var ctx = new MaximaContext()) { agrid.Inicializar(); ctx.Configuration.LazyLoadingEnabled = false; var query = ( from r in ctx.tbl_registro_pago join e in ctx.tbl_empleado on r.id_empleado equals e.id_empleado join p in ctx.tbl_planilla on r.num_planilla equals p.num_planilla where r.id_registro_pago > 0 && r.estado == "A" && p.cerrada == 0 select new { id_registro_pago = r.id_registro_pago, id_empleado = r.id_empleado, num_planilla = r.num_planilla, total = r.total, empleado = e.primer_nombre + " " + e.primer_apellido, faltante = r.faltante, cierre = r.cierre }).Select(x => new DtoRegistro { id_empleado = x.id_empleado, id_registro_pago = x.id_registro_pago, empleado = x.empleado, total = x.total, faltante = x.faltante, cierre = x.cierre, num_planilla = x.num_planilla }); // Ordenar if (agrid.columna == "id") { query = agrid.columna_orden == "DESC" ? query.OrderByDescending(x => x.id_registro_pago) : query.OrderBy(x => x.id_registro_pago); } if (agrid.columna == "num_planilla") { query = agrid.columna_orden == "DESC" ? query.OrderByDescending(x => x.num_planilla) : query.OrderBy(x => x.num_planilla); } if (agrid.columna == "id_empleado") { query = agrid.columna_orden == "DESC" ? query.OrderByDescending(x => x.id_empleado) : query.OrderBy(x => x.id_empleado); } if (agrid.columna == "faltante") { query = agrid.columna_orden == "DESC" ? query.OrderByDescending(x => x.faltante) : query.OrderBy(x => x.faltante); } if (agrid.columna == "total") { query = agrid.columna_orden == "DESC" ? query.OrderByDescending(x => x.total) : query.OrderBy(x => x.total); } if (agrid.columna == "empleado") { query = agrid.columna_orden == "DESC" ? query.OrderByDescending(x => x.empleado) : query.OrderBy(x => x.empleado); } if (agrid.columna == "cierre") { query = agrid.columna_orden == "DESC" ? query.OrderByDescending(x => x.cierre) : query.OrderBy(x => x.cierre); } var registros = query.Skip(agrid.pagina) .Take(agrid.limite) .ToList(); var total = query.Count(); agrid.SetData(registros, total); } } catch (Exception e) { throw new Exception(e.Message); } return(agrid.responde()); }
public AnexGRIDResponde Listar(AnexGRID grid, int tipo, int Usuario_id) { try { using (var ctx = new ProyectoContext()) { ctx.Configuration.LazyLoadingEnabled = false; grid.Inicializar(); var query = ctx.Experiencia.Where(x => x.Tipo == tipo).Where(x => x.Usuario_id == Usuario_id); // Ordenamiento if (grid.columna == "id") { query = grid.columna_orden == "DESC" ? query.OrderByDescending(x => x.id) : query.OrderBy(x => x.id); } if (grid.columna == "Nombre") { query = grid.columna_orden == "DESC" ? query.OrderByDescending(x => x.Nombre) : query.OrderBy(x => x.Nombre); } if (grid.columna == "Titulo") { query = grid.columna_orden == "DESC" ? query.OrderByDescending(x => x.Titulo) : query.OrderBy(x => x.Titulo); } if (grid.columna == "Desde") { query = grid.columna_orden == "DESC" ? query.OrderByDescending(x => x.Desde) : query.OrderBy(x => x.Desde); } if (grid.columna == "Hasta") { query = grid.columna_orden == "DESC" ? query.OrderByDescending(x => x.Hasta) : query.OrderBy(x => x.id); } // id, Nombre, Titulo, Desde, Hasta var experiencias = query.Skip(grid.pagina) .Take(grid.limite) .ToList(); var total = query.Count(); grid.SetData(experiencias, total); } } catch (Exception E) { throw; } return(grid.responde()); }
//CRUD public AnexGRIDResponde Listar(AnexGRID grid) { try { using (var ctx = new ProyectoContext()) { grid.Inicializar(); var query = ctx.CatalogoPrecios.Where(x => x.idCatalogoPrecio > 0); // Ordenamiento if (grid.columna == "id") { query = grid.columna_orden == "DESC" ? query.OrderByDescending(x => x.idCatalogoPrecio) : query.OrderBy(x => x.idCatalogoPrecio); } if (grid.columna == "nombre") { query = grid.columna_orden == "DESC" ? query.OrderByDescending(x => x.nombre) : query.OrderBy(x => x.nombre); } if (grid.columna == "caracteristicas") { query = grid.columna_orden == "DESC" ? query.OrderByDescending(x => x.caracteristicas) : query.OrderBy(x => x.caracteristicas); } if (grid.columna == "precio") { query = grid.columna_orden == "DESC" ? query.OrderByDescending(x => x.precio) : query.OrderBy(x => x.precio); } if (grid.columna == "otros") { query = grid.columna_orden == "DESC" ? query.OrderByDescending(x => x.otros) : query.OrderBy(x => x.otros); } if (grid.columna == "empresa") { query = grid.columna_orden == "DESC" ? query.OrderByDescending(x => x.empresa) : query.OrderBy(x => x.empresa); } if (grid.columna == "estado") { query = grid.columna_orden == "DESC" ? query.OrderByDescending(x => x.estado) : query.OrderBy(x => x.estado); } var catalogoprecios = query.Skip(grid.pagina) .Take(grid.limite) .ToList(); var total = query.Count(); grid.SetData( from a in catalogoprecios select new { a.idCatalogoPrecio, a.nombre, a.caracteristicas, a.precio, a.otros, a.empresa, a.estado, }, total ); } } catch (Exception E) { throw; } return(grid.responde()); }
//metodo para listar public AnexGRIDResponde Listar(AnexGRID agrid) { try { using (var ctx = new MaximaContext()) { ctx.Configuration.LazyLoadingEnabled = false; agrid.Inicializar(); var query = ctx.tbl_empleado.Where(x => x.id_empleado > 0).Where(x => x.estado == "A"); // Ordenar if (agrid.columna == "id") { query = agrid.columna_orden == "DESC" ? query.OrderByDescending(x => x.id_empleado) : query.OrderBy(x => x.id_empleado); } if (agrid.columna == "primer_nombre") { query = agrid.columna_orden == "DESC" ? query.OrderByDescending(x => x.primer_nombre) : query.OrderBy(x => x.primer_nombre); } if (agrid.columna == "segundo_nombre") { query = agrid.columna_orden == "DESC" ? query.OrderByDescending(x => x.segundo_nombre) : query.OrderBy(x => x.segundo_nombre); } if (agrid.columna == "primer_apellido") { query = agrid.columna_orden == "DESC" ? query.OrderByDescending(x => x.primer_apellido) : query.OrderBy(x => x.primer_apellido); } if (agrid.columna == "segundo_apellido") { query = agrid.columna_orden == "DESC" ? query.OrderByDescending(x => x.segundo_nombre) : query.OrderBy(x => x.segundo_apellido); } if (agrid.columna == "telefono") { query = agrid.columna_orden == "DESC" ? query.OrderByDescending(x => x.telefono) : query.OrderBy(x => x.telefono); } if (agrid.columna == "direccion") { query = agrid.columna_orden == "DESC" ? query.OrderByDescending(x => x.direccion) : query.OrderBy(x => x.direccion); } if (agrid.columna == "dpi") { query = agrid.columna_orden == "DESC" ? query.OrderByDescending(x => x.dpi) : query.OrderBy(x => x.dpi); } if (agrid.columna == "correo") { query = agrid.columna_orden == "DESC" ? query.OrderByDescending(x => x.correo) : query.OrderBy(x => x.correo); } var empleados = query.Skip(agrid.pagina) .Take(agrid.limite) .ToList(); var total = query.Count(); agrid.SetData(empleados, total); } } catch (Exception e) { throw new Exception(e.Message); } return(agrid.responde()); }
public AnexGRIDResponde Listar(AnexGRID grid) { try { using (var ctx = new ProyectoContext()) { grid.Inicializar(); var query = ctx.Empresa.Where(x => x.idempresa > 0); // Ordenamiento if (grid.columna == "id") { query = grid.columna_orden == "DESC" ? query.OrderByDescending(x => x.idempresa) : query.OrderBy(x => x.idempresa); } if (grid.columna == "nmempresa") { query = grid.columna_orden == "DESC" ? query.OrderByDescending(x => x.nmempresa) : query.OrderBy(x => x.nmempresa); } if (grid.columna == "rucempresa") { query = grid.columna_orden == "DESC" ? query.OrderByDescending(x => x.rucempresa) : query.OrderBy(x => x.rucempresa); } if (grid.columna == "estadoempresa") { query = grid.columna_orden == "DESC" ? query.OrderByDescending(x => x.estadoempresa) : query.OrderBy(x => x.estadoempresa); } var empresa = query.Skip(grid.pagina) .Take(grid.limite) .ToList(); var total = query.Count(); grid.SetData( from a in empresa select new { a.idempresa, a.nmempresa, a.rucempresa, a.estadoempresa }, total ); } } catch (Exception E) { throw; } return(grid.responde()); }
public AnexGRIDResponde Listar(AnexGRID grid, int usuario_id) { try { using (var ctx = new ProyectoContext()) { ctx.Configuration.LazyLoadingEnabled = false; grid.Inicializar(); //var query = ctx.Testimonio.Where(x => x.Usuario_id == usuario_id); var query = ctx.Testimonio .Join( ctx.TablaDato, t => t.estado.ToString(), d => (d.Valor), (t, d) => new { t = t, d = d } ) .Where(x => ((x.t.Usuario_id == usuario_id) && (x.d.Relacion == "testimonioestado"))) .Select( x => new { id = x.t.id, Usuario_id = x.t.Usuario_id, IP = x.t.IP, Nombre = x.t.Nombre, Comentario = x.t.Comentario, Fecha = x.t.Fecha, Estado = x.d.Descripcion } ); //id, Usuario_id, IP, Nombre, Comentario, Fecha if (grid.columna == "id") { query = grid.columna_orden == "DESC" ? query.OrderByDescending(x => x.id) : query.OrderBy(x => x.id); } if (grid.columna == "Nombre") { query = grid.columna_orden == "DESC" ? query.OrderByDescending(x => x.Nombre) : query.OrderBy(x => x.Nombre); } if (grid.columna == "Estado") { query = grid.columna_orden == "DESC" ? query.OrderByDescending(x => x.Estado) : query.OrderBy(x => x.Estado); } if (grid.columna == "IP") { query = grid.columna_orden == "DESC" ? query.OrderByDescending(x => x.IP) : query.OrderBy(x => x.IP); } if (grid.columna == "Fecha") { query = grid.columna_orden == "DESC" ? query.OrderByDescending(x => x.Fecha) : query.OrderBy(x => x.Fecha); } var habilidad = query.Skip(grid.pagina).Take(grid.limite).ToList(); var total = query.Count(); grid.SetData(habilidad, total); } } catch (Exception e) { throw e; } return(grid.responde()); }
//metodo para listar public AnexGRIDResponde Listar(AnexGRID agrid) { try { using (var ctx = new MaximaContext()) { agrid.Inicializar(); var query = ctx.tbl_cargo.Where(x => x.id_cargo > 0).Where(x => x.estado == "A"); // Ordenar if (agrid.columna == "id") { query = agrid.columna_orden == "DESC" ? query.OrderByDescending(x => x.id_cargo) : query.OrderBy(x => x.id_cargo); } if (agrid.columna == "nombre_cargo") { query = agrid.columna_orden == "DESC" ? query.OrderByDescending(x => x.nombre_cargo) : query.OrderBy(x => x.nombre_cargo); } if (agrid.columna == "descripcion_cargo") { query = agrid.columna_orden == "DESC" ? query.OrderByDescending(x => x.descripcion_cargo) : query.OrderBy(x => x.descripcion_cargo); } if (agrid.columna == "sueldo") { query = agrid.columna_orden == "DESC" ? query.OrderByDescending(x => x.sueldo) : query.OrderBy(x => x.sueldo); } var cargos = query.Skip(agrid.pagina) .Take(agrid.limite) .ToList(); agrid.SetData( from e in cargos select new { e.id_cargo, e.nombre_cargo, e.descripcion_cargo, e.sueldo } , query.Count() ); } } catch (Exception e) { throw new Exception(e.Message); } return(agrid.responde()); }
public AnexGRIDResponde Listar(AnexGRID grid) { try { using (var ctx = new ProyectoContext()) { grid.Inicializar(); var query = ctx.Sucursal.Where(x => x.idsucursal > 0); if (grid.columna == "id") { query = grid.columna_orden == "DESC" ? query.OrderByDescending(x => x.idsucursal) : query.OrderBy(x => x.idsucursal); } if (grid.columna == "codigosuc") { query = grid.columna_orden == "DESC" ? query.OrderByDescending(x => x.codigosuc) : query.OrderBy(x => x.codigosuc); } if (grid.columna == "nmsucursal") { query = grid.columna_orden == "DESC" ? query.OrderByDescending(x => x.nmsucursal) : query.OrderBy(x => x.nmsucursal); } if (grid.columna == "otroscu") { query = grid.columna_orden == "DESC" ? query.OrderByDescending(x => x.otroscu) : query.OrderBy(x => x.otroscu); } if (grid.columna == "estadosuc") { query = grid.columna_orden == "DESC" ? query.OrderByDescending(x => x.estadosuc) : query.OrderBy(x => x.estadosuc); } var sucursal = query.Skip(grid.pagina) .Take(grid.limite) .ToList(); var total = query.Count(); grid.SetData( from a in sucursal select new { a.idsucursal, a.codigosuc, a.nmsucursal, a.otroscu, a.estadosuc }, total ); } } catch (Exception E) { throw; } return(grid.responde()); }
public AnexGRIDResponde ListarPolizas(AnexGRID grid) { try { using (var ctx = new SeguroContext()) { //inicializa la grilla grid.Inicializar(); var query = ctx.tb_PolizaDetalle .Include(x => x.tb_Poliza.tb_Estado) .Include(x => x.tb_Poliza.tb_Cobertura) .Include(x => x.tb_Poliza.tb_Moneda) .Include(x => x.tb_Persona) .Where(x => x.IdDetallePoliza > 0 && x.IdRelacionFamiliar == 1); // Ordenamiento if (grid.columna == "IdPoliza") { query = grid.columna_orden == "DESC" ? query.OrderByDescending(x => x.IdPoliza) : query.OrderBy(x => x.IdPoliza); } if (grid.columna == "NumeroPoliza") { query = grid.columna_orden == "DESC" ? query.OrderByDescending(x => x.tb_Poliza.NumeroPoliza) : query.OrderBy(x => x.tb_Poliza.NumeroPoliza); } if (grid.columna == "NombrePersona") { query = grid.columna_orden == "DESC" ? query.OrderByDescending(x => x.tb_Persona.Nombre + ' ' + x.tb_Persona.Apellido) : query.OrderBy(x => x.tb_Persona.Nombre + ' ' + x.tb_Persona.Apellido); } // Filtros foreach (var f in grid.filtros) { if (f.columna == "NumeroPoliza") { query = query.Where(x => x.tb_Poliza.NumeroPoliza.ToString().StartsWith(f.valor)); } if (f.columna == "Nombre") { query = query.Where(x => x.tb_Persona.Nombre.Contains(f.valor)); } //query = query.Where(x => (x.tb_Persona.Nombre + ' ' + x.tb_Persona.Apellido).Contains(f.valor)); if (f.columna == "Apellido") { query = query.Where(x => x.tb_Persona.Apellido.Contains(f.valor)); } if (f.columna == "DescripcionEstado") { query = query.Where(x => x.tb_Poliza.tb_Estado.DescripcionEstado.StartsWith(f.valor)); } } //Skip(grid.pagina)-->se indica desde que página se inicia la paginacion //Take(grid.limite)-->se indica la cantidad de registros a mostrar var polizas = query.Skip(grid.pagina) .Take(grid.limite) .ToList(); //Se obtiene la cantidad de registros que hay en la tabla, se usa en la paginacion var total = query.Count(); // grid.SetData( from p in polizas select new { p.IdPoliza, p.tb_Poliza.NumeroPoliza, p.tb_Persona.Nombre, p.tb_Persona.Apellido, p.tb_Persona.CUSSPP, p.tb_Poliza.tb_Cobertura.DescripcionCobertura, p.tb_Poliza.tb_Moneda.DescripcionMoneda, p.tb_Poliza.FechaNotificacion, p.tb_Poliza.tb_Estado.DescripcionEstado }, total ); } } catch (Exception e) { ELog.save(this, e); //throw; } return(grid.responde()); }
public AnexGRIDResponde Listar(AnexGRID agrid) { try { using (var ctx = new DatabaseContext()) { agrid.Inicializar(); var query = ctx.Empleado.Include(x => x.Profesion) .Where(x => x.id > 0); // Ordenar if (agrid.columna == "id") { query = agrid.columna_orden == "DESC" ? query.OrderByDescending(x => x.id) : query.OrderBy(x => x.id); } if (agrid.columna == "Nombre") { query = agrid.columna_orden == "DESC" ? query.OrderByDescending(x => x.Nombre) : query.OrderBy(x => x.Nombre); } if (agrid.columna == "Correo") { query = agrid.columna_orden == "DESC" ? query.OrderByDescending(x => x.Correo) : query.OrderBy(x => x.Correo); } if (agrid.columna == "Sueldo") { query = agrid.columna_orden == "DESC" ? query.OrderByDescending(x => x.Sueldo) : query.OrderBy(x => x.Sueldo); } if (agrid.columna == "FechaRegistro") { query = agrid.columna_orden == "DESC" ? query.OrderByDescending(x => x.FechaRegistro) : query.OrderBy(x => x.FechaRegistro); } if (agrid.columna == "Profesion_id") { query = agrid.columna_orden == "DESC" ? query.OrderByDescending(x => x.Profesion_id) : query.OrderBy(x => x.Profesion.Nombre); } // Filtrar foreach (var f in agrid.filtros) { if (f.columna == "Nombre") { query = query.Where(x => x.Nombre.StartsWith(f.valor)); } if (f.columna == "Correo") { query = query.Where(x => x.Correo.StartsWith(f.valor)); } if (f.columna == "Profesion_id" && f.valor != "") { query = query.Where(x => x.Profesion_id.ToString() == f.valor); } if (f.columna == "Sexo" && f.valor != "") { query = query.Where(x => x.Sexo.ToString() == f.valor); } } var empleados = query.Skip(agrid.pagina) .Take(agrid.limite) .ToList(); agrid.SetData( from e in empleados select new { e.id, e.Nombre, e.Correo, e.Sueldo, e.Apellido, e.Sexo, e.FechaNacimiento, e.FechaRegistro, Profesion = new { id = e.Profesion.id, Nombre = e.Profesion.Nombre } } , query.Count() ); } } catch (Exception e) { throw new Exception(e.Message); } return(agrid.responde()); }
public AnexGRIDResponde ListarPeriodos(AnexGRID grid) { try { using (var ctx = new SeguroContext()) { //inicializa la grilla grid.Inicializar(); var query = ctx.tb_Periodo .Include(x => x.tb_Estado) .Where(x => x.IdPeriodo > 0); // Ordenamiento if (grid.columna == "IdPeriodo") { query = grid.columna_orden == "DESC" ? query.OrderByDescending(x => x.IdPeriodo) : query.OrderBy(x => x.IdPeriodo); } if (grid.columna == "Anio") { query = grid.columna_orden == "DESC" ? query.OrderByDescending(x => x.Anio) : query.OrderBy(x => x.Anio); } if (grid.columna == "Mes") { query = grid.columna_orden == "DESC" ? query.OrderByDescending(x => x.Mes) : query.OrderBy(x => x.Mes); } if (grid.columna == "DescripcionEstado") { query = grid.columna_orden == "DESC" ? query.OrderByDescending(x => x.tb_Estado.DescripcionEstado) : query.OrderBy(x => x.tb_Estado.DescripcionEstado); } // Filtros foreach (var f in grid.filtros) { if (f.columna == "Anio") { query = query.Where(x => x.Anio.StartsWith(f.valor)); } if (f.columna == "Mes") { query = query.Where(x => x.Mes.StartsWith(f.valor)); } if (f.columna == "DescripcionEstado") { query = query.Where(x => x.tb_Estado.DescripcionEstado.StartsWith(f.valor)); } } //Skip(grid.pagina)-->se indica desde que página se inicia la paginacion //Take(grid.limite)-->se indica la cantidad de registros a mostrar var periodos = query.Skip(grid.pagina) .Take(grid.limite) .ToList(); //Se obtiene la cantidad de registros que hay en la tabla, se usa en la paginacion var total = query.Count(); // grid.SetData( from p in periodos select new { p.IdPeriodo, p.Anio, p.Mes, p.tb_Estado.DescripcionEstado }, total ); } } catch (Exception e) { ELog.save(this, e); //throw; } return(grid.responde()); }