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