public TrvRepConceptos GetConcepto(int ID)
{
TrvRepConceptos c = new TrvRepConceptos();
try
{
using (ClusmextContext context = new ClusmextContext())
{
c = context.TrvRepConceptos.Include("Ca_Moneda").Where(x => x.IdTrvRepConceptos == ID).SingleOrDefault();
}
}
catch (Exception ex)
{
}
return(c);
}
public List <TrvReq> GetListTrvReq()
{
List <TrvReq> list = new List <TrvReq>();
try
{
using (ClusmextContext context = new ClusmextContext())
{
list = context.TrvReq.OrderByDescending(x => x.IdTrvReq).ToList();
}
}
catch (Exception ex)
{
}
return(list);
}
public List <Menu> ListarMenu()
{
var List = new List <Menu>();
try
{
using (ClusmextContext context = new ClusmextContext())
{
List = context.Menu.Include("Usuarios").Include("Grupos_Menu").ToList();
}
}
catch (Exception ex)
{
}
return(List);
}
public List <Menu> _Menu(int IdUserRol)
{
var List = new List <Menu>();
try
{
using (ClusmextContext context = new ClusmextContext())
{
List = context.Menu.Include("Grupos_Menu").Where(x => x.Id_Tipo_Usuario == IdUserRol && x.Activo == true && x.Controlador != null).ToList();
}
}
catch (Exception ex)
{
}
return(List);
}
public Usuarios ObtenerUsuario(int id)
{
Usuarios Exist = new Usuarios();
try
{
using (ClusmextContext context = new ClusmextContext())
{
Exist = context.Usuarios.Where(x => x.Id_Usuario == id).SingleOrDefault();
}
}
catch (Exception ex)
{
}
return(Exist);
}
public List <spSelDocumentosRPlancio_Result> ListDocumentos(int id)
{
List <spSelDocumentosRPlancio_Result> list = new List <spSelDocumentosRPlancio_Result>();
try
{
using (ClusmextContext context = new ClusmextContext())
{
list = context.spSelDocumentosRPlancio(id).ToList();
}
}
catch (Exception ex)
{
}
return(list);
}
public List <SEDocumentosServicios> GetAllDocs()
{
List <SEDocumentosServicios> list = new List <SEDocumentosServicios>();
try
{
using (ClusmextContext context = new ClusmextContext())
{
list = context.SEDocumentosServicios.ToList();
}
}
catch (Exception ex)
{
}
return(list);
}
public List <Manuales> ListManuales()
{
List <Manuales> list = new List <Manuales>();
try
{
using (ClusmextContext context = new ClusmextContext())
{
list = context.Manuales.Include("Usuarios").Include("Menu").Include("CA_Areas").Include("ManualesTipoUsuarios").ToList();
}
}
catch (Exception ex)
{
}
return(list);
}
public IEnumerable <Ca_Estado> DataSourceEstados(int id)
{
List <Ca_Estado> list = new List <Ca_Estado>();
try
{
using (ClusmextContext context = new ClusmextContext())
{
list = context.Ca_Estado.Where(x => x.Id_Pais == id && x.Activo == true).OrderBy(x => x.Estado).ToList();
}
}
catch (Exception ex)
{
}
return(list);
}
public List <Ca_Clabe> ListClabesEmpresa(int id)
{
List <Ca_Clabe> list = new List <Ca_Clabe>();
try
{
using (ClusmextContext context = new ClusmextContext())
{
list = context.Ca_Clabe.Include("Ca_Moneda").Include("Proyectos").Include("Ca_Bancos").Where(x => x.Id_Empresa == id).OrderBy(x => x.Ca_Bancos.Banco).ToList();
}
}
catch (Exception ex)
{
}
return(list);
}
public List <Empresas> ListarProveedores()
{
List <Empresas> list = new List <Empresas>();
try
{
using (ClusmextContext context = new ClusmextContext())
{
list = context.Empresas.Where(x => x.Id_Tipo_Empresa == 2).OrderBy(x => x.Razon_Social).ToList();
}
}
catch (Exception ex)
{
}
return(list);
}
public Pagos SelectNurc(int id)
{
Pagos nurc = new Pagos();
try
{
using (ClusmextContext context = new ClusmextContext())
{
nurc = context.Pagos.Where(x => x.Id_Pago == id).SingleOrDefault();
}
}
catch (Exception ex)
{
}
return(nurc);
}
public IEnumerable <Ca_Moneda> DataSourceMoendas()
{
List <Ca_Moneda> list = new List <Ca_Moneda>();
try
{
using (ClusmextContext context = new ClusmextContext())
{
list = context.Ca_Moneda.OrderBy(x => x.Moneda).ToList();
}
}
catch (Exception ex)
{
}
return(list);
}
public RConta ObtenerRconta(int id)
{
RConta item = new RConta();
try {
if (id == 0)
{
return(item);
}
using (ClusmextContext context = new ClusmextContext()) {
item = context.RConta.Where(x => x.IdRConta == id).SingleOrDefault();
}
} catch (Exception ex) {
}
return(item);
}
public List <CA_Areas> ListAreas()
{
List <CA_Areas> List = new List <CA_Areas>();
try
{
using (ClusmextContext context = new ClusmextContext())
{
List = context.CA_Areas.OrderBy(x => x.Nombre_Area).ToList();
}
}
catch (Exception ex)
{
}
return(List);
}
public Usuarios Login(string User, string Pass)
{
Usuarios Exist = new Usuarios();
try
{
using (ClusmextContext context = new ClusmextContext())
{
Exist = context.Usuarios.Where(x => x.Usuario == User && x.Pass == Pass).SingleOrDefault();
}
}
catch (Exception ex)
{
}
return(Exist);
}
/******************************************* ACTIVO FIJO **********************************************/
public List <Activo_Fijo> GetActivoFijo()
{
List <Activo_Fijo> list = new List <Activo_Fijo>();
try
{
using (ClusmextContext context = new ClusmextContext())
{
list = context.Activo_Fijo.Include("Empresas").Include("Ca_Condicion").Include("Ca_Marca").Include("Ca_Moneda").ToList();
}
}
catch (Exception ex)
{
}
return(list);
}
public List <spSel_Conceptos_Pago_Result> DataSourceConceptos(int id)
{
List <spSel_Conceptos_Pago_Result> list = new List <spSel_Conceptos_Pago_Result>();
try
{
using (ClusmextContext context = new ClusmextContext())
{
list = context.spSel_Conceptos_Pago(id).OrderBy(x => x.Conceptos).ToList();
}
}
catch (Exception ex)
{
}
return(list);
}
public List <SEDocumentosServicios> GetDocs(int id)
{
List <SEDocumentosServicios> list = new List <SEDocumentosServicios>();
try
{
using (ClusmextContext context = new ClusmextContext())
{
list = context.SEDocumentosServicios.Where(x => x.IdServicio == id).ToList();
}
}
catch (Exception ex)
{
}
return(list);
}
public List <spSelPagos_Captura_UsuarioI_Result> ListIngresosC(int id)
{
List <spSelPagos_Captura_UsuarioI_Result> list = new List <spSelPagos_Captura_UsuarioI_Result>();
try
{
using (ClusmextContext context = new ClusmextContext())
{
list = context.spSelPagos_Captura_UsuarioI(id).OrderByDescending(x => x.Id_Pago).ToList();
}
}
catch (Exception ex)
{
}
return(list);
}
public List <spSelDocumentos_Pago_Id_Result> DataSourceDocumentos(int id)
{
List <spSelDocumentos_Pago_Id_Result> list = new List <spSelDocumentos_Pago_Id_Result>();
try
{
using (ClusmextContext context = new ClusmextContext())
{
list = context.spSelDocumentos_Pago_Id(id).OrderByDescending(x => x.Nombre).ToList();
}
}
catch (Exception ex)
{
}
return(list);
}
public Ca_Pais ObtenerPais(int id)
{
Ca_Pais pais = new Ca_Pais();
try {
if (id == 0)
{
return(pais);
}
using (ClusmextContext context = new ClusmextContext()) {
pais = context.Ca_Pais.Where(x => x.Id_Pais == id).SingleOrDefault();
}
} catch (Exception ex) {
}
return(pais);
}
public List <Ca_Rubros> ListarRubros(int id)
{
List <Ca_Rubros> list = new List <Ca_Rubros>();
try
{
using (ClusmextContext context = new ClusmextContext())
{
list = context.Ca_Rubros.Where(x => x.Id_Institucion == id).OrderBy(x => x.Codigo).ToList();
}
}
catch (Exception ex)
{
}
return(list);
}
public IEnumerable <TContratos> DataSourceTipoContratos()
{
List <TContratos> Params = new List <TContratos>();
try {
using (ClusmextContext context = new ClusmextContext()) {
Params = context.Ca_Tipo_Contrato.OrderBy(x => x.Tipo_Contrato)
.Select(x => new TContratos {
Id = x.Id_Tipo_Contrato, NombreCompleto = x.Tipo_Contrato
}).ToList();
}
}
catch (Exception ex) {
}
return(Params);
}
public List <Ca_Tipo_Codole> ListarTipos()
{
List <Ca_Tipo_Codole> list = new List <Ca_Tipo_Codole>();
try
{
using (ClusmextContext context = new ClusmextContext())
{
list = context.Ca_Tipo_Codole.OrderBy(x => x.Tipo_Codole).ToList();
}
}
catch (Exception ex)
{
}
return(list);
}
public CA_Areas ObtenerArea(int id)
{
CA_Areas area = new CA_Areas();
try
{
using (ClusmextContext context = new ClusmextContext())
{
area = context.CA_Areas.Where(x => x.Id_CA_Area == id).SingleOrDefault();
}
}
catch (Exception)
{
}
return(area);
}
public IPagedList <spSelPagos_Procesados_Usuario_Result> ProcesadosUsuario(int id, int PageNumber, int PageSize, string search, string CurrentFilter)
{
List <spSelPagos_Procesados_Usuario_Result> list = new List <spSelPagos_Procesados_Usuario_Result>();
if (search != null)
{
PageNumber = 1;
}
else
{
search = CurrentFilter;
}
try
{
using (ClusmextContext context = new ClusmextContext())
{
list = context.spSelPagos_Procesados_Usuario(id).ToList();
if (!String.IsNullOrEmpty(search))
{
list = list.Where(x =>
x.Id_Pago.ToString().Contains(search) ||
x.Solicitado_por.Contains(search) ||
x.Estatus_Pago.Contains(search) ||
(x.F_Pago.HasValue ? x.F_Pago.Value.ToShortDateString() : "-1").Contains(search) ||
(x.Folio_Fiscal != null ? x.Folio_Fiscal : "").Contains(search) ||
x.Razon_Social.Contains(search) ||
(x.Proveedor != null ? x.Proveedor : "").Contains(search) ||
(x.Nombre_Proyecto != null ? x.Nombre_Proyecto : "").Contains(search) ||
(x.Codigo != null ? x.Codigo : "").Contains(search) ||
(x.Anticipo.HasValue ? "SI" : "NO").Contains(search) ||
(x.Importe_Total != null ? x.Importe_Total : 0).ToString().Contains(search) ||
x.Calculo_IVA.ToString().Contains(search) ||
x.Retenciones.ToString().Contains(search) ||
x.Otros.ToString().Contains(search) ||
x.ISR.ToString().Contains(search) ||
x.Total.ToString().Contains(search) ||
(x.Moneda != null ? x.Moneda : "").Contains(search) ||
(x.F_Alta.HasValue ? x.F_Alta.Value.ToShortDateString() : "-1").Contains(search) ||
x.Usuario.Contains(search)
).ToList();
}
}
}
catch (Exception ex) {
}
return(list.ToPagedList(PageNumber, PageSize));;
}
public Ca_CS ObtenerCS(int id)
{
Ca_CS cs = new Ca_CS();
try {
using (ClusmextContext context = new ClusmextContext()) {
cs = context.Ca_CS.Where(x => x.Id_CS == id).SingleOrDefault();
if (id == 0)
{
cs.Id_Usuario = -1;
}
}
}
catch (Exception ex) {
}
return(cs);
}
public RVinculaciones ObtenerVinculacion(int id)
{
RVinculaciones item = new RVinculaciones();
try {
if (id == 0)
{
return(item);
}
using (ClusmextContext context = new ClusmextContext()) {
item = context.RVinculaciones.Where(x => x.IdRVinculaciones == id).SingleOrDefault();
}
}
catch (Exception ex) {
}
return(item);
}
public int ChangeStatus(TaksAdmon ticket)
{
int val = 0;
try
{
using (ClusmextContext context = new ClusmextContext())
{
context.Entry(ticket).State = EntityState.Modified;
val = context.SaveChanges();
}
}
catch (Exception ex)
{
}
return(val);
}