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