public static List <string> GetAlbumInfo(string album)
{
try {
List <string> array = DBMusicDatabase.GetAlbumInfo(DBSQLQueries.GetAlbumInfo(), album);
return(array);
} catch (Exception ex) {
throw ex;
}
}
public static string GetAlbumName(string track)
{
try {
string albumName = DBMusicDatabase.GetAlbumName(DBSQLQueries.GetAlbumName(), track);
return(albumName);
} catch (Exception ex) {
throw ex;
}
}
public static DataTable GetAlbums()
{
try {
DataTable albumsTable = DBMusicDatabase.GetTable(DBSQLQueries.GetAlbums(), "Albums");
return(albumsTable);
} catch (Exception ex) {
throw ex;
}
}
public static DataTable GetAlbumTracks(string name)
{
try {
DataTable trackTable = DBMusicDatabase.GetSpecificTable(DBSQLQueries.GetAlbumTracks(), name, "Tracks");
return(trackTable);
} catch (Exception ex) {
throw ex;
}
}
public static string GetTrackTubepath(string track)
{
try {
string tubepath = DBMusicDatabase.GetTrackTubepath(DBSQLQueries.GetTrackTubepath(), track);
return(tubepath);
} catch (Exception ex) {
throw ex;
}
}
public static DataTable GetArtistAlbums(string name)
{
try {
DataTable artistAlbums = DBMusicDatabase.GetSpecificTable(DBSQLQueries.GetArtistAlbums(), name, "ArtistPage");
return(artistAlbums);
} catch (Exception ex) {
throw ex;
}
}
public static string GetImageUrl(string album)
{
try {
string imageUrl = DBMusicDatabase.GetImageUrl(DBSQLQueries.GetImageUrl(), album);
return(imageUrl);
} catch (Exception ex) {
throw ex;
}
}
public static bool UpdatePassword(string username, string password)
{
try {
DBMusicDatabase.UpdatePassword(DBSQLQueries.UpdatePassword(), username, password);
return(true);
} catch (Exception ex) {
throw ex;
}
}
public static List <string> GetComboBoxArtists()
{
try {
List <string> comboArtists = DBMusicDatabase.GetCombobox(DBSQLQueries.GetComboBoxArtists());
return(comboArtists);
} catch (Exception ex) {
throw ex;
}
}
public static DataTable GetCompanies()
{
try {
DataTable companiesTable = DBMusicDatabase.GetTable(DBSQLQueries.GetCompanies(), "Companies");
return(companiesTable);
} catch (Exception ex) {
throw ex;
}
}
public static DataTable GetUsers()
{
try {
DataTable users = DBMusicDatabase.GetTable(DBSQLQueries.GetUsers(), "Users");
return(users);
} catch (Exception ex) {
throw ex;
}
}
public static bool UpdateUser(int key, string name, bool admin)
{
try {
DBMusicDatabase.UpdateUser(DBSQLQueries.UpdateUser(), key, name, admin);
return(true);
} catch (Exception ex) {
throw ex;
}
}
public static DataTable GetGenreTracks(string name)
{
try {
DataTable genreTracks = DBMusicDatabase.GetSpecificTable(DBSQLQueries.GetGenreTracks(), name, "Tracks");
return(genreTracks);
} catch (Exception ex) {
throw ex;
}
}
public static DataTable GetCompanyAlbums(string name)
{
try {
DataTable companyAlbums = DBMusicDatabase.GetSpecificTable(DBSQLQueries.GetCompanyAlbums(), name, "Albums");
return(companyAlbums);
} catch (Exception ex) {
throw ex;
}
}
public static DataTable GetTracks()
{
try {
DataTable tracksTable = DBMusicDatabase.GetTable(DBSQLQueries.GetTracks(), "Tracks");
return(tracksTable);
} catch (Exception ex) {
throw ex;
}
}
public static DataTable GetGenres()
{
try {
DataTable genresTable = DBMusicDatabase.GetTable(DBSQLQueries.GetGenres(), "Genres");
return(genresTable);
} catch (Exception ex) {
throw ex;
}
}
public static bool AddCompany(string name, string country, int year)
{
try {
string fill = "1";
DBMusicDatabase.AddRow(DBSQLQueries.AddCompany(), int.Parse(fill), name, fill, fill, fill, country, year, fill, fill, int.Parse(fill), fill, fill);
return(true);
} catch (Exception ex) {
throw ex;
}
}
public static bool UpdateArtist(int key, string name, string country, int year)
{
try {
string fill = "1";
DBMusicDatabase.UpdateRow(DBSQLQueries.UpdateArtist(), key, name, fill, fill, fill, country, year, fill, fill, int.Parse(fill), fill, fill);
return(true);
} catch (Exception ex) {
throw ex;
}
}
public static bool AddGenre(string name)
{
try {
string fill = "1";
DBMusicDatabase.AddRow(DBSQLQueries.AddGenre(), int.Parse(fill), name, fill, fill, fill, fill, int.Parse(fill), fill, fill, int.Parse(fill), fill, fill);
return(true);
} catch (Exception ex) {
throw ex;
}
}
public static bool UpdateTrack(int key, string name, string artist, int year, string album, string link, int number, string length, string genre)
{
try {
string fill = "1";
DBMusicDatabase.UpdateRow(DBSQLQueries.UpdateTrack(), key, name, artist, album, fill, fill, year, fill, link, number, length, genre);
return(true);
} catch (Exception ex) {
throw ex;
}
}
public static bool AddTrack(string name, string artist, int year, string album, string genre, string link, int number, string length)
{
try {
string fill = "1";
DBMusicDatabase.AddRow(DBSQLQueries.AddTrack(), int.Parse(fill), name, artist, album, fill, fill, year, fill, link, number, length, genre);
return(true);
} catch (Exception ex) {
throw ex;
}
}
public static bool UpdateGenre(int key, string name)
{
try {
string fill = "1";
DBMusicDatabase.UpdateRow(DBSQLQueries.UpdateGenre(), key, name, fill, fill, fill, fill, int.Parse(fill), fill, fill, int.Parse(fill), fill, fill);
return(true);
} catch (Exception ex) {
throw ex;
}
}
public static bool UpdateAlbum(int key, string name, string artist, string company, int year, string imageLink)
{
try {
string fill = "1";
DBMusicDatabase.UpdateRow(DBSQLQueries.UpdateAlbum(), key, name, artist, fill, company, fill, year, imageLink, fill, int.Parse(fill), fill, fill);
return(true);
} catch (Exception ex) {
throw ex;
}
}
public static bool DeleteUser(int key)
{
try {
int deleted = DBMusicDatabase.DeleteUser(DBSQLQueries.DeleteUser(), key);
if (deleted == 1)
{
return(true);
}
else
{
return(false);
}
} catch (Exception ex) {
throw ex;
}
}
public static DataTable SearchArtist(string srcparam)
{
DataTable resultTable = DBMusicDatabase.SearchTable(DBSQLQueries.SearchArtist(), srcparam, "Result");
return(resultTable);
}
