public HttpResponseMessage GetByID([FromUri] int id)
{
// Regiao regiaoEF = this.contexto.Regioes.Where(r => r.IdRegiao == id).FirstOrDefault();
// Regiao regiaoEF = this.contexto.Regioes.Find(id);
Regiao regiaoEF = this.Contexto.Regioes.SingleOrDefault(r => r.IdRegiao == id);
if (regiaoEF != null)
{
try
{
PocoRegiao poco = new PocoRegiao()
{
IdRegiao = regiaoEF.IdRegiao,
Descricao = regiaoEF.Descricao,
DataInsert = regiaoEF.DataInsert,
DataUpdate = regiaoEF.DataUpdate
};
return(Request.CreateResponse(HttpStatusCode.OK, poco));
} catch (Exception e)
{
return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, e));
}
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Não encontrado região."));
}
}
public HttpResponseMessage Delete([FromUri] int id)
{
Regiao regiaoEF = this.Contexto.Regioes.Find(id);
if (regiaoEF != null)
{
try
{
PocoRegiao poco = new PocoRegiao()
{
IdRegiao = regiaoEF.IdRegiao,
Descricao = regiaoEF.Descricao,
DataInsert = regiaoEF.DataInsert,
DataUpdate = regiaoEF.DataUpdate
};
this.Contexto.Entry(regiaoEF).State = System.Data.Entity.EntityState.Deleted;
this.Contexto.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK, poco));
} catch (Exception e)
{
return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, e));
}
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Não encontrado a região"));
}
}
public HttpResponseMessage Get()
{
List <Regiao> listaEF = this.Contexto.Regioes.ToList();
List <PocoRegiao> listaPoco = new List <PocoRegiao>();
foreach (Regiao item in listaEF)
{
PocoRegiao poco = new PocoRegiao()
{
IdRegiao = item.IdRegiao,
Descricao = item.Descricao,
DataInsert = item.DataInsert,
DataUpdate = item.DataUpdate
};
listaPoco.Add(poco);
}
;
return(Request.CreateResponse(HttpStatusCode.OK, listaPoco));
}
public HttpResponseMessage Update([FromBody] PocoRegiao poco)
{
try
{
Regiao regiaoEF = new Regiao()
{
IdRegiao = poco.IdRegiao,
Descricao = poco.Descricao,
DataInsert = poco.DataInsert,
DataUpdate = DateTime.Now
};
this.Contexto.Entry(regiaoEF).State = System.Data.Entity.EntityState.Modified;
this.Contexto.SaveChanges();
poco.DataUpdate = regiaoEF.DataUpdate;
return(Request.CreateResponse(HttpStatusCode.OK, poco));
} catch (Exception e)
{
return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, e));
}
}
public HttpResponseMessage GetByID(int id)
{
Regiao regiaoEF = this.Contexto.Regioes.SingleOrDefault(r => r.IdRegiao == id);
if (regiaoEF != null)
{
PocoRegiao poco = new PocoRegiao()
{
IdRegiao = regiaoEF.IdRegiao,
Descricao = regiaoEF.Descricao,
DataInsert = regiaoEF.DataInsert,
DataUpdate = regiaoEF.DataUpdate
};
return(Request.CreateResponse(HttpStatusCode.OK, poco));
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Não encontrado municipio"));
}
}
public HttpResponseMessage Create([FromBody] PocoRegiao poco)
{
try
{
Regiao regiaoEF = new Regiao()
{
IdRegiao = poco.IdRegiao,
Descricao = poco.Descricao,
DataInsert = DateTime.Now
};
this.Contexto.Regioes.Add(regiaoEF);
this.Contexto.SaveChanges();
poco.IdRegiao = regiaoEF.IdRegiao;
return(Request.CreateResponse(HttpStatusCode.OK, poco));
} catch (Exception e)
{
return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, e));
}
}
