/// <summary> /// Seleccionamos idCanciones /// </summary> /// <param name="play"></param> /// <returns></returns> public string primeraVez(playlist play) { string insertar = "SELECT idCanciones FROM playlist WHERE usuario = '" + play.getUsuario() + "';"; try { conexion.Open(); MySqlCommand comand = new MySqlCommand(insertar, conexion); string nombre = (string)comand.ExecuteScalar(); Console.WriteLine(nombre); if (nombre == null) { conexion.Close(); return(""); } conexion.Close(); return(nombre); } catch (MySqlException excepcion) { MessageBox.Show(excepcion.ToString()); MessageBox.Show("No funciona Insertado"); return(null); } }
/// <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> /// Actualizamos idCanciones /// </summary> /// <param name="play"></param> /// <returns></returns> public string actualizarPlaylist(playlist play) { string actualizar = "UPDATE playlist SET idCanciones= CONCAT(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(playlist); } catch (MySqlException excepcion) { MessageBox.Show(excepcion.ToString()); MessageBox.Show("No funciona Insertado"); return(null); } }