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 bool SalvarUsuario(Usuario user)
{
try
{
ISession session = NHibernateFactory.CreateSessionGeral().OpenSession();
session.SaveOrUpdate(user);
session.Close();
return(true);
}
catch (Exception)
{
return(false);
}
}
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 <Pacote> ObterPorDestinatario(Guid UsuarioId)
{
try
{
ISession session = NHibernateFactory.CreateSessionPacote().OpenSession();
var pacotes = session.QueryOver <Pacote>().Where(x => x.DestinatarioId.Equals(UsuarioId)).List();
session.Close();
return(pacotes);
}
catch (Exception)
{
return(null);
}
}
public static Pacote ObterPorTag(Guid TagRFID)
{
try
{
ISession session = NHibernateFactory.CreateSessionPacote().OpenSession();
var pacote = session.QueryOver <Pacote>().Where(x => x.TagRFID.Equals(TagRFID)).SingleOrDefault();
session.Close();
return(pacote);
}
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 IEnumerable <Rota> ObterTodasRotas()
{
try
{
ISession session = NHibernateFactory.CreateSessionPacote().OpenSession();
var itens = session.QueryOver <Rota>().List();
session.Close();
return(itens);
}
catch (Exception)
{
return(null);
}
}
public static bool SalvarRota(Rota rota)
{
try
{
ISession sessionPacote = NHibernateFactory.CreateSessionPacote().OpenSession();
sessionPacote.SaveOrUpdate(rota);
sessionPacote.Close();
return(true);
}
catch (Exception)
{
return(false);
}
}
public static Localizacao ObterPorId(Guid LocalizacaoId)
{
try
{
ISession session = NHibernateFactory.CreateSessionPacote().OpenSession();
var item = session.QueryOver <Localizacao>().Where(x => x.LocalizacaoId.Equals(LocalizacaoId)).SingleOrDefault();
session.Close();
return(item);
}
catch (Exception)
{
return(null);
}
}
public static IEnumerable <Localizacao> ObterTodasLocalizacoes()
{
try
{
ISession session = NHibernateFactory.CreateSessionPacote().OpenSession();
var localizacoes = session.QueryOver <Localizacao>().List();
session.Close();
return(localizacoes);
}
catch (Exception)
{
return(null);
}
}
public static bool SalvarLocalizacao(Localizacao localizacao)
{
try
{
ISession session = NHibernateFactory.CreateSessionPacote().OpenSession();
session.SaveOrUpdate(localizacao);
session.Close();
return(true);
}
catch (Exception)
{
return(false);
}
}
public static IEnumerable <Pacote> ObterTodosPacotes()
{
try
{
ISession session = NHibernateFactory.CreateSessionPacote().OpenSession();
var pacotes = session.QueryOver <Pacote>().List();
session.Close();
return(pacotes);
}
catch (Exception)
{
return(null);
}
}
public static Rota ObterPorId(Guid RotaId)
{
try
{
ISession session = NHibernateFactory.CreateSessionPacote().OpenSession();
var rota = session.QueryOver <Rota>().Where(x => x.RotaId.Equals(RotaId)).SingleOrDefault();
session.Close();
return(rota);
}
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);
}
}
public RotaService OpenSession()
{
session = NHibernateFactory.GetSessionFactoryPacote().OpenSession();
return(this);
}
public EstacaoService OpenSession()
{
session = NHibernateFactory.GetSessionFactoryGeral().OpenSession();
return(this);
}
public OcorrenciaService OpenSession()
{
session = NHibernateFactory.GetSessionFactoryGeral().OpenSession();
return(this);
}
