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")); }