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