public IList <TModel> Lista()
{
using (var context = new AgdCtContext())
{
var modelo = context.Set <TRespository>().ToList();
return(Mapper.Map <IList <TRespository>, IList <TModel> >(modelo));
}
}
public EmailModel GetEmailContato(int idContato)
{
using (var context = new AgdCtContext())
{
return(Mapper.Map <EmailModel>(
context.Email.Where(f => f.IdContato == idContato)
.FirstOrDefault()));
}
}
public TelefoneModel GetTelefoneContato(int idContato)
{
using (var context = new AgdCtContext())
{
return(Mapper.Map <TelefoneModel>(
context.Telefone.Where(f => f.IdContato == idContato)
.FirstOrDefault()));
}
}
public List <TelefoneModel> ListTelefonesContato(int idContato)
{
using (var context = new AgdCtContext())
{
return(Mapper.Map <List <TelefoneModel> >(
context.Telefone.Where(f => f.IdContato == idContato)
.ToList()));
}
}
public bool Excluir(TModel model)
{
using (var context = new AgdCtContext())
{
var modelo = Mapper.Map <TModel, TRespository>(model);
Attach(context, modelo, EntityState.Deleted);
return(context.SaveChanges() != 0);
}
}
public UsuarioModel GetByLogin(string login)
{
using (var context = new AgdCtContext())
{
return(Mapper.Map <UsuarioModel>(
context.Usuario.Where(f => f.Login == login)
.FirstOrDefault()));
}
}
public List <EmailModel> ListEmailsContato(int idContato)
{
using (var context = new AgdCtContext())
{
return(Mapper.Map <List <EmailModel> >(
context.Email.Where(f => f.IdContato == idContato)
.ToList()));
}
}
public ContatoModel GetContatoUsuario(int idUsuario, string nome)
{
using (var context = new AgdCtContext())
{
return(Mapper.Map <ContatoModel>(
context.Contato.Where(f => f.IdUsuario == idUsuario &&
f.Nome == nome)
.FirstOrDefault()));
}
}
public UsuarioModel GetUsuario(int id)
{
using (var context = new AgdCtContext())
{
return(Mapper.Map <UsuarioModel>(
context.Usuario.Where(f => f.Id == id)
.Include(c => c.Contatos)
.FirstOrDefault()));
}
}
public bool Atualizar(TModel model)
{
using (var context = new AgdCtContext())
{
var modeloBD = Mapper.Map <TModel, TRespository>(model);
Attach(context, modeloBD, EntityState.Modified);
return(context.SaveChanges() != 0);
}
}
public List <ContatoModel> ListaContatosUsuario(int idUsuario)
{
using (var context = new AgdCtContext())
{
return(Mapper.Map <List <ContatoModel> >(
context.Contato.Where(f => f.IdUsuario == idUsuario)
.Include(c => c.Telefones)
.Include(c => c.Emails)
.ToList()));
}
}
public ContatoModel GetContatoUsuario(int idUsuario)
{
using (var context = new AgdCtContext())
{
return(Mapper.Map <ContatoModel>(
context.Contato.Where(f => f.IdUsuario == idUsuario)
.Include(c => c.Telefones)
.Include(c => c.Emails)
.FirstOrDefault()));
}
}
public IList <TModel> SalvarLista(IList <TModel> listModel)
{
using (var context = new AgdCtContext())
{
var listaModelBD = Mapper.Map <IList <TModel>, IList <TRespository> >(listModel);
context.Set <TRespository>().AddRange(listaModelBD);
context.SaveChanges();
return(Mapper.Map <IList <TRespository>, IList <TModel> >(listaModelBD));
}
}
public TModel Salvar(TModel model)
{
using (var context = new AgdCtContext())
{
var modelBD = Mapper.Map <TModel, TRespository>(model);
context.Set <TRespository>().Add(modelBD);
context.SaveChanges();
return(Mapper.Map <TRespository, TModel>(modelBD));
}
}
private void Attach(AgdCtContext context, TRespository entity, EntityState state)
{
var entry = context.Entry(entity);
if (entry.State == EntityState.Detached)
{
context.Set <TRespository>().Attach(entity);
}
context.ChangeObjectState(entity, state);
}
public bool Excluir(int id)
{
bool excluido = false;
using (var context = new AgdCtContext())
{
var registro = context.Contato.Where(x => x.Id == id).FirstOrDefault();
context.Contato.Remove(registro);
excluido = context.SaveChanges() != 0;
}
return(excluido);
}
public bool Excluir(Expression <Func <TModel, bool> > expression)
{
using (var context = new AgdCtContext())
{
var modelo = context.Set <TRespository>().FirstOrDefault(GetMappedSelector(expression));
if (modelo == null)
{
return(false);
}
Attach(context, modelo, EntityState.Deleted);
return(context.SaveChanges() != 0);
}
}
