public IHttpActionResult Update(long id, [FromBody] Turma turma)
{
if (turma == null || turma.ID != id)
{
return(BadRequest());
}
using (var DAL = new elevaEntities())
{
var Model = DAL.Turma.Where(x => x.ID == id).FirstOrDefault();
if (Model == null)
{
return(NotFound());
}
var Escola = DAL.Escola.Where(x => x.ID == turma.IDEscola).FirstOrDefault();
if (Escola == null)
{
return(BadRequest());
}
Model.Nome = turma.Nome;
Model.IDEscola = turma.IDEscola;
DAL.Entry(Model).State = EntityState.Modified;
DAL.SaveChanges();
}
return(Ok());
}
public IEnumerable <Turma> Get()
{
using (elevaEntities DAL = new elevaEntities())
{
IEnumerable <Turma> Turma = DAL.Turma.Include("Escola").ToList();
return(Turma);
}
}
public IEnumerable <Escola> Get()
{
using (elevaEntities DAL = new elevaEntities())
{
IEnumerable <Escola> Escola = DAL.Escola.Include("Turma").ToList();
return(Escola);
}
}
public Turma Get(int id)
{
using (var DAL = new elevaEntities())
{
Turma Model = DAL.Turma.Where(x => x.ID == id).FirstOrDefault();
return(Model);
}
}
public Escola Get(int id)
{
using (var DAL = new elevaEntities())
{
Escola Model = DAL.Escola.Where(x => x.ID == id).Include("Turma").FirstOrDefault();
return(Model);
}
}
public IHttpActionResult Delete(long id)
{
using (var DAL = new elevaEntities())
{
var Model = DAL.Turma.Where(x => x.ID == id).FirstOrDefault();
if (Model == null)
{
return(NotFound());
}
DAL.Entry(Model).State = EntityState.Deleted;
DAL.SaveChanges();
return(Ok());
}
}
public IHttpActionResult Create([FromBody] Escola escola)
{
//var Model = JsonConvert.DeserializeObject<Escola>(escola);
if (escola == null)
{
return(BadRequest());
}
using (var DAL = new elevaEntities())
{
if (ModelState.IsValid)
{
DAL.Entry(escola).State = EntityState.Added;
DAL.SaveChanges();
}
}
return(Ok());
}
public IHttpActionResult Delete(long id)
{
using (var DAL = new elevaEntities())
{
var Model = DAL.Escola.Where(x => x.ID == id).Include("Turma").FirstOrDefault();
if (Model == null)
{
return(NotFound());
}
var Turmas = Model.Turma.ToList();
foreach (var item in Turmas)
{
DAL.Entry(item).State = EntityState.Deleted;
}
DAL.Entry(Model).State = EntityState.Deleted;
DAL.SaveChanges();
return(Ok());
}
}
public IHttpActionResult Create([FromBody] Turma turma)
{
if (turma == null)
{
return(BadRequest());
}
using (var DAL = new elevaEntities())
{
if (ModelState.IsValid)
{
var Escola = DAL.Escola.Where(x => x.ID == turma.IDEscola).FirstOrDefault();
if (Escola == null)
{
return(BadRequest());
}
DAL.Entry(turma).State = EntityState.Added;
DAL.SaveChanges();
}
}
return(Ok());
}
