// POST: api/cafes
public string Post([FromBody] cafes cafe)
{
using (desafioProgEntities bd = new desafioProgEntities())
{
bd.cafes.Add(cafe);
bd.SaveChanges();
return("Café salvo com sucesso");
}
}
// GET: api/participante
public IEnumerable <dynamic> Get()
{
using (desafioProgEntities bd = new desafioProgEntities())
{
var participante = from part in bd.participante
select new { part.id, part.nome, part.sobrenome, part.salaEtapa1, nomeSala1 = part.salas.nome, part.salaEtapa2, nomeSala2 = part.salas1.nome, part.cafeEtapa1, nomeCafe1 = part.cafes.nome, part.cafeEtapa2, nomeCafe2 = part.cafes1.nome };
return(participante.ToList());
}
}
// GET: api/cafes
public IEnumerable <dynamic> Get()
{
using (desafioProgEntities bd = new desafioProgEntities())
{
var cafes = from caf in bd.cafes
select new { caf.id, caf.nome, caf.lotacao };
return(cafes.ToList());
}
}
// POST: api/participante
public string Post([FromBody] participante part)
{
using (desafioProgEntities bd = new desafioProgEntities())
{
bd.participante.Add(part);
bd.SaveChanges();
return("Participante salvo com sucesso");
}
}
// GET: api/etapas
public IEnumerable <dynamic> Get()
{
using (desafioProgEntities bd = new desafioProgEntities())
{
var etapas = from etap in bd.etapas
select new { etap.id, etap.nome, etap.situacao };
return(etapas.ToList());
}
}
// POST: api/salas
public string Post([FromBody] salas sala)
{
using (desafioProgEntities bd = new desafioProgEntities())
{
bd.salas.Add(sala);
bd.SaveChanges();
return("Sala salva com sucesso");
}
}
// GET: api/salas
public IEnumerable <dynamic> Get()
{
using (desafioProgEntities bd = new desafioProgEntities())
{
var salas = from sal in bd.salas
select new { sal.id, sal.nome, sal.lotacao };
return(salas.ToList());
}
}
// PUT: api/cafes/5
public string Put(int id, [FromBody] cafes cafe)
{
using (desafioProgEntities bd = new desafioProgEntities())
{
cafes cafeAlterar = bd.cafes.Find(id);
cafeAlterar.lotacao = cafe.lotacao;
bd.SaveChanges();
return("Alterado com sucesso");
}
}
// PUT: api/etapas/5
public string Put(int id, [FromBody] etapas etapa)
{
using (desafioProgEntities bd = new desafioProgEntities())
{
etapas etapaAlterar = bd.etapas.Find(id);
etapaAlterar.situacao = etapa.situacao;
bd.SaveChanges();
return("Alterado com sucesso");
}
}
// PUT: api/salas/5
public string Put(int id, [FromBody] salas sala)
{
using (desafioProgEntities bd = new desafioProgEntities())
{
salas salaAlterar = bd.salas.Find(id);
salaAlterar.lotacao = sala.lotacao;
bd.SaveChanges();
return("Alterado com sucesso");
}
}
// PUT: api/participante/5
public string Put(int id, [FromBody] participante part)
{
using (desafioProgEntities bd = new desafioProgEntities())
{
participante partAlterar = bd.participante.Find(id);
partAlterar.salaEtapa1 = part.salaEtapa1;
partAlterar.salaEtapa2 = part.salaEtapa2;
bd.SaveChanges();
return("Alterado com sucesso");
}
}
