public ActionResult DeleteConfirmed(int id)
{
revisao revisao = db.revisao.Find(id);
db.revisao.Remove(revisao);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult revisaoRel([Bind(Include = "dataRevisao,dataFim")] revisao revisao)
{
DateTime dataRevisao = (DateTime)revisao.dataRevisao;
string revisaoI = dataRevisao.ToString("MM-dd-yyyy");
DateTime dataFim = (DateTime)revisao.dataFim;
string revisaoF = dataFim.ToString("MM-dd-yyyy");
var listaBanco = db.revisao.SqlQuery("SELECT * FROM revisao WHERE dataRevisao BETWEEN ' " + revisaoI + " ' AND ' " + revisaoF + " ' ORDER BY dataRevisao").ToList();
return(View(listaBanco.ToList()));
}
public ActionResult Edit([Bind(Include = "id,bicicleta_id,autor,dataRevisao,descricao,observacao")] revisao revisao)
{
if (ModelState.IsValid)
{
db.Entry(revisao).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.bicicleta_id = new SelectList(db.bicicleta, "id", "nome", revisao.bicicleta_id);
return(View(revisao));
}
// GET: Revisao/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
revisao revisao = db.revisao.Find(id);
if (revisao == null)
{
return(HttpNotFound());
}
return(View(revisao));
}
// GET: Revisao/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
revisao revisao = db.revisao.Find(id);
if (revisao == null)
{
return(HttpNotFound());
}
ViewBag.bicicleta_id = new SelectList(db.bicicleta, "id", "nome", revisao.bicicleta_id);
return(View(revisao));
}
