public bool ExistByNome(string nome)
{
Usuario entity;
using (var context = new RThomazDbEntities())
{
entity = context.Usuario
.Where(c => c.Nome.Equals(nome)).FirstOrDefault();
}
return entity == null ? false : true;
}
public Usuario GetByNome(string nome)
{
Usuario entity;
using (var context = new RThomazDbEntities())
{
entity = context.Usuario
.Where(c => c.Nome.Equals(nome)).FirstOrDefault();
}
return entity;
}
public Usuario GetById(long id)
{
Usuario entity;
using (var context = new RThomazDbEntities())
{
entity = context.Usuario
.Where(c => c.UsuarioId.Equals(id)).FirstOrDefault();
}
return entity;
}
public bool ExistByNumero(string numero)
{
Banco entity;
using (var context = new RThomazDbEntities())
{
entity = context.Banco
.Where(c => c.Numero.Equals(numero)).FirstOrDefault();
}
return entity == null ? false : true;
}
public PessoaJuridica GetById(int id)
{
PessoaJuridica entity;
using (var context = new RThomazDbEntities())
{
entity = context.Pessoa.OfType<PessoaJuridica>()
.Where(c => c.PessoaId.Equals(id))
.FirstOrDefault();
}
return entity;
}
public TipoEmail GetById(int id)
{
TipoEmail entity;
using (var context = new RThomazDbEntities())
{
entity = context.TipoEmail
.Where(c => c.TipoEmailId.Equals(id))
.FirstOrDefault();
}
return entity;
}
public bool ExistByEmail(string email)
{
Usuario entity;
using (var context = new RThomazDbEntities())
{
entity = context.Usuario
.Where(c => c.Email.Equals(email))
.FirstOrDefault();
}
return entity == null ? false : true;
}
public bool ExistByUF(int paisId, string uf)
{
Estado entity;
using (var context = new RThomazDbEntities())
{
entity = context.Estado
.Where(c => c.PaisId.Equals(paisId))
.Where(c => c.UF.Equals(uf)).FirstOrDefault();
}
return entity == null ? false : true;
}
public Lancamento GetById(int id)
{
Lancamento entity;
using (var context = new RThomazDbEntities())
{
entity = context.Lancamento
.Where(c => c.LancamentoId.Equals(id))
.FirstOrDefault();
}
return entity;
}
public GrupoConta GetById(int id)
{
GrupoConta entity;
using (var context = new RThomazDbEntities())
{
entity = context.GrupoConta
.Where(c => c.GrupoContaId.Equals(id))
.FirstOrDefault();
}
return entity;
}
public Pais GetById(int id)
{
Pais entity;
using (var context = new RThomazDbEntities())
{
entity = context.Pais
.Where(c => c.PaisId.Equals(id))
.FirstOrDefault();
}
return entity;
}
public bool ExistByNome(int estadoId, string nome)
{
Cidade entity;
using (var context = new RThomazDbEntities())
{
entity = context.Cidade
.Where(c => c.EstadoId.Equals(estadoId))
.Where(c => c.Nome.Equals(nome)).FirstOrDefault();
}
return entity == null ? false : true;
}
public Estado GetById(int id)
{
Estado entity;
using (var context = new RThomazDbEntities())
{
entity = context.Estado
.Include("Pais")
.Where(c => c.EstadoId.Equals(id))
.FirstOrDefault();
}
return entity;
}
public bool ExistByNome(string nome, byte tipoContaId)
{
Conta entity;
using (var context = new RThomazDbEntities())
{
entity = context.Conta
.Where(c => c.TipoContaId.Equals(tipoContaId))
.Where(c => c.Nome.Equals(nome))
.FirstOrDefault();
}
return entity == null ? false : true;
}
public IList<Pessoa> GetAll()
{
IList<Pessoa> result;
using (var context = new RThomazDbEntities())
{
result = context.Pessoa
.ToList();
}
return result;
}
public ContaInvestimento GetById(int id)
{
ContaInvestimento entity;
using (var context = new RThomazDbEntities())
{
entity = context.Conta.OfType<ContaInvestimento>()
.Include("GrupoConta")
.Where(c => c.ContaId.Equals(id))
.FirstOrDefault();
}
return entity;
}
public Cidade GetById(int id)
{
Cidade entity;
using (var context = new RThomazDbEntities())
{
entity = context.Cidade
.Include("Estado.Pais")
.Where(c => c.CidadeId.Equals(id))
.FirstOrDefault();
}
return entity;
}
//Remover usado na tela de funções.... depois que colocar paginação nesta tela
public IList<Usuario> GetAll()
{
IList<Usuario> result;
using (var context = new RThomazDbEntities())
{
result = context.Usuario
.OrderBy(c => c.Nome)
.ToList();
}
return result;
}
public IList<TipoEmail> GetAll()
{
IList<TipoEmail> result;
using (var context = new RThomazDbEntities())
{
result = context.TipoEmail
.OrderBy(c => c.Nome)
.ToList();
}
return result;
}
public IList<GrupoConta> GetByTipoConta(byte tipoContaId)
{
IList<GrupoConta> result;
using (var context = new RThomazDbEntities())
{
result = context.GrupoConta
.Where(x => x.TipoContaId.Equals(tipoContaId))
.OrderBy(c => c.Nome)
.ToList();
}
return result;
}
public PagedList<Usuario> GetPaged(int pageNumber, int pageSize)
{
PagedList<Usuario> pagedList;
using (var context = new RThomazDbEntities())
{
var query = context.Usuario
.OrderBy(c => c.Nome);
pagedList = new PagedList<Usuario>(query, pageNumber, pageSize);
}
return pagedList;
}
public IList<Estado> GetByPaisId(int paisId)
{
IList<Estado> result;
using (var context = new RThomazDbEntities())
{
result = context.Estado
.Where(x => x.PaisId.Equals(paisId))
.OrderBy(c => c.Nome)
.ToList();
}
return result;
}
public IList<Conta> GetAll()
{
IList<Conta> result;
using (var context = new RThomazDbEntities())
{
result = context.Conta
.Include("GrupoConta")
.OrderBy(c => c.Nome)
.ToList();
}
return result;
}
public PagedList<Lancamento> GetPaged(int pageNumber, int pageSize, byte? tipoLancamentoId)
{
PagedList<Lancamento> pagedList;
using (var context = new RThomazDbEntities())
{
var query = context.Lancamento
.Where(x => tipoLancamentoId == null || x.TipoLancamentoId.Equals(tipoLancamentoId.Value))
.OrderBy(x => x.TipoLancamentoId);
pagedList = new PagedList<Lancamento>(query, pageNumber, pageSize);
}
return pagedList;
}
public PagedList<TipoEmail> GetPaged(int pageNumber, int pageSize, byte? tipoPessoaId)
{
PagedList<TipoEmail> pagedList;
using (var context = new RThomazDbEntities())
{
var query = context.TipoEmail
.Where(x => tipoPessoaId == null || x.TipoPessoaId.Equals(tipoPessoaId.Value))
.OrderBy(c => c.Nome);
pagedList = new PagedList<TipoEmail>(query, pageNumber, pageSize);
}
return pagedList;
}
public PagedList<Estado> GetPaged(int pageNumber, int pageSize, int? paisId)
{
PagedList<Estado> pagedList;
using (var context = new RThomazDbEntities())
{
var query = context.Estado
.Include("Pais")
.Where(x => paisId == null || x.PaisId.Equals(paisId.Value))
.OrderBy(c => c.Nome);
pagedList = new PagedList<Estado>(query, pageNumber, pageSize);
}
return pagedList;
}
public ContaInvestimento Save(ContaInvestimento entity)
{
using (var context = new RThomazDbEntities())
{
if (entity.ContaId == 0)
{
entity.DataCriacao = DateTime.Now;
context.Conta.AddObject(entity);
}
else
{
context.CreateObjectSet<Conta>().Attach(entity);
context.ObjectStateManager.ChangeObjectState(entity, EntityState.Modified);
}
context.SaveChanges();
}
return entity;
}
public LancamentoDespesa Save(LancamentoDespesa entity)
{
using (var context = new RThomazDbEntities())
{
if (entity.LancamentoId == 0)
{
entity.DataCriacao = DateTime.Now;
context.Lancamento.AddObject(entity);
}
else
{
context.CreateObjectSet<Lancamento>().Attach(entity);
context.ObjectStateManager.ChangeObjectState(entity, EntityState.Modified);
}
context.SaveChanges();
}
return entity;
}
public PessoaJuridica Save(PessoaJuridica entity)
{
using (var context = new RThomazDbEntities())
{
if (entity.PessoaId == 0)
{
entity.DataCriacao = DateTime.Now;
context.Pessoa.AddObject(entity);
}
else
{
context.CreateObjectSet<Pessoa>().Attach(entity);
context.ObjectStateManager.ChangeObjectState(entity, EntityState.Modified);
}
context.SaveChanges();
}
return entity;
}
public TipoEmail Save(TipoEmail entity)
{
using (var context = new RThomazDbEntities())
{
if (entity.TipoEmailId == 0)
{
entity.DataCriacao = DateTime.Now;
context.TipoEmail.AddObject(entity);
}
else
{
context.CreateObjectSet<TipoEmail>().Attach(entity);
context.ObjectStateManager.ChangeObjectState(entity, EntityState.Modified);
}
context.SaveChanges();
}
return entity;
}
