public List <PojoPrincipalGaleria> MostrarImagenes()
{
try
{
List <PojoPrincipalGaleria> concep = new List <PojoPrincipalGaleria>();
PojoPrincipalGaleria pojoAmbu;
MySqlCommand cm = new MySqlCommand();
MySqlDataReader dr;
conec.conexion();
string sql = "select img from principalGaleria";
cm.CommandText = sql;
cm.CommandType = CommandType.Text;
cm.Connection = conec.conectar;
dr = cm.ExecuteReader();
while (dr.Read())
{
pojoAmbu = new PojoPrincipalGaleria();
pojoAmbu.Img = dr.GetString("img");
concep.Add(pojoAmbu);
}
return(concep);
}
catch (Exception exc)
{
return(null);
}
finally
{
conec.conectar.Close();
}
}
public bool modificar(PojoPrincipalGaleria Alma)
{
MySqlCommand cmd = new MySqlCommand();
try
{
conec.conexion();
cmd.Parameters.AddWithValue("@idGaleria", Alma.IdGaleria);
cmd.Parameters.AddWithValue("@Img", Alma.Img);
string consul = "update principalGaleria set idGaleria=@idGaleria, img=@Img where idGaleria=@idGaleria";
cmd.CommandText = consul;
cmd.CommandType = CommandType.Text;
cmd.Connection = conec.conectar;
cmd.ExecuteNonQuery();
return(true);
}
catch
{
return(true);
}
finally
{
conec.conectar.Close();
conec.conectar.Close();
}
}
public static bool insertImagen(string url, string titulo)
{
DaoPrincipalGaleria daoPrincipalGaleria = new DaoPrincipalGaleria();
PojoPrincipalGaleria pojoPrincipalGaleria = new PojoPrincipalGaleria()
{
IdGaleria = daoPrincipalGaleria.obtenerID(titulo),
Img = url
};
bool ok = daoPrincipalGaleria.insertar(pojoPrincipalGaleria);
return(ok);
}
public static bool Actualizar(string titulo, string url, string descripcion)
{
DaoPrincipalGaleria daoPrincipalGaleria = new DaoPrincipalGaleria();
PojoPrincipalGaleria pojoPrincipalGaleria = new PojoPrincipalGaleria()
{
IdGaleria = Convert.ToInt32(titulo),
Img = url
};
bool ok = daoPrincipalGaleria.modificar(pojoPrincipalGaleria);
return ok;
}
public bool insertar(PojoPrincipalGaleria pojoPrincipalGaleria)
{
MySqlCommand cmd = new MySqlCommand();
conec.conexion();
cmd.Parameters.AddWithValue("@idGaleria", pojoPrincipalGaleria.IdGaleria);
cmd.Parameters.AddWithValue("@img", pojoPrincipalGaleria.Img);
string consul = "insert into principalGaleria(idGaleria, img)VALUES(@idGaleria, @img)";
cmd.CommandText = consul;
cmd.CommandType = CommandType.Text;
cmd.Connection = conec.conectar;
cmd.ExecuteNonQuery();
conec.conectar.Close();
return(true);
}
