public void addToRecent(int id)
{
if (!Shuffle)
{
SQLManager.getInstance().addRecent(id);
}
}
public static List <Song> getSongs()
{
List <Song> SongList = new List <Song>();
SqlCommand select = new SqlCommand("SELECT * FROM Songs;", SQLManager.getInstance().connection);
SqlDataReader reader = select.ExecuteReader();
while (reader.Read())
{
Song a = new Song();
a.File = reader["filePath"].ToString().Replace("@SQ", "\'");
a.Title = reader["title"].ToString().Replace("@SQ", "\'");
a.Artist = reader["artist"].ToString().Replace("@SQ", "\'");
a.Album = reader["album"].ToString().Replace("@SQ", "\'");
a.Year = Convert.ToInt32(reader["year"].ToString());
a.Comment = reader["comment"].ToString().Replace("@SQ", "\'");
a.Genre = reader["genre"].ToString();
SongList.Add(a);
}
reader.Close();
return(SongList);
}
private void LibraryView_FormClosing(object sender, FormClosingEventArgs e)
{
updateSettings();
if (playlistView)
{
return;
}
PlayerW.Player.controls.stop();
SQLManager.getInstance().CloseDB();
}
private void loadSettings()
{
int[] sett = SQLManager.getInstance().loadSettings();
for (int i = 0; i < sett.Length; i++)
{
if (sett[i] == 0)
{
songLibrary.Columns[i + 1].AutoResize(ColumnHeaderAutoResizeStyle.HeaderSize);
}
else
{
songLibrary.Columns[i + 1].Width = 0;
songLibViewOpts.Items[i].PerformClick();
}
}
}
private void updateSettings()
{
int[] sett = new int[5];
for (int i = 1; i < 6; i++)
{
if (songLibrary.Columns[i].Width != 0)
{
sett[i - 1] = 0;
}
else
{
sett[i - 1] = 1;
}
}
SQLManager.getInstance().UpdateSettings(sett);
}
private static void delete(int id)
{
if (SQLManager.getInstance().connection.State == ConnectionState.Closed)
{
throw new Exception("Not connected to the Database.");
}
try
{
SqlCommand delete = new SqlCommand("DELETE FROM Songs WHERE SongID = " + id.ToString() + ";", SQLManager.getInstance().connection);
delete.ExecuteNonQuery();
delete = new SqlCommand("DELETE FROM PlaylistSongs WHERE songID = " + id.ToString() + ";", SQLManager.getInstance().connection);
delete.ExecuteNonQuery();
delete = new SqlCommand("DELETE FROM Recent WHERE songID = " + id.ToString() + ";", SQLManager.getInstance().connection);
delete.ExecuteNonQuery();
}
catch { }
}
public static List <string> getAllPlaylists()
{
List <string> playlists = new List <string>();
try
{
SqlCommand select = new SqlCommand("SELECT * FROM Playlists;", SQLManager.getInstance().connection);
SqlDataReader reader = select.ExecuteReader();
while (reader.Read())
{
playlists.Add(HttpUtility.UrlDecode(reader["playlistName"].ToString()));
}
reader.Close();
}
catch
{ }
return(playlists);
}
private void loadRecent()
{
List <int> recent = SQLManager.getInstance().LoadRecent();
List <Song> Songs = new List <Song>();
for (int i = 0; i < recent.Count; i++)
{
Songs.Add(Library.getSongByID(recent[i]));
}
Songs.Reverse();
for (int i = 0; i < 10 && i < Songs.Count; i++)
{
ToolStripMenuItem recentSong = new ToolStripMenuItem(Songs[i].Title);
recentSong.Tag = Songs[i].File;
recentSong.Click += t_Click;
playRecentToolStripMenuItem.DropDownItems.Add(recentSong);
}
}
public static void deletePlaylist(int id)
{
try
{
SqlCommand delete = new SqlCommand("DELETE FROM PlaylistSongs WHERE playlistID = " + id.ToString() + ";", SQLManager.getInstance().connection);
delete.ExecuteNonQuery();
delete = new SqlCommand("DELETE FROM Playlists WHERE Id = " + id.ToString() + ";", SQLManager.getInstance().connection);
delete.ExecuteNonQuery();
}
catch { }
}
public static void deleteSong(string file)
{
int id = 0;
SqlCommand select = new SqlCommand("SELECT * FROM Songs WHERE filePath = '" + file.Replace("\'", "@SQ") + "';", SQLManager.getInstance().connection);
SqlDataReader reader = select.ExecuteReader();
reader.Read();
id = Convert.ToInt32(reader["SongID"].ToString());
reader.Close();
delete(id);
}
public static void insert(string f)
{
SQLManager.getInstance().Insert(f);
}
public static Song getSongByID(int id)
{
SqlCommand command = new SqlCommand("SELECT * FROM Songs WHERE SongID = " + id + ";", SQLManager.getInstance().connection);
SqlDataReader reader = command.ExecuteReader();
reader.Read();
Song a = new Song();
a.File = reader["filePath"].ToString().Replace("@SQ", "\'");
a.Title = reader["title"].ToString().Replace("@SQ", "\'");
a.Artist = reader["artist"].ToString().Replace("@SQ", "\'");
a.Album = reader["album"].ToString().Replace("@SQ", "\'");
a.Year = Convert.ToInt32(reader["year"].ToString());
a.Comment = reader["comment"].ToString().Replace("@SQ", "\'");
a.Genre = reader["genre"].ToString();
reader.Close();
return(a);
}
public static int getSongID(string path)
{
int SongID = 0;
SqlCommand command = new SqlCommand("SELECT * FROM Songs WHERE filePath = '" + path.Replace("\'", "@SQ") + "';", SQLManager.getInstance().connection);
SqlDataReader reader = command.ExecuteReader();
reader.Read();
SongID = Convert.ToInt32(reader["SongID"].ToString());
reader.Close();
return(SongID);
}
public static List <Song> getPlaylistContents(string name)
{
List <Song> SongList = new List <Song>();
int id = getPlaylistID(name);
SqlCommand select = new SqlCommand("SELECT * FROM PlaylistSongs WHERE playlistID = " + id + ";", SQLManager.getInstance().connection);
SqlDataReader reader = select.ExecuteReader();
List <int> SongIDSList = new List <int>();
while (reader.Read())
{
SongIDSList.Add(Convert.ToInt32(reader["songID"]));
}
reader.Close();
for (int i = 0; i < SongIDSList.Count; i++)
{
SongList.Add(Library.getSongByID(SongIDSList[i]));
}
return(SongList);
}
public static void addToPlalist(int listID, int songID)
{
SQLManager.getInstance().Execute("INSERT INTO PlaylistSongs (playlistID, songID) VALUES (" + listID + ", " + songID + ");");
}
public static void createPlaylist(string name)
{
try
{
SqlCommand create = new SqlCommand("INSERT INTO Playlists (playlistName) VALUES ('" + HttpUtility.UrlEncode(name) + "');", SQLManager.getInstance().connection);
create.ExecuteNonQuery();
}
catch { }
}
public static int getPlaylistID(string name)
{
int id = 0;
try
{
SqlCommand select = new SqlCommand("SELECT * FROM Playlists WHERE playlistName = '" + HttpUtility.UrlEncode(name) + "';", SQLManager.getInstance().connection);
SqlDataReader reader = select.ExecuteReader();
reader.Read();
id = Convert.ToInt32(reader["Id"].ToString());
reader.Close();
}
catch { }
return(id);
}
public static void DeleteFromPlaylist(int playlist, int songID)
{
SQLManager.getInstance().Execute("DELETE FROM PlaylistSongs WHERE playlistID = " + playlist + " AND songID = " + songID + ";");
}