public ActionResult DeleteConfirmed(int id) { smk_itens smk_itens = db.smk_itens.Find(id); db.smk_itens.Remove(smk_itens); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit(smk_itens smk_itens) { if (ModelState.IsValid) { db.Entry(smk_itens).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(smk_itens)); }
public ActionResult Create(smk_itens smk_itens) { if (ModelState.IsValid) { db.smk_itens.Add(smk_itens); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(smk_itens)); }
// // GET: /smkItmes/Details/5 public ViewResult Details(int id) { smkProductView smkProductView = new smkProductView(); List <smkSubProdus> smkSubProdus = new List <smkSubProdus>(); smkProductView objProductView = new smkProductView(); smkSubProdus objsubProdus = new smkSubProdus(); List <smkAccessory> smkSubAccessory = new List <smkAccessory>(); List <smkAccessory> smkAccessory1 = new List <smkAccessory>(); List <smkAccessory> smkAccessory2 = new List <smkAccessory>(); smkProductView objsmkProductView = new smkProductView(); smkAccessory objsmkAccessory = new smkAccessory(); string str_query = @"SELECT sp.id, sp.descricao, comprimento_acabada, largura_acabada, espessura_acabada, comprimento_bruto, largura_bruto, espessura_bruto, quantidade, AREA, perda, smk_itens_id, csp.descricao AS csp_descricao FROM sub_produtos sp JOIN categoria_sub_produtos csp ON csp.id = sp.categoria_sub_produtos_id WHERE sp.smk_itens_id =@id ORDER BY csp.descricao" ; using (SqlConnection conn = new SqlConnection(str_connection)) using (SqlCommand cmd = new SqlCommand(str_query, conn)) { cmd.Parameters.AddWithValue("@id", id); conn.Open(); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { int nId = Convert.ToInt32(reader["id"]); string descricao = reader["descricao"].ToString(); string comprimento_acabada = reader["comprimento_acabada"].ToString(); string largura_acabada = reader["largura_acabada"].ToString(); string espessura_acabada = reader["espessura_acabada"].ToString(); string comprimento_bruto = reader["comprimento_bruto"].ToString(); string largura_bruto = reader["largura_bruto"].ToString(); string espessura_bruto = reader["espessura_bruto"].ToString(); double quantidade = Convert.ToDouble(reader["quantidade"]); string area = reader["Area"].ToString(); string perda = reader["perda"].ToString(); int smkItemId = Convert.ToInt32(reader["smk_itens_id"]); string csp_descricao = reader["csp_descricao"].ToString(); objsubProdus.id = nId; objsubProdus.sp_descricao = descricao; objsubProdus.comprimento_acabada = comprimento_acabada; objsubProdus.espessura_acabada = espessura_acabada; objsubProdus.comprimento_bruto = comprimento_bruto; objsubProdus.largura_bruto = largura_bruto; objsubProdus.quantidade = quantidade; objsubProdus.area = area; objsubProdus.perda = perda; objsubProdus.smk_itens_id = smkItemId; objsubProdus.csp_descricao = csp_descricao; objsubProdus.largura_acabada = largura_acabada; smkSubAccessory = getSmkProduct(id); objsubProdus.smkAccessory = smkSubAccessory; smkSubProdus.Add(objsubProdus); } smkAccessory1 = getSmkAccessory1(id); smkAccessory2 = getSmkAccessory2(id); smkProductView.smkSubProdus = smkSubProdus; smkProductView.smkAccessory1 = smkAccessory1; smkProductView.smkAccessory2 = smkAccessory2; conn.Close(); } smk_itens smk_itens = db.smk_itens.Find(id); return(View(smkProductView)); }
// // GET: /smkItmes/Delete/5 public ActionResult Delete(int id) { smk_itens smk_itens = db.smk_itens.Find(id); return(View(smk_itens)); }