public IEnumerable <Models.Escola> GetUF(string uf)
{
Models.EscolaDataContext dc = new Models.EscolaDataContext();
var r = from f in dc.Escolas where f.UF == uf select f;
return(r.ToList());
}
// GET api/escola
public IEnumerable <Models.Escola> Get()
{
Models.EscolaDataContext dc = new Models.EscolaDataContext();
var r = from f in dc.Escolas select f;
return(r.ToList());
}
// DELETE api/fabricante/5
public void Delete(int id)
{
Models.EscolaDataContext dc = new Models.EscolaDataContext();
Models.Escola fab = (from f in dc.Escolas
where f.Id == id
select f).Single();
dc.Escolas.DeleteOnSubmit(fab);
dc.SubmitChanges();
}
// POST api/escola
public void Post([FromBody] string value)
{
List <Models.Escola> x = JsonConvert.DeserializeObject
<List <Models.Escola> >(value);
Models.EscolaDataContext dc = new Models.EscolaDataContext();
dc.Escolas.InsertAllOnSubmit(x);
dc.SubmitChanges();
}
// PUT api/fabricante/5
public void Put(int id, [FromBody] string value)
{
Models.Escola x = JsonConvert.DeserializeObject <Models.Escola>(value);
Models.EscolaDataContext dc = new Models.EscolaDataContext();
Models.Escola fab = (from f in dc.Escolas
where f.Id == id
select f).Single();
fab.Nome = x.Nome;
fab.UF = x.UF;
fab.CN = x.CN;
fab.CH = x.CH;
fab.LC = x.LC;
fab.Matematica = x.Matematica;
fab.Redacao = x.Redacao;
fab.Media = x.Media;
dc.SubmitChanges();
}
// PUT api/escola/5
public void Put(int id, [FromBody] string value)
{
Models.Escola x = JsonConvert.DeserializeObject
<Models.Escola>(value);
Models.EscolaDataContext dc = new Models.EscolaDataContext();
Models.Escola esc = (from f in dc.Escolas
where f.Id == id
select f).Single();
esc.Id = x.Id;
esc.Nome = x.Nome;
esc.UF = x.UF;
esc.CienciasNatureza = x.CienciasNatureza;
esc.CienciasHumanas = x.CienciasHumanas;
esc.LinguagensCodigos = x.LinguagensCodigos;
esc.Matematica = x.Matematica;
esc.Redacao = x.Redacao;
dc.SubmitChanges();
}
