public void ActualizarSQL(string sqlUpdate)
{
ITransaction tx = null;
try
{
session = NHibernateSessionSingleton.GetSession();
tx = session.BeginTransaction();
int updatedEntities = session.CreateSQLQuery(sqlUpdate).ExecuteUpdate();
//session.Flush();
tx.Commit();
}
catch
{
if (tx != null)
{
tx.Rollback();
}
throw;
}
finally
{
NHibernateSessionSingleton.CloseSession();
}
}
public void Actualizar(T value)
{
session = NHibernateSessionSingleton.GetSession();
using (ITransaction tx = session.BeginTransaction())
{
try
{
session.SaveOrUpdate(value);
//session.Flush();
tx.Commit();
}
catch
{
if (tx != null)
{
tx.Rollback();
}
throw;
}
finally
{
NHibernateSessionSingleton.CloseSession();
}
}
}
public void Eliminar(T value)
{
ITransaction tx = null;
try
{
session = NHibernateSessionSingleton.GetSession();
tx = session.BeginTransaction();
session.Delete(value);
//session.Flush();
tx.Commit();
}
catch
{
if (tx != null)
{
tx.Rollback();
}
throw;
}
finally
{
NHibernateSessionSingleton.CloseSession();
}
}
public void Sincronizar()
{
ITransaction tx = null;
try
{
session = NHibernateSessionSingleton.GetSession();
session.Flush();
}
catch
{
throw;
}
finally
{
NHibernateSessionSingleton.CloseSession();
}
}
