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));
}
