private void selectFollowed()
{
selectedTable = DBAccessor.selectAllWhere("Follows Join Playlist on Follows.PlaylistAuthor = Playlist.Author"
+ " AND Follows.PlaylistDateCreated = Playlist.DateCreated", "Follows.Username", this.CurrentUser);
dataGridView1.DataSource = new BindingSource(selectedTable, null);
dataGridView1.Columns["PlaylistAuthor"].Visible = false;
dataGridView1.Columns["PlaylistDateCreated"].Visible = false;
}
private void UpdateTables()
{
DataTable dt = DBAccessor.selectAllWhere("PlaylistView", "[Playlist Name]", PlaylistName);
CurrentTable = dt;
this.CurrentPlaylistDataGrid.DataSource = new BindingSource(dt, null);
dt = DBAccessor.selectAllTable("MediaView");
this.AllMediaDataGrid.DataSource = new BindingSource(dt, null);
}
private void expandPlaylistToolStripMenuItem_Click_1(object sender, EventArgs e)
{
int index = GetSelectedRowNumber();
if (index == -1)
{
return;
}
selectedTable = DBAccessor.selectAllWhere("PlaylistView", "Author = '" + this.CurrentUser +
"' and [Playlist Name]", (string)this.dataGridView1.Rows[index].Cells["Name"].Value);
dataGridView1.DataSource = new BindingSource(selectedTable, null);
dataGridView1.Columns["MediaFilepath"].Visible = false;
}
public void SetPlaylist(string PlaylistName)
{
this.PlaylistName = PlaylistName;
this.PlaylistNameBox.Text = PlaylistName;
DataTable dt = DBAccessor.selectAllWhere("PlaylistView", "[Playlist Name]", PlaylistName);
foreach (DataRow dr in dt.Rows)
{
if (((int)dr["PlaylistIndex"]) > this.PlaylistSize)
{
this.PlaylistSize = (int)dr["PlaylistIndex"];
}
}
UpdateTables();
}
public PlaylistEditor(string username, Boolean isCreation = false)
{
this.Username = username;
InitializeComponent();
if (isCreation)
{
this.PlaylistName = Interaction.InputBox("Enter playlist name:", "Playlist Editor", "");
this.PlaylistNameBox.Text = this.PlaylistName;
CreatePlaylist();
UpdateTables();
DataTable dt = DBAccessor.selectAllWhere("PlaylistView", "[Playlist Name]", PlaylistName);
foreach (DataRow dr in dt.Rows)
{
if (((int)dr["PlaylistIndex"]) > this.PlaylistSize)
{
this.PlaylistSize = (int)dr["PlaylistIndex"];
}
}
}
}
private void myReviewsToolStripMenuItem_Click(object sender, EventArgs e)
{
this.selectedTable = DBAccessor.selectAllWhere("Reviews", "Username", this.CurrentUser);
dataGridView1.DataSource = new BindingSource(selectedTable, null);
}
