/// <summary> /// Permite editar los datos de un elemento /// </summary> private void buttonEditar_Click(object sender, EventArgs e) { Button buttonClicked = sender as Button; FormEditarElemento form = new FormEditarElemento(connection); command = new MySqlCommand("Select nombre, descripcion, imagen from elementos where nombre=@nombre and nombre_col = @nombre_col and nombre_user = @nombre_user", connection); command.Parameters.AddWithValue("@nombre", buttonClicked.Name); command.Parameters.AddWithValue("@nombre_col", ColeccionActiva); command.Parameters.AddWithValue("@nombre_user", UsuarioActivo); connection.Open(); reader = command.ExecuteReader(); reader.Read(); form.Nombre = buttonClicked.Name; form.Descripcion = reader["descripcion"].ToString(); if (reader["imagen"] != DBNull.Value) { form.ImgBytes = (byte[])reader["imagen"]; } else { form.ImgBytes = null; } ControlElemento.Elemento elemento = (ControlElemento.Elemento)flowLayoutPanelElementos.Controls.Find(buttonClicked.Name, false).First(); connection.Close(); form.ShowDialog(); if (form.DialogResult == DialogResult.OK && form.ImgBytes != null) { MemoryStream ms = new MemoryStream(form.ImgBytes); Image fondo = Image.FromStream(ms); elemento.BackgroundImage = fondo; elemento.BackgroundImageLayout = ImageLayout.Zoom; } }
/// <summary> /// Permite modificar el elemento mostrado /// </summary> private void buttonModificar_Click(object sender, EventArgs e) { FormEditarElemento form = new FormEditarElemento(connection); form.Nombre = Text; form.Descripcion = richTextBoxDescripcion.Text; form.ImgBytes = ImgBytes; form.ShowDialog(); if (form.DialogResult == DialogResult.OK) { richTextBoxDescripcion.Text = form.Descripcion; if (form.ImgBytes != null) { MemoryStream ms = new MemoryStream(form.ImgBytes); pictureBoxCaratula.Image = Image.FromStream(ms); } } }