public List <CatalogoGenerico> ObtenerCatalogoCampoMascara(string tabla) { List <CatalogoGenerico> result; DataBaseModelContext db = new DataBaseModelContext(); try { result = db.ExecuteStoreQuery <CatalogoGenerico>("ObtenerCatalogoSistema '" + tabla + "'").ToList(); } catch (Exception ex) { throw new Exception(ex.Message); } finally { db.Dispose(); } return(result); }
public List <CatalogoGenerico> ObtenerRegistrosCatalogo(int idCatalogo) { List <CatalogoGenerico> result; DataBaseModelContext db = new DataBaseModelContext(); try { Catalogos cat = db.Catalogos.Single(s => s.Id == idCatalogo); result = db.ExecuteStoreQuery <CatalogoGenerico>("ObtenerCatalogoSistema '" + cat.Tabla + "'").ToList(); } catch (Exception ex) { throw new Exception(ex.Message); } finally { db.Dispose(); } return(result); }
public List <CatalogoGenerico> ObtenerRegistrosSistemaCatalogo(int idCatalogo, bool insertarSeleccion, bool filtroHabilitado) { List <CatalogoGenerico> result; DataBaseModelContext db = new DataBaseModelContext(); try { Catalogos cat = db.Catalogos.Single(s => s.Id == idCatalogo); result = db.ExecuteStoreQuery <CatalogoGenerico>("ObtenerCatalogoSistema '" + cat.Tabla + "'," + Convert.ToInt32(insertarSeleccion) + "," + Convert.ToInt32(filtroHabilitado)).ToList(); } catch (Exception ex) { throw new Exception(ex.Message); } finally { db.Dispose(); } return(result); }