public T RetornarPorId(int idAdmin)
{
using (ISession session = FluentySessionFactory.AbrirSessao())
{
return(session.Get <T>(idAdmin));
}
}
public IList <X> Listar()
{
using (ISession sessao = FluentySessionFactory.AbrirSessao())
{
return((from e in sessao.Query <X>() select e).ToList());
}
}
public Usuario FetchUsuarioByClave(string clave)
{
using (ISession session = FluentySessionFactory.AbrirSession())
{
return(Dao.UsuarioDao.FetchUsuarioByClave(session, clave));
}
}
public bool validarNome(string nome)
{
ISession session = FluentySessionFactory.AbrirSession();
return((from e in session.Query <Contato>() where e.nome.Equals(nome) && e.status.Equals("A")
select e).Count() > 0);
}
public MenuItem[] Lista() //Array para receber a quantidade de entradas de cadastros no banco
{
using (var session = FluentySessionFactory.AbrirSessao())
{
var query = session.Query <Administrador>().Select(x => new MenuItem
{
ID = x.idAdmin,
nome = x.nomeAdmin,
senha = x.senhaAdmin
}); //select no banco repassando para a array
return(query.ToArray());
}
}
public void Alterar(T entidade)
{
ISession session = FluentySessionFactory.AbrirSession();
ITransaction transaction = session.BeginTransaction();
try {
session.Update(entidade);
transaction.Commit();
} catch (Exception e) {
if (!transaction.WasCommitted)
{
transaction.Rollback();
}
throw new Exception("Erro ao alterar entidade: " + e.Message);
}
}
public void Inserir(X or)
{
using (ISession sessao = FluentySessionFactory.AbrirSessao())
{
using (ITransaction transacao = sessao.BeginTransaction())
{
try
{
sessao.Save(or);
transacao.Commit();
} catch (Exception e)
{
throw new Exception("Erro ao salvar informação no RepCrud " + e.Message);
}
}
}
}
public void Excluir(X or)
{
using (ISession sessao = FluentySessionFactory.AbrirSessao())
{
using (ITransaction transacao = sessao.BeginTransaction())
{
try
{
sessao.Delete(or);
transacao.Commit();
}
catch (Exception e)
{
throw new Exception("Erro ao apagar informação " + e.Message);
}
}
}
}
public void Inserir(T entidade)
{
using (ISession session = FluentySessionFactory.AbrirSessao())
{
using (ITransaction transacao = session.BeginTransaction())
{
try
{
session.Save(entidade);
transacao.Commit();
}
catch (Exception e)
{
if (!transacao.WasCommitted)
{
transacao.Rollback();
}
throw new Exception("Erro ao Inserir" + e.Message);
}
}
}
}
public Boolean Eliminar(T entidad)
{
using (ISession session = FluentySessionFactory.AbrirSession())
{
using (ITransaction transaction = session.BeginTransaction())
{
try
{
session.Delete(entidad);
transaction.Commit();
return(true);
}
catch (Exception ex)
{
if (!transaction.WasCommitted)
{
transaction.Rollback();
}
return(false);
}
}
}
}
public List <Telefone> retornarPorContato(int contato)
{
ISession session = FluentySessionFactory.AbrirSession();
return((from e in session.Query <Telefone>() where e.id_contato.Equals(contato) select e).ToList());
}
public T retornaPorId(int id)
{
ISession session = FluentySessionFactory.AbrirSession();
return(session.Get <T>(id));
}
public IList <T> Consultar()
{
ISession session = FluentySessionFactory.AbrirSession();
return((from e in session.Query <T>() select e).ToList());
}
public IList <T> FetchAll()
{
using (ISession session = FluentySessionFactory.AbrirSession())
return((from e in session.Query <T>() select e).ToList());
}
public T RetornarById(int id)
{
using (ISession session = FluentySessionFactory.AbrirSession())
return(session.Get <T>(id));
}
