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