public List <Mesa> ListarPorUsuario(Usuario u)
{
using (var rrc = new RemixRPGContainer())
{
try
{
var mestres = rrc.MestreSet.Where(m => m.UsuarioId == u.Id).ToList();
var jogadores = new JogadorDao().ListarDoUsuario(u);
if (mestres.Count > 0)
{
foreach (var m in mestres)
{
mesas.Add(m.Mesa);
}
}
if (jogadores.Count > 0)
{
foreach (var j in jogadores)
{
mesas.Add(j.Mesa);
}
}
return(mesas);
}
catch (Exception ex)
{
throw new Exception("[MesaDao.Listar] -> " + ex.Message);
}
}
}
public List <Usuario> Listar()
{
using (var rrc = new RemixRPGContainer())
{
try
{
return(rrc.UsuarioSet.ToList());
}
catch (Exception ex)
{
throw new Exception("[UsuarioDao.Listar] -> " + ex);
}
}
}
public Usuario SelecionarPorEmail(string email)
{
using (var rrc = new RemixRPGContainer())
{
try
{
return(rrc.UsuarioSet.ToList().Where(u => u.Email == email).SingleOrDefault());
}
catch (Exception ex)
{
throw new Exception("[UsuarioDao.SelecionarPorEmail] -> " + ex.Message);
}
}
}
public List <Mesa> Listar()
{
using (var rrc = new RemixRPGContainer())
{
try
{
return(rrc.MesaSet.ToList());
}
catch (Exception ex)
{
throw new Exception("[MesaDao.Listar] -> " + ex.Message);
}
}
}
public List <Jogador> ListarDoUsuario(Usuario u)
{
using (var rrc = new RemixRPGContainer())
{
try
{
return(rrc.JogadorSet.Where(j => j.UsuarioId == u.Id).ToList());
}
catch (Exception ex)
{
throw new Exception("[JogadorDao.Listar] -> " + ex.Message);
}
}
}
public void Inserir(Jogador jogador)
{
using (var rrc = new RemixRPGContainer())
{
try
{
rrc.JogadorSet.Add(jogador);
rrc.SaveChanges();
}
catch (Exception ex)
{
throw new Exception("[JogadorDao.Inserir] -> " + ex.Message);
}
}
}
public void Inserir(Usuario usuario)
{
using (var rrc = new RemixRPGContainer())
{
try
{
usuario.DataCadastro = DateTime.Now.ToString();
rrc.UsuarioSet.Add(usuario);
rrc.SaveChanges();
}
catch (Exception ex)
{
throw new Exception("[UsuarioDao.Inserir] -> " + ex.Message);
}
}
}
public void Inserir(Mesa mesa)
{
using (var rrc = new RemixRPGContainer())
{
try
{
mesa.DataCriacao = DateTime.Now.ToString();
rrc.MesaSet.Add(mesa);
rrc.SaveChanges();
}
catch (Exception ex)
{
throw new Exception("[MesaDao.Inserir] -> " + ex.Message);
}
}
}
