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(); }
protected void Button3_Click(object sender, EventArgs e) { try { byte[] imag = FileUpload2.FileBytes; //string msj; DatosP.EditarProducto(Convert.ToInt32(Label8.Text), TextBox3.Text, TextBox4.Text, imag, Convert.ToInt32(DropDownList18.SelectedValue)); foreach (GridViewRow row in GridView8.Rows) { DatosP.insertarOEM(row.Cells[2].Text, Convert.ToInt32(Label8.Text), Convert.ToInt32(row.Cells[3].Text)); } foreach (GridViewRow row in GridView9.Rows) { DatosP.insertarCodigoMarcaPrd(row.Cells[2].Text, Convert.ToInt32(Label8.Text), Convert.ToInt32(row.Cells[3].Text)); } foreach (GridViewRow row in GridView10.Rows) { DatosP.insertarAnioProducto(Convert.ToInt32(Label8.Text), Convert.ToInt32(row.Cells[4].Text), row.Cells[5].Text, row.Cells[6].Text); } Response.Write("<script>alert('Datos actualizados con exitos, actualiza la pagina!')</script>"); limpirar(); } catch { Response.Write("<script>alert('Llene los campos correctamente')</script>"); Button4_ModalPopupExtender.Show(); } }
protected void GridView10_RowDeleting1(object sender, GridViewDeleteEventArgs e) { int index = Convert.ToInt32(e.RowIndex); tba = (DataTable)ViewState["Detalles11"]; tba.Rows[index].Delete(); GridView10.DataSource = tba; GridView10.DataBind(); Button4_ModalPopupExtender.Show(); }
protected void DropDownList8_SelectedIndexChanged(object sender, EventArgs e) { Button4_ModalPopupExtender.Show(); }
protected void Btn_AgergarAnioRP(object sender, EventArgs e) { tba.Columns.Add("Marca"); tba.Columns.Add("Modelo"); tba.Columns.Add("Rubro"); tba.Columns.Add("ID_Rubro"); tba.Columns.Add("AnioInicio"); tba.Columns.Add("AnioFinal"); foreach (GridViewRow drow in GridView7.Rows) { DataRow dr = tba.NewRow(); dr["Marca"] = drow.Cells[0].Text.ToString(); dr["Modelo"] = drow.Cells[1].Text.ToString(); dr["Rubro"] = drow.Cells[2].Text.ToString(); dr["ID_Rubro"] = drow.Cells[3].Text.ToString(); dr["AnioInicio"] = drow.Cells[4].Text.ToString(); dr["AnioFinal"] = drow.Cells[5].Text.ToString(); tba.Rows.Add(dr); } if (DropDownList16.SelectedItem.ToString() != "") { DataRow dr = null; if (ViewState["Detalles11"] != null) { for (int i = 0; i < 1; i++) { tba = (DataTable)ViewState["Detalles11"]; if (tba.Rows.Count > 0) { dr = tba.NewRow(); // dr["ID"] = Label1.Text; dr["Marca"] = DropDownList7.SelectedItem.ToString(); dr["Modelo"] = DropDownList8.SelectedItem.ToString(); dr["Rubro"] = DropDownList10.SelectedItem.ToString(); dr["ID_Rubro"] = DropDownList10.SelectedValue.ToString(); dr["AnioInicio"] = DropDownList15.SelectedItem.ToString(); dr["AnioFinal"] = DropDownList16.SelectedItem.ToString(); tba.Rows.Add(dr); GridView10.DataSource = tba; GridView10.DataBind(); } } } else { dr = tba.NewRow(); // dr["ID"] = Label1.Text; dr["Marca"] = DropDownList7.SelectedItem.ToString(); dr["Modelo"] = DropDownList8.SelectedItem.ToString(); dr["Rubro"] = DropDownList10.SelectedItem.ToString(); dr["ID_Rubro"] = DropDownList10.SelectedValue.ToString(); dr["AnioInicio"] = DropDownList15.SelectedItem.ToString(); dr["AnioFinal"] = DropDownList16.SelectedItem.ToString(); tba.Rows.Add(dr); GridView10.DataSource = tba; GridView10.DataBind(); } ViewState["Detalles11"] = tba; GridView10.Visible = true; GridView7.Visible = false; } else { Response.Write("<script>alert('Ingrese un codigo')</script>"); } DatosP.DeleteAnioProd(Convert.ToInt32(Label8.Text)); Button4_ModalPopupExtender.Show(); }
protected void Btn_AgergarCodigosP(object sender, EventArgs e) { tb.Columns.Add("ID"); tb.Columns.Add("Codigo"); tb.Columns.Add("ID_Marca"); tb.Columns.Add("Marca_P"); foreach (GridViewRow drow in GridView6.Rows) { DataRow dr = tb.NewRow(); dr["ID"] = drow.Cells[0].Text.ToString(); dr["Codigo"] = drow.Cells[1].Text.ToString(); dr["ID_Marca"] = drow.Cells[2].Text.ToString(); dr["Marca_P"] = drow.Cells[3].Text.ToString(); tb.Rows.Add(dr); } if (TextBox2.Text != "") { DataRow dr = null; if (ViewState["Detalles9"] != null) { for (int i = 0; i < 1; i++) { tb = (DataTable)ViewState["Detalles9"]; if (tb.Rows.Count > 0) { dr = tb.NewRow(); // dr["ID"] = Label1.Text; dr["ID"] = "-"; dr["Codigo"] = TextBox2.Text; dr["ID_Marca"] = DropDownList2.SelectedValue.ToString(); dr["Marca_P"] = DropDownList2.SelectedItem.ToString(); tb.Rows.Add(dr); GridView9.DataSource = tb; GridView9.DataBind(); } } } else { dr = tb.NewRow(); // dr["ID"] = Label1.Text; dr["ID"] = "-"; dr["Codigo"] = TextBox2.Text; dr["ID_Marca"] = DropDownList2.SelectedValue.ToString(); dr["Marca_P"] = DropDownList2.SelectedItem.ToString(); tb.Rows.Add(dr); GridView9.DataSource = tb; GridView9.DataBind(); } ViewState["Detalles9"] = tb; TextBox2.Text = ""; GridView9.Visible = true; GridView6.Visible = false; } else { Response.Write("<script>alert('Ingrese un codigo')</script>"); } DatosP.DeleteCodigoProd(Convert.ToInt32(Label8.Text)); Button4_ModalPopupExtender.Show(); }