public void AddToPlaylistTrackTest()
{
ICRUDTestDBContextProvider cRUDTestDBContextProvider = new CRUDTestDBContextProvider(Guid.NewGuid().ToString());
var context = cRUDTestDBContextProvider.GetContext();
var track = new Track {
TrackId = 1
};
var playlist = new Playlist {
PlaylistId = 1
};
context.Add(track);
context.Add(playlist);
context.SaveChanges();
PlaylistTrackBE playlistTrackBE = new PlaylistTrackBE(cRUDTestDBContextProvider);
TrackBE trackBE = new TrackBE(cRUDTestDBContextProvider);
PlaylistBE playlistBE = new PlaylistBE(cRUDTestDBContextProvider);
trackBE.Load(1);
playlistBE.Load(1);
playlistTrackBE.New();
trackBE.AddToPlaylistTrack(playlistTrackBE);
playlistBE.AddToPlaylistTrack(playlistTrackBE);
playlistTrackBE.Save();
trackBE.Load(1);
var playlistTrackBECollection = trackBE.GetPlaylistTracks();
Assert.IsTrue(playlistTrackBECollection.First().PlaylistId == 1);
Assert.IsTrue(playlistTrackBECollection.First().TrackId == 1);
}
public IEnumerable <PlaylistTrackBE> GetPlaylistTracks()
{
var ids = Context.PlaylistTrack.Where(p => p.TrackId == Id)
.Select(p => new { p.PlaylistId, p.TrackId })
.ToList()
.Select(p => ((int)p.PlaylistId, (int)p.TrackId));
foreach (var id in ids)
{
var item = new PlaylistTrackBE(CRUDTestDBContextProvider);
item.Load(id, id.Item1, id.Item2);
yield return(item);
}
}
public void PlaylistTrackCountTest()
{
ICRUDTestDBContextProvider cRUDTestDBContextProvider = new CRUDTestDBContextProvider(Guid.NewGuid().ToString());
var context = cRUDTestDBContextProvider.GetContext();
var playlist = new Playlist
{
PlaylistId = 1,
Name = "TestPlaylistName"
};
var track = new Track
{
TrackId = 1,
Name = "TestTrackName"
};
var track2 = new Track
{
TrackId = 2,
Name = "TestTrackName"
};
var playlistTrack = new PlaylistTrack
{
PlaylistId = 1,
TrackId = 1
};
context.Add(playlist);
context.Add(track);
context.Add(track2);
context.Add(playlistTrack);
context.SaveChanges();
PlaylistBE playlistBE = new PlaylistBE(cRUDTestDBContextProvider);
playlistBE.Load(1);
Assert.IsTrue(playlistBE.PlaylistTrackCount == 1);
PlaylistTrackBE playlistTrackBE = new PlaylistTrackBE(cRUDTestDBContextProvider);
TrackBE trackBE = new TrackBE(cRUDTestDBContextProvider);
playlistTrackBE.New();
trackBE.Load(2);
playlistBE.AddToPlaylistTrack(playlistTrackBE);
trackBE.AddToPlaylistTrack(playlistTrackBE);
playlistTrackBE.Save();
PlaylistBE playlistBE3 = new PlaylistBE(cRUDTestDBContextProvider);
playlistBE3.Load(1);
Assert.IsTrue(playlistBE3.PlaylistTrackCount == 2);
}
/// <summary>
/// Return all PlaylistTrackBEs
/// </summary>
/// <returns></returns>
public IEnumerable <PlaylistTrackBE> GetPlaylistTrackBEs()
{
using var context = cRUDTestDBContextProvider.GetContext();
foreach (var id in context.PlaylistTrack
.Select(p => new { p.PlaylistId, p.TrackId })
.ToList()
.Select(p => ((int)p.PlaylistId, (int)p.TrackId)))
{
PlaylistTrackBE playlistTrackBE = new PlaylistTrackBE(cRUDTestDBContextProvider);
playlistTrackBE.Load(id, id.Item1, id.Item2);
yield return(playlistTrackBE);
}
}
public void AddToPlaylistTrack(PlaylistTrackBE playlistTrack)
{
playlistTrack.AssignTo(this);
}
