public ActionResult DeleteConfirmed(int id)
{
PrecoVenda precoVenda = db.PrecoVenda.Find(id);
db.PrecoVenda.Remove(precoVenda);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "idPrecoVenda,Material,preco")] PrecoVenda precoVenda)
{
if (ModelState.IsValid)
{
db.Entry(precoVenda).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.Material = new SelectList(db.Material, "idMaterial", "descricao", precoVenda.Material);
return(View(precoVenda));
}
public ActionResult Create([Bind(Include = "idPrecoVenda,Material,preco")] PrecoVenda precoVenda)
{
if (ModelState.IsValid)
{
db.PrecoVenda.Add(precoVenda);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.Material = new SelectList(db.Material, "idMaterial", "descricao", precoVenda.Material);
return(View(precoVenda));
}
// GET: PrecoVendas/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
PrecoVenda precoVenda = db.PrecoVenda.Find(id);
if (precoVenda == null)
{
return(HttpNotFound());
}
return(View(precoVenda));
}
// GET: PrecoVendas/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
PrecoVenda precoVenda = db.PrecoVenda.Find(id);
if (precoVenda == null)
{
return(HttpNotFound());
}
ViewBag.Material = new SelectList(db.Material, "idMaterial", "descricao", precoVenda.Material);
return(View(precoVenda));
}
public int CadastrarProduto()
{
string query = "insert into Produto values (getdate(),'" + NomeProduto + "','" + QtdeEstoque + "','" + PrecoVenda.ToString().Replace(",", ".") + "', '" + Observacao + "',1,'" + CodigoCategoria + "','" + CodigoMarca + "')";
classConexao cConexao = new classConexao();
return(cConexao.ExecutaQuery(query));
}
