private void objectListView_MouseDoubleClick(object sender, MouseEventArgs e)
{
WMPPlayState playst = winmp.playState;
if (!(winmp.playState == WMPPlayState.wmppsStopped || winmp.playState == WMPPlayState.wmppsUndefined))
{
songTimer.Stop();
winmp.controls.stop();
}
ListView.SelectedListViewItemCollection selectedRow = objectListView.SelectedItems;
foreach (OLVListItem rowObject in selectedRow) //will be able to play multiple now
{
songTimer = new Timer();
LocalAudioItem rowItem = (LocalAudioItem)rowObject.RowObject;
switch (rowItem.readerFileExtension)
{
case ".wmv":
winmp.URL = rowItem.readerFilePath;
musicArea1.value = 0;
musicArea1.maxTime = (int)rowItem.readerLength;
songTimer.Start();
winmp.controls.play();
break;
}
}
}
public ArrayList GetSongsFromTable()
{
ArrayList audioItemList = new ArrayList();
if (GetRowCount() > 0)
{
using (connection = new SQLiteConnection("Data Source=LocalDatabase.sqlite3"))
{
using (SQLiteCommand getFromTableCommand = new SQLiteCommand())
{
getFromTableCommand.Connection = connection;
getFromTableCommand.CommandText = ("SELECT * FROM LocalMusicTable");
if (connection.State != System.Data.ConnectionState.Open)
{
connection.Open();
}
SQLiteDataReader reader = getFromTableCommand.ExecuteReader();
while (reader.Read())
{
long readerId = (Int64)reader["Id"];
string readerTitle = reader["Title"].ToString();
string readerArtist = reader["Artist"].ToString();
string readerAlbum = reader["Album"].ToString();
string readerPlaylist = reader["PlayList"].ToString();
int readerLength = (int)reader["Length"];
string readerGenre = reader["Genre"].ToString();
int readerPlays = (int)reader["Plays"];
string readerFileExtension = reader["FileExtension"].ToString();
string readerFilePath = reader["FilePath"].ToString();
LocalAudioItem audioItem = new LocalAudioItem(readerId, readerTitle, readerArtist, readerAlbum, readerPlaylist, readerLength, readerGenre, readerPlays, readerFileExtension, readerFilePath);
audioItemList.Add(audioItem);
}
}
}
}
return(audioItemList);
}
