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