public Enterprise GetById(int id)
{
using (ISession session = FluentSessionFactory.abrirSession2())
{
return(session.Get <Enterprise>(id));
}
}
public void Delete(int id)
{
using (ISession session = FluentSessionFactory.abrirSession2())
{
using (ITransaction transacao = session.BeginTransaction())
{
try
{
Enterprise enterprise = session.Get <Enterprise>(id);
if (enterprise != null)
{
session.Delete(enterprise);
transacao.Commit();
}
}
catch (Exception e)
{
if (!transacao.WasCommitted)
{
transacao.Rollback();
}
throw new Exception("Erro ao deletar usuário: " + e.Message);
}
}
}
}
public IList <Enterprise> GetAll()
{
using (ISession session = FluentSessionFactory.abrirSession2())
{
return((from e in session.Query <Enterprise>() select e).ToList());
}
}
private void Update(Enterprise enterprise)
{
using (ISession session = FluentSessionFactory.abrirSession2())
{
using (ITransaction transacao = session.BeginTransaction())
{
try
{
session.Update(enterprise);
transacao.Commit();
}
catch (Exception e)
{
if (!transacao.WasCommitted)
{
transacao.Rollback();
}
throw new Exception("Erro ao atualizar a Empresa: " + e.Message);
}
}
}
}
private void Add(Enterprise enterprise)
{
using (ISession session = FluentSessionFactory.abrirSession2())
{
using (ITransaction transacao = session.BeginTransaction())
{
try
{
session.Save(enterprise);
transacao.Commit();
}
catch (Exception e)
{
if (!transacao.WasCommitted)
{
transacao.Rollback();
}
throw new Exception("Erro ao inserir usuário: " + e.Message);
}
}
}
}
