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