/// <summary> /// Insertar playlist /// </summary> /// <param name="play"></param> public void InsertarCanciones(playlist play) { string insertar = "INSERT INTO playlist (usuario,idCanciones) VALUES (" + '"' + play.getUsuario() + '"' + "," + '"' + " " + play.getIdCanciones() + " " + '"' + ");"; try { conexion.Open(); MySqlCommand comand = new MySqlCommand(insertar, conexion); comand.ExecuteNonQuery(); conexion.Close(); } catch (MySqlException excepcion) { MessageBox.Show(excepcion.ToString()); MessageBox.Show("No funciona Insertado"); } }
/// <summary> /// Eliminamos cancion de idCanciones /// </summary> /// <param name="play"></param> /// <returns></returns> public bool eliminarPlaylist(playlist play) { string actualizar = "UPDATE playlist SET idCanciones = '" + play.getIdCanciones() + "' where usuario = '" + play.getUsuario() + "';"; try { conexion.Open(); MySqlCommand comand = new MySqlCommand(actualizar, conexion); string playlist = (string)comand.ExecuteScalar(); Console.WriteLine(playlist); return(true); } catch (MySqlException excepcion) { MessageBox.Show(excepcion.ToString()); MessageBox.Show("No funciona Insertado"); return(false); } }