// Load Playlist Panel
private void loadPlaylistStack()
{
// Wenn aktuell eine Playlist ausgewählt ist, sonst null
PlaylistLabel selected_PL = getSelectedPlL();
// Remove all Children
PlaylistStackPanel.Children.RemoveRange(0, PlaylistStackPanel.Children.Count);
// DataContext auf Liste der Playlists setzen
PlaylistStackPanel.DataContext = pl_list;
// Alle Playlists in PlaylistStackPanel anzeigen
for (int i = 0; i < pl_list.Count; i++)
{
PlaylistLabel pL = new PlaylistLabel(pl_list[i]);
pL.MouseLeftButtonDown += new MouseButtonEventHandler(OnOpenPlaylist);
PlaylistStackPanel.Children.Add(pL);
}
// Wenn vorher eine Playlist ausgewählt war, diese wieder auswählen
if (selected_PL != null)
{
foreach (PlaylistLabel plL in PlaylistStackPanel.Children)
{
if (plL.Playlist.Equals(selected_PL.Playlist))
{
plL.isSelected = true;
}
}
}
appendAddPlLabel(PlaylistStackPanel);
}
public void resetSelectionPlaylistPanel()
{
for (int i = 0; i < PlaylistStackPanel.Children.Count - 1; i++)
{
PlaylistLabel playlistLabel = PlaylistStackPanel.Children[i] as PlaylistLabel;
playlistLabel.isSelected = false;
}
}
// Utility Methods
private PlaylistLabel getSelectedPlL()
{
for (int i = 0; i < PlaylistStackPanel.Children.Count - 1; i++)
{
PlaylistLabel playlistLabel = PlaylistStackPanel.Children[i] as PlaylistLabel;
if (playlistLabel.isSelected)
{
return(playlistLabel);
}
}
return(null);
}
// Open the Playlists Songlist when Clicked
public void OnOpenPlaylist(object sender, RoutedEventArgs e)
{
PlaylistLabel plL = sender as PlaylistLabel;
Playlist pl = plL.Playlist;
// wenn Playlist bereits geladen ist
if (pl.Equals(songsStackPanel.DataContext as Playlist))
{
return;
}
resetSelectionPlaylistPanel();
plL.isSelected = true;
loadPlaylistSongs(pl);
}
private void playlistLabel_Click(object sender, EventArgs e)
{
PlaylistLabel tp = (PlaylistLabel)sender;
MyPl_track_table.Controls.Clear();
string sql = "SELECT tracks.* FROM tracks INNER JOIN playlists_track ON tracks.idtracks = playlists_track.idTrack LEFT JOIN playlists ON playlists.idPlayLists = playlists_track.idPlayList WHERE playlists.idPlayLists = " + tp.id + " GROUP BY tracks.trackName";
MySqlCommand command = new MySqlCommand(sql, conn);
MySqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
byte[] data = ((byte[])reader.GetValue(6));
TrackLabel t = new TrackLabel(reader[1].ToString(), reader[2].ToString(), reader[3].ToString(), Convert.ToInt32(reader[4]), data);
t.Click += new System.EventHandler(this.trackLabel_Click);
t.Text = reader[1].ToString();
MyPl_track_table.Controls.Add(t, 0, MyPl_track_table.RowCount - 1);
}
reader.Close();
}
private void tab_panel_SelectedIndexChanged(object sender, EventArgs e)
{
TabControl tc;
tc = (TabControl)sender;
//MessageBox.Show(tc.SelectedIndex.ToString());
switch (tc.SelectedIndex)
{
case 0:
{ //news
News_track_table.Controls.Clear();
string sql = "SELECT * from tracks;";
MySqlCommand command = new MySqlCommand(sql, conn);
MySqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
byte[] data = ((byte[])reader.GetValue(6));
TrackLabel t = new TrackLabel(reader[1].ToString(), reader[2].ToString(), reader[3].ToString(), Convert.ToInt32(reader[4]), data);
t.Click += new System.EventHandler(this.trackLabel_Click);
t.Text = reader[1].ToString();
News_track_table.Controls.Add(t, 0, Tr_track_table.RowCount - 1);
}
reader.Close();
break;
}
case 1:
{ //charts
Charts_track_table.Controls.Clear();
string sql = "SELECT * FROM tracks ORDER BY countListens DESC LIMIT 10; ";
MySqlCommand command = new MySqlCommand(sql, conn);
MySqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
byte[] data = ((byte[])reader.GetValue(6));
TrackLabel t = new TrackLabel(reader[1].ToString(), reader[2].ToString(), reader[3].ToString(), Convert.ToInt32(reader[4]), data);
t.Click += new System.EventHandler(this.trackLabel_Click);
t.Text = reader[1].ToString();
Charts_track_table.Controls.Add(t, 0, Tr_track_table.RowCount - 1);
}
reader.Close();
break;
}
case 2:
{ //Artists
Art_artisits_table.Controls.Clear();
string sql = "SELECT * FROM `group`;";
MySqlCommand command = new MySqlCommand(sql, conn);
MySqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
GroupLabel t = new GroupLabel(reader[0].ToString(), reader[1].ToString(), reader[2].ToString());
t.Click += new System.EventHandler(this.groupLabel_Click);
t.Text = reader[1].ToString();
Art_artisits_table.Controls.Add(t, 0, Art_artisits_table.RowCount - 1);
}
reader.Close();
break;
}
case 3:
{ //Tracks
Tr_track_table.Controls.Clear();
string sql = "SELECT * from tracks;";
MySqlCommand command = new MySqlCommand(sql, conn);
MySqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
byte[] data = ((byte[])reader.GetValue(6));
TrackLabel t = new TrackLabel(reader[1].ToString(), reader[2].ToString(), reader[3].ToString(), Convert.ToInt32(reader[4]), data);
t.Click += new System.EventHandler(this.trackLabel_Click);
t.Text = reader[1].ToString();
Tr_track_table.Controls.Add(t, 0, Tr_track_table.RowCount - 1);
}
reader.Close();
break;
}
case 4:
{ //Playlists
MyPl_pl_table.Controls.Clear();
string sql = "SELECT playlists.* FROM playlists INNER JOIN user_playlist ON user_playlist.idPlayList = playlists.idPlayLists LEFT JOIN user ON user_playlist.idUser = user.idUser WHERE user.idUser = "******" GROUP BY playlists.playListName";
MySqlCommand command = new MySqlCommand(sql, conn);
MySqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
PlaylistLabel t = new PlaylistLabel(reader[0].ToString(), reader[1].ToString());
t.Click += new System.EventHandler(this.playlistLabel_Click);
t.Text = reader[1].ToString();
MyPl_pl_table.Controls.Add(t, 0, MyPl_pl_table.RowCount - 1);
}
reader.Close();
break;
}
case 5:
{ //Settings
login_textBox.Text = usr_login;
password_textBox.Text = usr_pass;
//Bitmap t = new Bitmap(avatar_patch);
avatar_picturebox.Image = new Bitmap(avatar_patch);
//t.Dispose();
break;
}
}
}
