public IList <TClase> Seleccionar <TClase>() where TClase : class
{
using (ISession session = NHelper.GetCurrentSession())
{
return(session.CreateCriteria <TClase>().List <TClase>());
}
}
public int ContadorRows <TClase>() where TClase : class
{
int rows = 0;
using (ISession session = NHelper.GetCurrentSession())
{
rows = session.QueryOver <TClase>()
.Select(Projections.RowCount())
.FutureValue <int>()
.Value;
}
return(rows);
}
public List <System.Type> getEntidades()
{
List <System.Type> clases = null;
var metaData = NHelper.GetCurrentSession().SessionFactory.GetAllClassMetadata();
if (metaData != null && metaData.Count > 0)
{
clases = new List <Type>();
foreach (var x in metaData)
{
var y = x.Value;
Type xy;
clases.Add(xy = y.GetMappedClass(EntityMode.Poco));
}
}
return(clases);
}
public int Actualizacion(string sql)
{
int i = 0;
using (ISession session = NHelper.GetCurrentSession())
{
using (IDbConnection sql_con = session.Connection)
{
IDbCommand cmd = sql_con.CreateCommand();
cmd.CommandText = sql;
i = cmd.ExecuteNonQuery();
}
}
return(i);
}
public void Actualizar <TClase>(TClase Objeto)
{
try
{
using (ISession session = NHelper.GetCurrentSession())
{
using (ITransaction transaction = session.BeginTransaction())
{
session.Delete(Objeto);
transaction.Commit();
}
}
}
catch (Exception e)
{
Console.WriteLine("Error: " + e.Message);
}
}
public List <string> getEntidadesNombre()
{
List <string> tablas = null;
var metaData = NHelper.GetCurrentSession().SessionFactory.GetAllClassMetadata();
if (metaData != null)
{
tablas = new List <string>();
foreach (var x in metaData)
{
var usrm = x.Value as NHibernate.Persister.Entity.AbstractEntityPersister;
//var cols = usrm.KeyColumnNames;
string table = usrm.TableName;
tablas.Add(table);
}
}
return(tablas);
}
public DataTable Seleccionar(string sql)
{
DataTable dt;
using (ISession session = NHelper.GetCurrentSession())
{
using (IDbConnection sql_con = session.Connection)
{
dt = new DataTable();
IDbCommand cmd = sql_con.CreateCommand();
cmd.CommandText = sql;
var reader = cmd.ExecuteReader();
dt = GetDataTableFromDataReader(reader);
}
}
return(dt);
}
