public async Task <Usuario> Get(int id)
{
using (TECHCYCLEContext _context = new TECHCYCLEContext())
{
return(await _context.Usuario.FirstOrDefaultAsync(usr => usr.IdUsuario == id));
}
}
public async Task <FotosAnuncio> Get(int id)
{
using (TECHCYCLEContext _context = new TECHCYCLEContext())
{
return(await _context.FotosAnuncio.FirstOrDefaultAsync(fts => fts.IdFotosAnuncio == id));
}
}
public async Task <List <Categoria> > Get()
{
using (TECHCYCLEContext _context = new TECHCYCLEContext())
{
return(await _context.Categoria.ToListAsync());
}
}
public async Task <Categoria> Get(int id)
{
using (TECHCYCLEContext _context = new TECHCYCLEContext())
{
return(await _context.Categoria.FirstOrDefaultAsync(ctg => ctg.IdCategoria == id));
}
}
public async Task <List <FotosAnuncio> > Get()
{
using (TECHCYCLEContext _context = new TECHCYCLEContext())
{
return(await _context.FotosAnuncio.ToListAsync());
}
}
public async Task <Avaliacao> Get(int id)
{
using (TECHCYCLEContext _context = new TECHCYCLEContext())
{
return(await _context.Avaliacao.FirstOrDefaultAsync(avl => avl.IdAvaliacao == id));
}
}
public async Task <List <Marca> > Get()
{
using (TECHCYCLEContext _context = new TECHCYCLEContext())
{
return(await _context.Marca.ToListAsync());
}
}
public async Task <List <Avaliacao> > Get()
{
using (TECHCYCLEContext _context = new TECHCYCLEContext())
{
return(await _context.Avaliacao.ToListAsync());
}
}
public async Task <Marca> Get(int id)
{
using (TECHCYCLEContext _context = new TECHCYCLEContext())
{
return(await _context.Marca.FirstOrDefaultAsync(mrc => mrc.IdMarca == id));
}
}
public async Task <List <Interesse> > Get()
{
using (TECHCYCLEContext _context = new TECHCYCLEContext())
{
return(await _context.Interesse.ToListAsync());
}
}
public async Task <List <Usuario> > Get()
{
using (TECHCYCLEContext _context = new TECHCYCLEContext())
{
return(await _context.Usuario.ToListAsync());
}
}
public async Task <Interesse> Get(int id)
{
using (TECHCYCLEContext _context = new TECHCYCLEContext())
{
return(await _context.Interesse.FirstOrDefaultAsync(itr => itr.IdInteresse == id));
}
}
public async Task <Produto> Get(int id)
{
using (TECHCYCLEContext _context = new TECHCYCLEContext())
{
return(await _context.Produto.Include("IdMarcaNavigation")
.Include("IdCategoriaNavigation").FirstOrDefaultAsync(pdt => pdt.IdProduto == id));
}
}
public async Task <Comentario> Get(int id)
{
using (TECHCYCLEContext _context = new TECHCYCLEContext())
{
return(await _context.Comentario.Include("IdAnuncioNavigation").Include("IdUsuarioNavigation")
.FirstOrDefaultAsync(cmt => cmt.IdComentario == id));
}
}
public async Task <Anuncio> Get(int id)
{
using (TECHCYCLEContext _context = new TECHCYCLEContext())
{
return(await _context.Anuncio.Include("IdAvaliacaoNavigation")
.Include("IdProdutoNavigation").Include("FotosAnuncio")
.FirstOrDefaultAsync(anc => anc.IdAnuncio == id));
}
}
public async Task <List <Usuario> > GetPorStatus(string statusAprovacao)
{
using (TECHCYCLEContext _context = new TECHCYCLEContext())
{
List <Usuario> listaUsuarioStatus =
await _context.Usuario.Where(usr => usr.StatusAprovacao == statusAprovacao).ToListAsync();
return(listaUsuarioStatus);
}
}
public async Task <Comentario> Delete(Comentario comentario)
{
using (TECHCYCLEContext _context = new TECHCYCLEContext())
{
_context.Comentario.Remove(comentario);
await _context.SaveChangesAsync();
return(comentario);
}
}
public async Task <Marca> Delete(Marca marca)
{
using (TECHCYCLEContext _context = new TECHCYCLEContext())
{
_context.Marca.Remove(marca);
await _context.SaveChangesAsync();
return(marca);
}
}
public async Task <Marca> Put(Marca marca)
{
using (TECHCYCLEContext _context = new TECHCYCLEContext())
{
_context.Entry(marca).State = EntityState.Modified;
await _context.SaveChangesAsync();
return(marca);
}
}
public async Task <Avaliacao> Put(Avaliacao avaliacao)
{
using (TECHCYCLEContext _context = new TECHCYCLEContext())
{
_context.Entry(avaliacao).State = EntityState.Modified;
await _context.SaveChangesAsync();
return(avaliacao);
}
}
public async Task <Categoria> Delete(Categoria categoria)
{
using (TECHCYCLEContext _context = new TECHCYCLEContext())
{
_context.Categoria.Remove(categoria);
await _context.SaveChangesAsync();
return(categoria);
}
}
public async Task <Categoria> Put(Categoria categoria)
{
using (TECHCYCLEContext _context = new TECHCYCLEContext())
{
_context.Entry(categoria).State = EntityState.Modified;
await _context.SaveChangesAsync();
return(categoria);
}
}
public async Task <Avaliacao> Delete(Avaliacao avaliacao)
{
using (TECHCYCLEContext _context = new TECHCYCLEContext())
{
_context.Avaliacao.Remove(avaliacao);
await _context.SaveChangesAsync();
return(avaliacao);
}
}
public async Task <FotosAnuncio> Put(FotosAnuncio fotosAnuncio)
{
using (TECHCYCLEContext _context = new TECHCYCLEContext())
{
_context.Entry(fotosAnuncio).State = EntityState.Modified;
await _context.SaveChangesAsync();
return(fotosAnuncio);
}
}
public async Task <Usuario> verificacaoDeStatus(string status)
{
using (TECHCYCLEContext _context = new TECHCYCLEContext())
{
Usuario usuarioComVerificacao = await _context.Usuario
.FirstOrDefaultAsync(user => user.StatusAprovacao == status);
return(usuarioComVerificacao);
}
}
public async Task <Usuario> verificacaoDeUso(string email, string loginUsuario)
{
using (TECHCYCLEContext _context = new TECHCYCLEContext())
{
Usuario usuarioComVerificacao = await _context.Usuario
.Where(user => user.Email == email || user.LoginUsuario == loginUsuario).FirstOrDefaultAsync();
return(usuarioComVerificacao);
}
}
public async Task <Interesse> Put(Interesse interesse)
{
using (TECHCYCLEContext _context = new TECHCYCLEContext())
{
_context.Entry(interesse).State = EntityState.Modified;
await _context.SaveChangesAsync();
return(interesse);
}
}
public async Task <FotosAnuncio> Delete(FotosAnuncio fotosAnuncio)
{
using (TECHCYCLEContext _context = new TECHCYCLEContext())
{
_context.FotosAnuncio.Remove(fotosAnuncio);
await _context.SaveChangesAsync();
return(fotosAnuncio);
}
}
public async Task <Interesse> Delete(Interesse interesse)
{
using (TECHCYCLEContext _context = new TECHCYCLEContext())
{
_context.Interesse.Remove(interesse);
await _context.SaveChangesAsync();
return(interesse);
}
}
public async Task <Usuario> Put(Usuario usuario)
{
using (TECHCYCLEContext _context = new TECHCYCLEContext())
{
_context.Entry(usuario).State = EntityState.Modified;
await _context.SaveChangesAsync();
return(usuario);
}
}
