public static bool SalvarUsuario(Usuario user)
{
try
{
ISession session = NHibernateFactory.CreateSessionGeral().OpenSession();
session.SaveOrUpdate(user);
session.Close();
return(true);
}
catch (Exception)
{
return(false);
}
}
public static IEnumerable <Usuario> ObterTodosUsuarios()
{
try
{
ISession session = NHibernateFactory.CreateSessionGeral().OpenSession();
var pacotes = session.QueryOver <Usuario>().List();
session.Close();
return(pacotes);
}
catch (Exception)
{
return(null);
}
}
public static Usuario ObterPorEmail(string email)
{
try
{
ISession session = NHibernateFactory.CreateSessionGeral().OpenSession();
var user = session.QueryOver <Usuario>().Where(x => x.Email.Equals(email)).SingleOrDefault();
session.Close();
return(user);
}
catch (Exception)
{
return(null);
}
}
public static IEnumerable <Veiculo> ObterTodosVeiculos()
{
try
{
ISession session = NHibernateFactory.CreateSessionGeral().OpenSession();
var itens = session.QueryOver <Veiculo>().List();
session.Close();
return(itens);
}
catch (Exception)
{
return(null);
}
}
public static Veiculo ObterPorId(Guid VeiculoId)
{
try
{
ISession session = NHibernateFactory.CreateSessionGeral().OpenSession();
var item = session.QueryOver <Veiculo>().Where(x => x.VeiculoId.Equals(VeiculoId)).SingleOrDefault();
session.Close();
return(item);
}
catch (Exception)
{
return(null);
}
}
public static bool SalvarVeiculo(Veiculo Veiculo)
{
try
{
ISession session = NHibernateFactory.CreateSessionGeral().OpenSession();
session.SaveOrUpdate(Veiculo);
session.Close();
return(true);
}
catch (Exception)
{
return(false);
}
}
public static Empresa ObterPorId(Guid EmpresaId)
{
try
{
ISession session = NHibernateFactory.CreateSessionGeral().OpenSession();
var empresa = session.QueryOver <Empresa>().Where(x => x.EmpresaId.Equals(EmpresaId)).SingleOrDefault();
session.Close();
return(empresa);
}
catch (Exception)
{
return(null);
}
}
public static IEnumerable <Empresa> ObterTodasEmpresas()
{
try
{
ISession session = NHibernateFactory.CreateSessionGeral().OpenSession();
var empresas = session.QueryOver <Empresa>().List();
session.Close();
return(empresas);
}
catch (Exception)
{
return(null);
}
}
public static IEnumerable <Endereco> ObterTodosEnderecos()
{
try
{
ISession session = NHibernateFactory.CreateSessionGeral().OpenSession();
var enderecos = session.QueryOver <Endereco>().List();
session.Close();
return(enderecos);
}
catch (Exception)
{
return(null);
}
}
public static bool SalvarEndereco(Endereco endereco)
{
try
{
if (endereco.EnderecoId == null)
{
var enderecoSimilar = ObterTodosEnderecos().Where(x => x.Latitude == endereco.Latitude)
.Where(x => x.Longitude == endereco.Longitude)
.Where(x => x.Complemento.Equals(endereco.Complemento)).FirstOrDefault();
if (enderecoSimilar != null)
{
endereco.EnderecoId = enderecoSimilar.EnderecoId;
}
else
{
ISession session = NHibernateFactory.CreateSessionGeral().OpenSession();
session.SaveOrUpdate(endereco);
session.Close();
}
return(true);
}
else
{
ISession session = NHibernateFactory.CreateSessionGeral().OpenSession();
session.SaveOrUpdate(endereco);
session.Close();
return(true);
}
}
catch (Exception)
{
return(false);
}
}
