public static int AgregarPublicidad(MySqlConnection conexion, Difusion d) { int retorno = 0; MySqlCommand comando = new MySqlCommand(String.Format("INSERT INTO difusion (dif_contenido) VALUES ('{0}')", d.contenido_dif), conexion); retorno = comando.ExecuteNonQuery(); return(retorno); }
public static int ModificarDif(MySqlConnection conexion, Difusion d) { int retorno = 0; MySqlCommand comando = new MySqlCommand(String.Format("UPDATE difusion SET dif_contenido='{1}' WHERE id_difusion='{0}' ", d.id_dif, d.contenido_dif), conexion); retorno = comando.ExecuteNonQuery(); return(retorno); }
public static int EliminarDif(MySqlConnection conexion, Difusion d) { int retorno = 0; MySqlCommand comando = new MySqlCommand(String.Format("DELETE FROM difusion WHERE id_difusion='{0}' ", d.id_dif), conexion); retorno = comando.ExecuteNonQuery(); return(retorno); }
public static int ExisteDif(MySqlConnection conexion, Difusion d) { int id_dif = 0; MySqlCommand comando = new MySqlCommand(String.Format("SELECT id_difusion FROM difusion WHERE dif_contenido ='{0}'", d.contenido_dif), conexion); MySqlDataReader leer = comando.ExecuteReader(); while (leer.Read()) { id_dif = leer.GetInt32(0); } return(id_dif); }