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