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