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