protected void songssoldstatistics(object sender, EventArgs e)
{
statsSelected = songstatsdropdown.Text;
if (songstatsdropdown.Text == "defaultstats")
{
SongStatistics.Visible = false;
TotalSongsByGenre.Visible = false;
}
if (songstatsdropdown.Text == "songtitles")
{
SongStatistics.Visible = true;
TotalSongsByGenre.Visible = false;
SongStatistics.DataSource = dBConnect.GetDataSet("SELECT * FROM dbo.Songs ORDER BY TotalPurchases DESC");
SongStatistics.DataBind();
}
if (songstatsdropdown.Text == "genre")
{
SongStatistics.Visible = false;
TotalSongsByGenre.Visible = true;
TotalSongsByGenre.DataSource = dBConnect.GetDataSet("SELECT Genre, SUM (TotalPurchases) FROM dbo.Songs GROUP BY Genre");
TotalSongsByGenre.DataBind();
}
}
public void RemoveRecord(SongStatistic record)
{
SongStatistics.Remove(record);
}
public void AddRecord(SongStatistic record)
{
SongStatistics.Add(record);
}
