public void Delete(int id)
{
using (ISession session = FluentSessionFactory.abrirSession())
{
using (ITransaction transacao = session.BeginTransaction())
{
try
{
Relationship relationShip = session.Get <Relationship>(id);
if (relationShip != null)
{
session.Delete(relationShip);
transacao.Commit();
}
}
catch (Exception e)
{
if (!transacao.WasCommitted)
{
transacao.Rollback();
}
throw new Exception("Erro ao deletar empresa: " + e.Message);
}
}
}
}
public void Save(Employee employee)
{
using (ISession session = FluentSessionFactory.abrirSession())
{
using (ITransaction transacao = session.BeginTransaction())
{
try
{
var user = session.Get <User>(1);
var enterprise = session.Get <Enterprise>(1);
user.Enterprises.Add(employee.Enterprise);
enterprise.Users.Add(employee.User);
session.Flush();
transacao.Commit();
}
catch (Exception e)
{
if (!transacao.WasCommitted)
{
transacao.Rollback();
}
throw new Exception("Erro ao inserir relacionamento: " + e.Message);
}
}
}
}
public void Delete(int id)
{
using (ISession session = FluentSessionFactory.abrirSession())
{
using (ITransaction transacao = session.BeginTransaction())
{
try
{
Relacionamentos relacionamentos = session.Get <Relacionamentos>(id);
if (relacionamentos != null)
{
session.Delete(relacionamentos);
transacao.Commit();
}
}
catch (Exception e)
{
if (!transacao.WasCommitted)
{
transacao.Rollback();
}
throw new Exception("Erro ao deletar usuário: " + e.Message);
}
}
}
}
public I GetById <I>(int id)
{
using (ISession session = FluentSessionFactory.abrirSession())
{
return(session.Get <I>(id));
}
}
public void Delete(int id)
{
using (ISession session = FluentSessionFactory.abrirSession())
{
using (ITransaction transacao = session.BeginTransaction())
{
try
{
T obj = session.Get <T>(id);
if (obj != null)
{
session.Delete(obj);
transacao.Commit();
}
}
catch (Exception e)
{
if (!transacao.WasCommitted)
{
transacao.Rollback();
}
throw new Exception("Erro ao deletar o registro: " + e.Message);
}
}
}
}
public IList <Relacionamentos> GetAll()
{
using (ISession session = FluentSessionFactory.abrirSession())
{
return((from e in session.Query <Relacionamentos>() select e).ToList());
}
}
public void Delete(int id)
{
using (ISession session = FluentSessionFactory.abrirSession())
{
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 Empresa: " + e.Message);
}
}
}
}
public Relacionamentos GetById(int id)
{
using (ISession session = FluentSessionFactory.abrirSession())
{
return(session.Get <Relacionamentos>(id));
}
}
public Relationship GetById(int id)
{
using (ISession session = FluentSessionFactory.abrirSession())
{
return(session.Get <Relationship>(id));
}
}
public User GetById(int id)
{
using (ISession session = FluentSessionFactory.abrirSession())
{
return(session.Get <User>(id));
}
}
public IList <Enterprise> GetAll()
{
using (ISession session = FluentSessionFactory.abrirSession())
{
return((from e in session.Query <Enterprise>() select e).ToList());
}
}
public IList <I> GetFunc <I>(System.Linq.Expressions.Expression <System.Func <I, bool> > ex)
{
using (ISession session = FluentSessionFactory.abrirSession())
{
return((from e in session.Query <I>().Where(ex) select e).ToList());
}
}
public Enterprise GetById(int id)
{
using (ISession session = FluentSessionFactory.abrirSession())
{
return(session.Get <Enterprise>(id));
}
}
public UserEnterprise GetById(int idUser, int idEnterprise)
{
using (ISession session = FluentSessionFactory.abrirSession())
{
return(session.Get <UserEnterprise>(new UserEnterprise()
{
IdEnterprise = idEnterprise, IdUser = idUser
}));
}
}
public Enterprise GetById(int id)
{
try
{
using (ISession session = FluentSessionFactory.abrirSession())
{
return(session.Get <Enterprise>(id));
}
}
catch (Exception e)
{
throw new Exception("Erro ao retornar empresa por id: " + e.Message);
}
}
public List <Employee> GetAll()
{
using (ISession session = FluentSessionFactory.abrirSession())
{
var employees =
(from e in session.Query <Enterprise>()
from u in e.Users
select new Employee {
Enterprise = e, User = u
});
return(employees.ToList());
}
}
public IList <Enterprise> GetAll()
{
try
{
using (ISession session = FluentSessionFactory.abrirSession())
{
return((from e in session.Query <Enterprise>() select e).ToList());
}
}
catch (Exception e)
{
throw new Exception("Erro ao retornar empresas: " + e.Message);
}
}
private void Update(Relacionamentos relacionamentos)
{
using (ISession session = FluentSessionFactory.abrirSession())
{
using (ITransaction transacao = session.BeginTransaction())
{
try
{
session.Update(relacionamentos);
transacao.Commit();
}
catch (Exception e)
{
if (!transacao.WasCommitted)
{
transacao.Rollback();
}
throw new Exception("Erro ao atualizar usuário: " + e.Message);
}
}
}
}
private void Add(EnterpriseUser enterpriseUser)
{
using (ISession session = FluentSessionFactory.abrirSession())
{
using (ITransaction transacao = session.BeginTransaction())
{
try
{
session.Save(enterpriseUser);
transacao.Commit();
}
catch (Exception e)
{
if (!transacao.WasCommitted)
{
transacao.Rollback();
}
throw new Exception("Erro ao inserir Relacionamento: " + e.Message);
}
}
}
}
public void Update(T obj)
{
using (ISession session = FluentSessionFactory.abrirSession())
{
using (ITransaction transacao = session.BeginTransaction())
{
try
{
session.Update(obj);
transacao.Commit();
}
catch (Exception e)
{
if (!transacao.WasCommitted)
{
transacao.Rollback();
}
throw new Exception("Erro ao atualizar o registro: " + e.Message);
}
}
}
}
private void Add(UserEnterprise userEnterprise)
{
using (ISession session = FluentSessionFactory.abrirSession())
{
using (ITransaction transacao = session.BeginTransaction())
{
try
{
session.Save(userEnterprise);
transacao.Commit();
}
catch (Exception e)
{
if (!transacao.WasCommitted)
{
transacao.Rollback();
}
throw new Exception("Erro ao inserir usuario em empresa: " + e.Message);
}
}
}
}
private void Update(Enterprise enterprise)
{
using (ISession session = FluentSessionFactory.abrirSession())
{
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 Empresa: " + e.Message);
}
}
}
}
private void Add(Relationship relationShip)
{
using (ISession session = FluentSessionFactory.abrirSession())
{
using (ITransaction transacao = session.BeginTransaction())
{
try
{
session.Save(relationShip);
transacao.Commit();
}
catch (Exception e)
{
if (!transacao.WasCommitted)
{
transacao.Rollback();
}
throw new Exception("Erro ao inserir empresa: " + e.Message);
}
}
}
}
