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