public static List <TrackModel> SearchTracs(string search)
{
using (var conn = ConnectionFactory())
{
var adapter = new BeautifulMusicDataSetTableAdapters.TrackTableAdapter {
Connection = conn
};
adapter.FillBySearch(MusicDataSet.Track, search);
return(MusicDataSet.Track.DataTableToList <TrackModel>());
}
}
public static void SaveNewPlayList(PlaylistModel model)
{
if (CurrentUser == null)
{
return;
}
string name = model.Name;
using (var conn = ConnectionFactory())
{
var adapter = new BeautifulMusicDataSetTableAdapters.PlaylistTableAdapter {
Connection = conn
};
List <TrackModel> tracks = new List <TrackModel>();
var listId = adapter.GetPlayListByName(name);
int.TryParse(listId + "", out int id);
if (id > 0)
{
var trackTableAdapter = new BeautifulMusicDataSetTableAdapters.TrackTableAdapter
{
Connection = conn
};
trackTableAdapter.FillByPlayList(MusicDataSet.Track, id);
tracks = MusicDataSet.Track.DataTableToList <TrackModel>();
}
else
{
var row = MusicDataSet.Playlist.NewPlaylistRow();
row.Name = name;
row.UserId = CurrentUser.Id;
MusicDataSet.Playlist.AddPlaylistRow(row);
adapter.Update(row);
id = row.Id;
}
model.Id = id;
TrackModels.Select(x => x.Id)
.Except(tracks.Select(x => x.Id))
.Distinct()
.ToList()
.ForEach(
x =>
{
var row = MusicDataSet.PlaylistTrack.NewPlaylistTrackRow();
row.PlaylistId = id;
row.TrackId = x;
MusicDataSet.PlaylistTrack.AddPlaylistTrackRow(row);
});
var playlistTrackTableAdapter = new BeautifulMusicDataSetTableAdapters.PlaylistTrackTableAdapter
{
Connection = conn
};
playlistTrackTableAdapter.Update(MusicDataSet.PlaylistTrack);
}
}
public static List <TrackModel> GetTraks()
{
using (var conn = ConnectionFactory())
{
var adapter = new BeautifulMusicDataSetTableAdapters.TrackTableAdapter {
Connection = conn
};
adapter.Fill(MusicDataSet.Track);
return(MusicDataSet.Track.DataTableToList <TrackModel>());
}
}
public static List <TrackModel> GetTracksByGenre(int id)
{
using (var conn = ConnectionFactory())
{
var adapter = new BeautifulMusicDataSetTableAdapters.TrackTableAdapter {
Connection = conn
};
adapter.FillByPlayList(MusicDataSet.Track, id);
return(MusicDataSet.Track.DataTableToList <TrackModel>());
}
}
public static ObservableCollection <TrackModel> GetTracksByPlayList(int id)
{
var tracks = new ObservableCollection <TrackModel>();
using (var conn = ConnectionFactory())
{
var adapter = new BeautifulMusicDataSetTableAdapters.TrackTableAdapter {
Connection = conn
};
adapter.FillByPlayList(MusicDataSet.Track, id);
MusicDataSet.Track.DataTableToList <TrackModel>().ForEach(x => tracks.Add(x));
return(tracks);
}
}
