public new IList <Livro> Buscar() { using (ISession _session = NHibernateConexao.OpenSession()) { return(_session.QueryOver <Livro>().OrderBy(x => x.nomeLiv).Asc.List()); } }
public IList <LogradouroModel> RetornaTodos() { var session = NHibernateConexao.GetSessionLocal(); var resultado = session.Query <LogradouroData>().ToList(); session.Close(); return(_mapper.Map <List <LogradouroModel> >(resultado)); }
public LogradouroModel RetornarPorId(int id) { var session = NHibernateConexao.GetSessionLocal(); var resultado = session .Query <LogradouroData>() .Where(w => w.Id == id) .ToList(); session.Close(); return(_mapper.Map <LogradouroModel>(resultado.FirstOrDefault())); }
public bool GeraSchema() { try { NHibernateConexao.GeraSchema(); return(true); } catch { return(false); } }
public bool ExcluirPorId(int id) { var session = NHibernateConexao.GetSessionLocal(); var trans = session.BeginTransaction(); try { session.Delete(session.Load <ClienteData>(id)); trans.Commit(); session.Close(); return(true); } catch { trans.Rollback(); session.Close(); return(false); } }
public bool Update(LogradouroModel objeto) { var session = NHibernateConexao.GetSessionLocal(); var trans = session.BeginTransaction(); var logradouro = _mapper.Map <LogradouroData>(objeto); try { session.Update(logradouro); trans.Commit(); session.Close(); return(true); } catch { trans.Rollback(); session.Close(); return(false); } }
public bool ExcluirPorId(int id) { var session = NHibernateConexao.GetSessionLocal(); var objeto = RetornarPorId(id, session); var trans = session.BeginTransaction(); try { session.Delete(session.Load <LogradouroData>(id)); trans.Commit(); session.Close(); return(true); } catch (Exception ex) { trans.Rollback(); session.Close(); return(false); } }
public bool Update(ClienteModel objeto) { var session = NHibernateConexao.GetSessionLocal(); var trans = session.BeginTransaction(); var cliente = _mapper.Map <ClienteData>(objeto); try { session.Update(cliente); trans.Commit(); session.Close(); return(true); } catch { trans.Rollback(); session.Close(); return(false); } }
public bool Gravar(LogradouroModel objeto) { NHibernateConexao.GeraSchema(); var session = NHibernateConexao.GetSessionLocal(); var trans = session.BeginTransaction(); var logradouro = _mapper.Map <LogradouroData>(objeto); try { session.Save(logradouro); trans.Commit(); session.Close(); return(true); } catch (Exception ex) { trans.Rollback(); session.Close(); return(false); } }
public bool Gravar(ClienteModel objeto) { var session = NHibernateConexao.GetSessionLocal(); var trans = session.BeginTransaction(); var cliente = _mapper.Map <ClienteData>(objeto); if (!VerificaEmail(cliente.Email, session)) { try { session.Save(cliente); trans.Commit(); session.Close(); return(true); } catch { trans.Rollback(); session.Close(); return(false); } } return(false); }
public DaoBase() { SingletonConexao.Instance.Create(ArquivoConexao.caminho, ArquivoConexao.mapeamentos); NHibernateConexao.OpenSession(SingletonConexao.Instance.Conexao, SingletonConexao.Instance.Mapeamentos); }