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