public void updateAboutUsSinImg(AboutBE aboutBE) { const string sqlQuery = @" UPDATE AboutUs SET Titulo = @Titulo, Descripcion = @Descripcion WHERE IdAbout = @IdAbout "; SqlConnection con = new SqlConnection(connectionString); SqlCommand cmd = new SqlCommand(sqlQuery, con); cmd.CommandType = CommandType.Text; cmd.Parameters.AddWithValue("@IdAbout", aboutBE.IdAbout); cmd.Parameters.AddWithValue("@Titulo", aboutBE.Titulo); cmd.Parameters.AddWithValue("@Descripcion", aboutBE.Descripcion); try { con.Open(); cmd.ExecuteNonQuery(); } catch (Exception ex) { Console.WriteLine(ex.Message); } finally { cmd.Parameters.Clear(); con.Close(); } }
private void modificarAbout() { AboutBE aboutBE = new AboutBE(); HomePageBL homePageBL = new HomePageBL(); try { aboutBE.IdAbout = Convert.ToInt32(txtId.Text); aboutBE.Titulo = txtTitulo.Text; aboutBE.Descripcion = txtDesc.Text; aboutBE.Logo = subirImagen(); aboutBE.ImagenFondo = subirImagenBg(); homePageBL.updateAbout(aboutBE); } catch (Exception ex) { ClientScript.RegisterStartupScript(this.GetType(), "randomtext", "alertError('" + ex.Message + "')", true); } finally { ClientScript.RegisterStartupScript(this.GetType(), "randomtext", "alertUpdateSuccess('Se modifico con exito')", true); limpiarCamposAbout(); } }
public void updateAboutUsSinImg(AboutBE aboutBE) => homePageDA.updateAboutUsSinImg(aboutBE);
public void updateAboutUsLogo(AboutBE aboutBE) => homePageDA.updateAboutUsLogo(aboutBE);