public IHttpActionResult PostSafra(Safra safra)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.Safra.Add(safra);
try
{
db.SaveChanges();
}
catch (DbUpdateException)
{
if (SafraExists(safra.Id))
{
return(Conflict());
}
else
{
throw;
}
}
return(CreatedAtRoute("DefaultApi", new { id = safra.Id }, safra));
}
public IHttpActionResult PutSafra(long id, Safra safra)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != safra.Id)
{
return(BadRequest());
}
db.Entry(safra).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!SafraExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public ActionResult DeleteConfirmed(int id)
{
Safra safra = db.Safras.Find(id);
safra.Status = false;
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "Id,Ano")] Safra safra)
{
if (ModelState.IsValid)
{
db.Entry(safra).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(safra));
}
public IHttpActionResult GetSafra(long id)
{
Safra safra = db.Safra.Find(id);
if (safra == null)
{
return(NotFound());
}
return(Ok(safra));
}
public ActionResult Create([Bind(Include = "Id,Ano")] Safra safra)
{
if (ModelState.IsValid)
{
safra.Status = true;
db.Safras.Add(safra);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(safra));
}
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Safra safra = db.Safras.Find(id);
if (safra == null)
{
return(HttpNotFound());
}
return(View(safra));
}
public IHttpActionResult DeleteSafra(long id)
{
Safra safra = db.Safra.Find(id);
if (safra == null)
{
return(NotFound());
}
db.Safra.Remove(safra);
db.SaveChanges();
return(Ok(safra));
}
// GET: api/ResultadoSimulacaos
public IQueryable <ResultadoSimulacao> GetResultadoSimulacao()
{
IQueryable <ResultadoSimulacao> res = db.ResultadoSimulacao;
List <PropriedadeSafra> propriedades = db.PropriedadeSafra.ToList();
List <Safra> safras = db.Safra.ToList();
res.ForEachAsync(w =>
{
PropriedadeSafra ps = propriedades.FirstOrDefault(k => k.Id == w.PropriedadeSafraId);
if (ps != null)
{
Safra sf = safras.FirstOrDefault(t => t.Id == ps.SafraId);
if (sf != null)
{
w.SafraDescricao = sf.Descricao;
}
}
});
Thread.Sleep(1000);
return(res);
}
