public static DataSet SearchByYear(string SearchPhrase)
{
string SQL;
if (SearchPhrase == "*")
{
SQL = "SELECT * FROM songs Order By song_year, song_name";
}
else
{
SearchPhrase = SearchPhrase.Replace("'", "''");
SQL = "SELECT * FROM songs WHERE song_year LIKE '%" + SearchPhrase + "%' Order By song_year, song_name";
}
return(ExtendedQuerying.ExecuteQuery(SQL, "songs"));
}
public static DataSet GetAlbumDetails(string album, string artist)
{
album = album.Replace("'", "''");
artist = artist.Replace("'", "''");
return(ExtendedQuerying.ExecuteQuery("SELECT * FROM Album WHERE album_name='" + album + "' AND artist='" + artist + "'", "Album"));
}
public static DataSet GetArtistDetails(string artist)
{
artist = artist.Replace("'", "''");
return(ExtendedQuerying.ExecuteQuery("SELECT * FROM artist WHERE artist_name='" + artist + "'", "Artist"));
}
public static DataSet GetTrackDetails(string track, string artist)
{
track = track.Replace("'", "''");
artist = artist.Replace("'", "''");
return(ExtendedQuerying.ExecuteQuery("SELECT * FROM songs WHERE song_name='" + track + "' AND artist='" + artist + "'", "Track"));
}
public static DataSet GetAllAds()
{
return(ExtendedQuerying.ExecuteQuery("SELECT adv_name, location FROM Advertisment", "Ads"));
}
public static DataSet GetAllClips()
{
return(ExtendedQuerying.ExecuteQuery("SELECT title, location FROM Clips", "Clips"));
}
public static DataSet GetTracks(string artist, string album)
{
artist = artist.Replace("'", "''");
album = album.Replace("'", "''");
return(ExtendedQuerying.ExecuteQuery("SELECT (artist + ' - ' + song_name) AS DisplayView,* FROM songs WHERE artist='" + artist + "' AND Album='" + album + "' ORDER BY song_name", "songs"));
}