public async Task <IActionResult> Edit(int id, [Bind("SubcatId,SubcatName,CatId")] Subcat subcat)
{
if (id != subcat.SubcatId)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(subcat);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!SubcatExists(subcat.SubcatId))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
ViewData["CatId"] = new SelectList(_context.ExpenseCategories, "CatId", "CategoryName", subcat.CatId);
return(View(subcat));
}
protected void LinkButton1_Click(object sender, EventArgs e)
{
// ViewState["Detalles5"] = GridView5;
string Subcat, Subcat2, IdProducto = "";
GridViewRow tabla = (GridViewRow)(((LinkButton)sender).Parent.Parent);
IdProducto = ((Label)tabla.FindControl("Label1")).Text.ToString();
Label8.Text = IdProducto;
SqlDataSource20.SelectCommand = "SELECT OEM.ID_OEM, OEM.OEM, Marca.ID_Marca, Marca.Marca FROM OEM INNER JOIN Producto ON OEM.ID_Producto = Producto.ID_Producto INNER JOIN Marca ON OEM.ID_Marca = Marca.ID_Marca WHERE Producto.ID_Producto = " + IdProducto;
SqlDataSource20.DataBind();
SqlDataSource21.SelectCommand = "SELECT CodigoProducto.ID_CodigoProducto, CodigoProducto.Codigo, MarcaProd.ID_MaraProd, MarcaProd.MarcaP FROM CodigoProducto INNER JOIN Producto ON CodigoProducto.ID_Producto = Producto.ID_Producto INNER JOIN MarcaProd ON CodigoProducto.ID_MaraProd = MarcaProd.ID_MaraProd WHERE Producto.ID_Producto = " + IdProducto;
SqlDataSource21.DataBind();
SqlDataSource22.SelectCommand = "SELECT AnioProducto.AnioInicio, AnioProducto.AnioFinal, Rubro.ID_Rubro, Rubro.Rubro, Modelo.Modelo, Marca.Marca FROM Modelo INNER JOIN Marca ON Modelo.ID_Marca = Marca.ID_Marca INNER JOIN Rubro ON Modelo.ID_Modelo = Rubro.ID_Modelo INNER JOIN AnioProducto ON Rubro.ID_Rubro = AnioProducto.ID_Rubro WHERE AnioProducto.ID_Producto = " + IdProducto;
SqlDataSource22.DataBind();
TextBox3.Text = ((Label)tabla.FindControl("Label2")).Text.ToString();
TextBox4.Text = ((Label)tabla.FindControl("Label3")).Text.ToString();
Subcat = ((Label)tabla.FindControl("Label7")).Text.ToString();
string[] separar;
separar = Subcat.Split(',');
//for(int i = 0; i < separar.Length; i++)
//{
//
//}
// separar = Subcat2.Split(',');
string categoria = separar[1];
// Response.Write("<script>alert('"+ categoria +"')</script>");
DropDownList17.SelectedIndex = DropDownList17.Items.IndexOf(DropDownList17.Items.FindByText(categoria));
// ddlsample.SelectedIndex = ddlsample.Items.IndexOf( ddlsample.Items.FindByText("x"));
SqlDataSource19.SelectCommand = "SELECT ID_SubCategoria, SubCategoria FROM SubCategoria WHERE SubCategoria like '%" + separar[0] + "%'";
SqlDataSource19.DataBind();
Button4_ModalPopupExtender.Show();
}
public async Task <IActionResult> Create([Bind("SubcatId,SubcatName,CatId")] Subcat subcat)
{
if (ModelState.IsValid)
{
_context.Add(subcat);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
ViewData["CatId"] = new SelectList(_context.ExpenseCategories, "CatId", "CategoryName", subcat.CatId);
return(View(subcat));
}
