public void InvoiceLineCountTest()
{
ICRUDTestDBContextProvider cRUDTestDBContextProvider = new CRUDTestDBContextProvider(Guid.NewGuid().ToString());
var context = cRUDTestDBContextProvider.GetContext();
var track = new Track {
TrackId = 1
};
var invoiceLine = new InvoiceLine {
InvoiceLineId = 1, TrackId = 1
};
context.Add(track);
context.Add(invoiceLine);
context.SaveChanges();
TrackBE trackBE = new TrackBE(cRUDTestDBContextProvider);
trackBE.Load(1);
Assert.IsTrue(trackBE.InvoiceLineCount == 1);
InvoiceLineBE invoiceLineBE = new InvoiceLineBE(cRUDTestDBContextProvider);
invoiceLineBE.New();
trackBE.AddToInvoiceLine(invoiceLineBE);
invoiceLineBE.Save();
TrackBE trackBE2 = new TrackBE(cRUDTestDBContextProvider);
trackBE2.Load(1);
Assert.IsTrue(trackBE2.InvoiceLineCount == 2);
}
public void GetInvoiceLinesTest()
{
ICRUDTestDBContextProvider cRUDTestDBContextProvider = new CRUDTestDBContextProvider(Guid.NewGuid().ToString());
var context = cRUDTestDBContextProvider.GetContext();
var track = new Track {
TrackId = 2
};
var track2 = new Track {
TrackId = 1
};
var invoiceLine = new InvoiceLine {
InvoiceLineId = 1, TrackId = 1, Quantity = 10
};
context.Add(track);
context.Add(track2);
context.Add(invoiceLine);
context.SaveChanges();
TrackBE trackBE = new TrackBE(cRUDTestDBContextProvider);
TrackBE trackBE2 = new TrackBE(cRUDTestDBContextProvider);
trackBE.Load(1);
trackBE2.Load(2);
var invoiceLineBECollection = trackBE.GetInvoiceLines();
Assert.IsTrue(invoiceLineBECollection.First().GetType() == typeof(InvoiceLineBE));
Assert.IsTrue(invoiceLineBECollection.First().Quantity == 10);
Assert.IsTrue(invoiceLineBECollection.First().Id == 1);
Assert.IsTrue(trackBE2.GetInvoiceLines().IsNullOrEmpty());
}
public void AddToInvoiceLineTest()
{
ICRUDTestDBContextProvider cRUDTestDBContextProvider = new CRUDTestDBContextProvider(Guid.NewGuid().ToString());
var context = cRUDTestDBContextProvider.GetContext();
var track = new Track {
TrackId = 1
};
var invoiceLine = new InvoiceLine {
InvoiceLineId = 1, Quantity = 20
};
context.Add(track);
context.Add(invoiceLine);
context.SaveChanges();
InvoiceLineBE invoiceLineBE = new InvoiceLineBE(cRUDTestDBContextProvider);
TrackBE trackBE = new TrackBE(cRUDTestDBContextProvider);
trackBE.Load(1);
invoiceLineBE.Load(1);
trackBE.AddToInvoiceLine(invoiceLineBE);
invoiceLineBE.Save();
trackBE.Load(1);
var InvoiceLineBECollection = trackBE.GetInvoiceLines();
Assert.IsTrue(InvoiceLineBECollection.First().Id == 1);
Assert.IsTrue(InvoiceLineBECollection.First().TrackId == 1);
}
public void SaveValidIdTest()
{
ICRUDTestDBContextProvider cRUDTestDBContextProvider = new CRUDTestDBContextProvider(Guid.NewGuid().ToString());
var context = cRUDTestDBContextProvider.GetContext();
var track = new Track {
TrackId = 1
};
context.Add(track);
context.SaveChanges();
TrackBE trackBE = new TrackBE(cRUDTestDBContextProvider);
trackBE.Load(1);
trackBE.Name = "TestTrackName";
trackBE.Composer = "TestComposer";
trackBE.Milliseconds = 1000;
trackBE.Save();
TrackBE trackBE2 = new TrackBE(cRUDTestDBContextProvider);
trackBE2.Load(1);
Assert.IsTrue(trackBE2.Id == 1);
Assert.IsTrue(trackBE2.Name == "TestTrackName");
Assert.IsTrue(trackBE2.Composer == "TestComposer");
Assert.IsTrue(trackBE2.Milliseconds == 1000);
}
public void TrackCountTest()
{
ICRUDTestDBContextProvider cRUDTestDBContextProvider = new CRUDTestDBContextProvider(Guid.NewGuid().ToString());
var context = cRUDTestDBContextProvider.GetContext();
var genre = new Genre
{
GenreId = 1
};
var track = new Track {
TrackId = 1, GenreId = 1, Name = "TestTrackName"
};
context.Add(genre);
context.Add(track);
context.SaveChanges();
GenreBE genreBE = new GenreBE(cRUDTestDBContextProvider);
genreBE.Load(1);
Assert.IsTrue(genreBE.TrackCount == 1);
TrackBE trackBE = new TrackBE(cRUDTestDBContextProvider);
trackBE.New();
trackBE.Name = "TestName";
genreBE.AddToTrack(trackBE);
trackBE.Save();
GenreBE genreBE2 = new GenreBE(cRUDTestDBContextProvider);
genreBE2.Load(1);
Assert.IsTrue(genreBE2.TrackCount == 2);
}
public void AddToTrackTest()
{
ICRUDTestDBContextProvider cRUDTestDBContextProvider = new CRUDTestDBContextProvider(Guid.NewGuid().ToString());
var context = cRUDTestDBContextProvider.GetContext();
var genre = new Genre
{
GenreId = 1
};
var track = new Track {
TrackId = 1, Name = "TestTrackName"
};
context.Add(genre);
context.Add(track);
context.SaveChanges();
TrackBE trackBE = new TrackBE(cRUDTestDBContextProvider);
GenreBE genreBE = new GenreBE(cRUDTestDBContextProvider);
trackBE.Load(1);
genreBE.Load(1);
genreBE.AddToTrack(trackBE);
trackBE.Save();
genreBE.Load(1);
var TrackBECollection = genreBE.GetTracks();
Assert.IsTrue(TrackBECollection.First().Id == 1);
Assert.IsTrue(TrackBECollection.First().GenreId == 1);
}
public void SaveWithoutIdTest()
{
ICRUDTestDBContextProvider cRUDTestDBContextProvider = new CRUDTestDBContextProvider(Guid.NewGuid().ToString());
TrackBE trackBE = new TrackBE(cRUDTestDBContextProvider);
trackBE.New();
trackBE.Name = "TestTrackName";
trackBE.Save();
Assert.IsTrue(trackBE.Id != default);
}
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);
}
public void ToStringTest()
{
ICRUDTestDBContextProvider cRUDTestDBContextProvider = new CRUDTestDBContextProvider(Guid.NewGuid().ToString());
var context = cRUDTestDBContextProvider.GetContext();
var track = new Track {
TrackId = 1, Name = "TestName"
};
context.Add(track);
context.SaveChanges();
TrackBE trackBE = new TrackBE(cRUDTestDBContextProvider);
trackBE.Load(1);
Assert.IsTrue(trackBE.ToString().Equals("Title: TestName"));
}
public void AddToAlbumTest()
{
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"
};
context.Add(playlist);
context.Add(track);
context.SaveChanges();
PlaylistBE playlistBE = new PlaylistBE(cRUDTestDBContextProvider);
TrackBE trackBE = new TrackBE(cRUDTestDBContextProvider);
PlaylistTrackBE playlistTrackBE = new PlaylistTrackBE(cRUDTestDBContextProvider);
playlistBE.Load(1);
trackBE.Load(1);
playlistTrackBE.New();
playlistBE.AddToPlaylistTrack(playlistTrackBE);
trackBE.AddToPlaylistTrack(playlistTrackBE);
playlistTrackBE.Save();
playlistBE.Load(1);
var playlistTrackCollection = playlistBE.GetPlaylistTracks();
Assert.IsTrue(playlistTrackCollection.First().Id == (1, 1));
Assert.IsTrue(playlistTrackCollection.First().PlaylistName == "TestPlaylistName");
}
public void LoadValidIdTest()
{
ICRUDTestDBContextProvider cRUDTestDBContextProvider = new CRUDTestDBContextProvider(Guid.NewGuid().ToString());
var context = cRUDTestDBContextProvider.GetContext();
var track = new Track
{
TrackId = 1,
Name = "TestTrackName",
Composer = "TestComposer",
Milliseconds = 1000,
AlbumId = 1,
MediaTypeId = 1,
GenreId = 1
};
var track2 = new Track
{
TrackId = 2,
Name = "TestTrackName",
Composer = "TestComposer",
Milliseconds = 1000,
};
var track3 = new Track
{
TrackId = 3,
Name = "TestTrackName",
Composer = "TestComposer",
Milliseconds = 1000,
AlbumId = 3,
MediaTypeId = 3,
GenreId = 3
};
var album = new Album {
AlbumId = 1, Title = "TestTitle"
};
var mediaType = new MediaType {
MediaTypeId = 1, Name = "TestMediaType"
};
var genre = new Genre {
GenreId = 1, Name = "TestGenre"
};
var album3 = new Album {
AlbumId = 3, Title = "TestTitle"
};
var mediaType3 = new MediaType {
MediaTypeId = 3
};
var genre3 = new Genre {
GenreId = 3
};
context.Add(album);
context.Add(mediaType);
context.Add(genre);
context.Add(track);
context.Add(track2);
context.Add(track3);
context.Add(album3);
context.Add(mediaType3);
context.Add(genre3);
context.SaveChanges();
TrackBE trackBE = new TrackBE(cRUDTestDBContextProvider);
trackBE.Load(1);
Assert.IsTrue(trackBE.Id == 1);
Assert.IsTrue(trackBE.Name == "TestTrackName");
Assert.IsTrue(trackBE.Composer == "TestComposer");
Assert.IsTrue(trackBE.Milliseconds == 1000);
Assert.IsTrue(trackBE.AlbumId == 1);
Assert.IsTrue(trackBE.MediaTypeId == 1);
Assert.IsTrue(trackBE.GenreId == 1);
Assert.IsTrue(trackBE.AlbumTitle == "TestTitle");
Assert.IsTrue(trackBE.MediaTypeName == "TestMediaType");
Assert.IsTrue(trackBE.GenreName == "TestGenre");
TrackBE trackBE2 = new TrackBE(cRUDTestDBContextProvider);
trackBE2.Load(2);
Assert.IsTrue(trackBE2.Id == 2);
Assert.IsTrue(trackBE2.Name == "TestTrackName");
Assert.IsTrue(trackBE2.Composer == "TestComposer");
Assert.IsTrue(trackBE2.Milliseconds == 1000);
TrackBE trackBE3 = new TrackBE(cRUDTestDBContextProvider);
trackBE3.Load(3);
Assert.IsTrue(trackBE3.Id == 3);
Assert.IsTrue(trackBE3.Name == "TestTrackName");
Assert.IsTrue(trackBE3.Composer == "TestComposer");
Assert.IsTrue(trackBE3.Milliseconds == 1000);
Assert.IsTrue(trackBE3.AlbumTitle == "TestTitle");
}
