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 <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 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 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 <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 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);
}
}
