public void AddToInvoiceTest()
{
ICRUDTestDBContextProvider cRUDTestDBContextProvider = new CRUDTestDBContextProvider(Guid.NewGuid().ToString());
var context = cRUDTestDBContextProvider.GetContext();
var customerAddToInvoiceTest = new Customer {
CustomerId = 1
};
var invoiceAddToInvoiceTest = new Invoice {
InvoiceId = 1, Total = 20
};
context.Add(customerAddToInvoiceTest);
context.Add(invoiceAddToInvoiceTest);
context.SaveChanges();
CustomerBE customerBE = new CustomerBE(cRUDTestDBContextProvider);
InvoiceBE invoiceBE = new InvoiceBE(cRUDTestDBContextProvider);
invoiceBE.Load(1);
customerBE.Load(1);
customerBE.AddToInvoice(invoiceBE);
invoiceBE.Save();
customerBE.Load(1);
var InvoiceBECollection = customerBE.GetInvoices().Where(p => p.Id == 1);
Assert.IsTrue(InvoiceBECollection.First().Id == 1);
Assert.IsTrue(InvoiceBECollection.First().CustomerID == 1);
}
public void AddToTrackTest()
{
ICRUDTestDBContextProvider cRUDTestDBContextProvider = new CRUDTestDBContextProvider(Guid.NewGuid().ToString());
var context = cRUDTestDBContextProvider.GetContext();
var mediaType = new MediaType
{
MediaTypeId = 1
};
var track = new Track {
TrackId = 1, Name = "TestTrackName"
};
context.Add(mediaType);
context.Add(track);
context.SaveChanges();
TrackBE trackBE = new TrackBE(cRUDTestDBContextProvider);
MediaTypeBE mediaTypeBE = new MediaTypeBE(cRUDTestDBContextProvider);
mediaTypeBE.Load(1);
trackBE.Load(1);
mediaTypeBE.AddToTrack(trackBE);
trackBE.Save();
mediaTypeBE.Load(1);
var TrackBECollection = mediaTypeBE.GetTracks();
Assert.IsTrue(TrackBECollection.First().Id == 1);
Assert.IsTrue(TrackBECollection.First().MediaTypeId == 1);
}
public void LoadValidIdTest()
{
ICRUDTestDBContextProvider cRUDTestDBContextProvider = new CRUDTestDBContextProvider(Guid.NewGuid().ToString());
var context = cRUDTestDBContextProvider.GetContext();
var mediaType = new MediaType
{
Name = "TestMediaTypeName",
MediaTypeId = 1
};
var mediaType2 = new MediaType
{
MediaTypeId = 2
};
context.Add(mediaType);
context.Add(mediaType2);
context.SaveChanges();
MediaTypeBE mediaTypeBE = new MediaTypeBE(cRUDTestDBContextProvider);
mediaTypeBE.Load(1);
Assert.IsTrue(mediaTypeBE.Id == 1);
Assert.IsTrue(mediaTypeBE.Name == "TestMediaTypeName");
MediaTypeBE mediaTypeBE2 = new MediaTypeBE(cRUDTestDBContextProvider);
mediaTypeBE2.Load(2);
Assert.IsTrue(mediaTypeBE2.Id == 2);
}
public void AddToTrackTest()
{
ICRUDTestDBContextProvider cRUDTestDBContextProvider = new CRUDTestDBContextProvider(Guid.NewGuid().ToString());
var context = cRUDTestDBContextProvider.GetContext();
var album = new Album
{
Title = "TestAlbumTitle",
AlbumId = 1
};
var track = new Track {
TrackId = 1, Name = "TestTrackName"
};
context.Add(album);
context.Add(track);
context.SaveChanges();
TrackBE trackBE = new TrackBE(cRUDTestDBContextProvider);
AlbumBE albumBE = new AlbumBE(cRUDTestDBContextProvider);
albumBE.Load(1);
trackBE.Load(1);
albumBE.AddToTrack(trackBE);
trackBE.Save();
albumBE.Load(1);
var TrackBECollection = albumBE.GetTracks();
Assert.IsTrue(TrackBECollection.First().Id == 1);
Assert.IsTrue(TrackBECollection.First().AlbumId == 1);
}
public void SaveValidIdTest()
{
ICRUDTestDBContextProvider cRUDTestDBContextProvider = new CRUDTestDBContextProvider(Guid.NewGuid().ToString());
var context = cRUDTestDBContextProvider.GetContext();
var album = new Album
{
Title = "TestAlbumTitle",
AlbumId = 1
};
context.Add(album);
context.SaveChanges();
AlbumBE albumBE = new AlbumBE(cRUDTestDBContextProvider);
albumBE.Load(1);
albumBE.Title = "TestAlbumTitleChanged";
albumBE.Save();
AlbumBE albumBE2 = new AlbumBE(cRUDTestDBContextProvider);
albumBE2.Load(1);
Assert.IsTrue(albumBE2.Id == 1);
Assert.IsTrue(albumBE2.Title == "TestAlbumTitleChanged");
}
public void GetTrackBEsFullTest()
{
ICRUDTestDBContextProvider cRUDTestDBContextProvider = new CRUDTestDBContextProvider(Guid.NewGuid().ToString());
var context = cRUDTestDBContextProvider.GetContext();
var track = new Track
{
Name = "TestTrackName",
TrackId = 1
};
var track2 = new Track
{
Name = "TestTrackName",
TrackId = 2
};
context.Add(track);
context.Add(track2);
context.SaveChanges();
var tracks = new Business(cRUDTestDBContextProvider).GetTrackBEs();
Assert.IsTrue(tracks.First().GetType() == typeof(TrackBE));
Assert.IsTrue(tracks.First().Name == "TestTrackName");
Assert.IsTrue(tracks.Count() == 2);
}
public void GetCustomerBEsFullTest()
{
ICRUDTestDBContextProvider cRUDTestDBContextProvider = new CRUDTestDBContextProvider(Guid.NewGuid().ToString());
var context = cRUDTestDBContextProvider.GetContext();
var customer = new Customer
{
FirstName = "TestFirstName",
CustomerId = 1
};
var customer2 = new Customer
{
FirstName = "TestFirstName",
CustomerId = 2
};
context.Add(customer);
context.Add(customer2);
context.SaveChanges();
var customers = new Business(cRUDTestDBContextProvider).GetCustomerBEs();
Assert.IsTrue(customers.First().GetType() == typeof(CustomerBE));
Assert.IsTrue(customers.First().FirstName == "TestFirstName");
Assert.IsTrue(customers.Count() == 2);
}
public void GetInvoiceLinesTest()
{
ICRUDTestDBContextProvider cRUDTestDBContextProvider = new CRUDTestDBContextProvider(Guid.NewGuid().ToString());
var context = cRUDTestDBContextProvider.GetContext();
var invoiceGetInvoiceLinesTest = new Invoice {
InvoiceId = 4
};
var invoiceGetInvoiceLinesTest2 = new Invoice {
InvoiceId = 1
};
var invoiceLineGetInvoiceLinesTest = new InvoiceLine {
InvoiceLineId = 1, InvoiceId = 4, Quantity = 10
};
context.Add(invoiceGetInvoiceLinesTest);
context.Add(invoiceGetInvoiceLinesTest2);
context.Add(invoiceLineGetInvoiceLinesTest);
context.SaveChanges();
InvoiceBE invoiceBE = new InvoiceBE(cRUDTestDBContextProvider);
InvoiceBE invoiceBE2 = new InvoiceBE(cRUDTestDBContextProvider);
invoiceBE.Load(4);
invoiceBE2.Load(1);
var invoiceLineBECollection = invoiceBE.GetInvoiceLines();
Assert.IsTrue(invoiceLineBECollection.First().GetType() == typeof(InvoiceLineBE));
Assert.IsTrue(invoiceLineBECollection.First().Quantity == 10);
Assert.IsTrue(invoiceLineBECollection.First().Id == 1);
Assert.IsTrue(invoiceBE2.GetInvoiceLines().IsNullOrEmpty());
}
public void AddToInvoiceLineTest()
{
ICRUDTestDBContextProvider cRUDTestDBContextProvider = new CRUDTestDBContextProvider(Guid.NewGuid().ToString());
var context = cRUDTestDBContextProvider.GetContext();
var invoiceAddToInvoiceLineTest = new Invoice {
InvoiceId = 5
};
var invoiceLineAddToInvoiceLineTest = new InvoiceLine {
InvoiceLineId = 2, Quantity = 20
};
context.Add(invoiceAddToInvoiceLineTest);
context.Add(invoiceLineAddToInvoiceLineTest);
context.SaveChanges();
InvoiceLineBE invoiceLineBE = new InvoiceLineBE(cRUDTestDBContextProvider);
InvoiceBE invoiceBE = new InvoiceBE(cRUDTestDBContextProvider);
invoiceBE.Load(5);
invoiceLineBE.Load(2);
invoiceBE.AddToInvoiceLine(invoiceLineBE);
invoiceLineBE.Save();
invoiceBE.Load(5);
var InvoiceLineBECollection = invoiceBE.GetInvoiceLines().Where(p => p.Id == 2);
Assert.IsTrue(InvoiceLineBECollection.First().Id == 2);
Assert.IsTrue(InvoiceLineBECollection.First().InvoiceId == 5);
}
public void AddToEmployeeTest()
{
ICRUDTestDBContextProvider cRUDTestDBContextProvider = new CRUDTestDBContextProvider(Guid.NewGuid().ToString());
var context = cRUDTestDBContextProvider.GetContext();
var employee1 = new Employee {
EmployeeId = 1, FirstName = "Test1First", LastName = "Test1Last"
};
var employee2 = new Employee {
EmployeeId = 2, FirstName = "Test2First", LastName = "Test2Last"
};
context.Add(employee1);
context.Add(employee2);
context.SaveChanges();
EmployeeBE employeeBE = new EmployeeBE(cRUDTestDBContextProvider);
EmployeeBE employeeBE2 = new EmployeeBE(cRUDTestDBContextProvider);
employeeBE.Load(1);
employeeBE2.Load(2);
employeeBE2.AddSubordinate(employeeBE);
employeeBE.Save();
employeeBE.Load(1);
var employeeBECollection = employeeBE2.GetReportsToThisEmployee();
Assert.IsTrue(employeeBECollection.First().Id == 1);
Assert.IsTrue(employeeBECollection.First().ReportsTo == 2);
}
public void ReportsToCountTest()
{
ICRUDTestDBContextProvider cRUDTestDBContextProvider = new CRUDTestDBContextProvider(Guid.NewGuid().ToString());
var context = cRUDTestDBContextProvider.GetContext();
var employee = new Employee {
EmployeeId = 1, ReportsTo = 3, FirstName = "TestFirst", LastName = "TestLast", Email = "Test"
};
var employee2 = new Employee {
EmployeeId = 2, FirstName = "Test2First", LastName = "Test2Last", Email = "2Test"
};
var employeeReportedTo = new Employee {
EmployeeId = 3, FirstName = "Test3First", LastName = "Test3Last", Email = "3Test"
};
context.Add(employee);
context.Add(employee2);
context.Add(employeeReportedTo);
context.SaveChanges();
EmployeeBE employeeBE = new EmployeeBE(cRUDTestDBContextProvider);
employeeBE.Load(3);
Assert.IsTrue(employeeBE.ReportsToCount == 1);
EmployeeBE employeeBE2 = new EmployeeBE(cRUDTestDBContextProvider);
employeeBE2.Load(2);
employeeBE.AddSubordinate(employeeBE2);
employeeBE2.Save();
EmployeeBE employeeBE3 = new EmployeeBE(cRUDTestDBContextProvider);
employeeBE3.Load(3);
Assert.IsTrue(employeeBE3.ReportsToCount == 2);
}
public void CustomerCountTest()
{
ICRUDTestDBContextProvider cRUDTestDBContextProvider = new CRUDTestDBContextProvider(Guid.NewGuid().ToString());
var context = cRUDTestDBContextProvider.GetContext();
var customer = new Customer {
CustomerId = 1, SupportRepId = 1, FirstName = "TestFirst", LastName = "TestLast", Email = "Test"
};
var customer2 = new Customer {
CustomerId = 2, FirstName = "Test2First", LastName = "Test2Last", Email = "2Test"
};
var employee = new Employee {
EmployeeId = 1, FirstName = "TesteFirst", LastName = "TesteLast", Email = "eTest"
};
context.Add(customer);
context.Add(customer2);
context.Add(employee);
context.SaveChanges();
EmployeeBE employeeBE = new EmployeeBE(cRUDTestDBContextProvider);
employeeBE.Load(1);
Assert.IsTrue(employeeBE.CustomerCount == 1);
CustomerBE customerBE = new CustomerBE(cRUDTestDBContextProvider);
customerBE.Load(2);
employeeBE.AddToCustomer(customerBE);
customerBE.Save();
EmployeeBE employeeBE2 = new EmployeeBE(cRUDTestDBContextProvider);
employeeBE2.Load(1);
Assert.IsTrue(employeeBE2.CustomerCount == 2);
}
public void AddToCustomersTest()
{
ICRUDTestDBContextProvider cRUDTestDBContextProvider = new CRUDTestDBContextProvider(Guid.NewGuid().ToString());
var context = cRUDTestDBContextProvider.GetContext();
var customer = new Customer {
CustomerId = 1, FirstName = "TestFirst", LastName = "TestLast", Email = "Test"
};
var employee = new Employee {
EmployeeId = 1, FirstName = "TesteFirst", LastName = "TesteLast", Email = "eTest"
};
context.Add(customer);
context.Add(employee);
context.SaveChanges();
CustomerBE customerBE = new CustomerBE(cRUDTestDBContextProvider);
EmployeeBE employeeBE = new EmployeeBE(cRUDTestDBContextProvider);
employeeBE.Load(1);
customerBE.Load(1);
employeeBE.AddToCustomer(customerBE);
customerBE.Save();
employeeBE.Load(1);
var customerBECollection = employeeBE.GetCustomers();
Assert.IsTrue(customerBECollection.First().Id == 1);
Assert.IsTrue(customerBECollection.First().SupportRepId == 1);
}
public void InvoiceCountTest()
{
ICRUDTestDBContextProvider cRUDTestDBContextProvider = new CRUDTestDBContextProvider(Guid.NewGuid().ToString());
var context = cRUDTestDBContextProvider.GetContext();
var invoiceInvoiceCountTest = new Invoice {
InvoiceId = 1, CustomerId = 1
};
var customerInvoiceCountTest = new Customer {
CustomerId = 1
};
context.Add(invoiceInvoiceCountTest);
context.Add(customerInvoiceCountTest);
context.SaveChanges();
CustomerBE customerBE = new CustomerBE(cRUDTestDBContextProvider);
customerBE.Load(1);
Assert.IsTrue(customerBE.InvoiceCount == 1);
InvoiceBE invoiceBE = new InvoiceBE(cRUDTestDBContextProvider);
invoiceBE.New();
customerBE.AddToInvoice(invoiceBE);
invoiceBE.Save();
CustomerBE customerBE2 = new CustomerBE(cRUDTestDBContextProvider);
customerBE2.Load(1);
Assert.IsTrue(customerBE2.InvoiceCount == 2);
}
public void GetInvoiceLineBEsFullTest()
{
ICRUDTestDBContextProvider cRUDTestDBContextProvider = new CRUDTestDBContextProvider(Guid.NewGuid().ToString());
var context = cRUDTestDBContextProvider.GetContext();
var invoiceLine = new InvoiceLine
{
Quantity = 10,
InvoiceLineId = 1
};
var invoiceLine2 = new InvoiceLine
{
Quantity = 10,
InvoiceLineId = 2
};
context.Add(invoiceLine);
context.Add(invoiceLine2);
context.SaveChanges();
var invoiceLines = new Business(cRUDTestDBContextProvider).GetInvoiceLineBEs();
Assert.IsTrue(invoiceLines.First().GetType() == typeof(InvoiceLineBE));
Assert.IsTrue(invoiceLines.First().Quantity == 10);
Assert.IsTrue(invoiceLines.Count() == 2);
}
public void InvoiceLineCountTest()
{
ICRUDTestDBContextProvider cRUDTestDBContextProvider = new CRUDTestDBContextProvider(Guid.NewGuid().ToString());
var context = cRUDTestDBContextProvider.GetContext();
var invoiceInvoiceLineCountTest = new Invoice {
InvoiceId = 6
};
var invoiceLineInvoiceLineCountTest = new InvoiceLine {
InvoiceLineId = 3, InvoiceId = 6
};
context.Add(invoiceInvoiceLineCountTest);
context.Add(invoiceLineInvoiceLineCountTest);
context.SaveChanges();
InvoiceBE invoiceBe = new InvoiceBE(cRUDTestDBContextProvider);
invoiceBe.Load(6);
Assert.IsTrue(invoiceBe.InvoiceLineCount == 1);
InvoiceLineBE invoiceLineBE = new InvoiceLineBE(cRUDTestDBContextProvider);
invoiceLineBE.New();
invoiceBe.AddToInvoiceLine(invoiceLineBE);
invoiceLineBE.Save();
InvoiceBE invoiceBe2 = new InvoiceBE(cRUDTestDBContextProvider);
invoiceBe2.Load(6);
Assert.IsTrue(invoiceBe2.InvoiceLineCount == 2);
}
public void GetMediaTypeBEsFullTest()
{
ICRUDTestDBContextProvider cRUDTestDBContextProvider = new CRUDTestDBContextProvider(Guid.NewGuid().ToString());
var context = cRUDTestDBContextProvider.GetContext();
var mediaType = new MediaType
{
Name = "TestMediaTypeName",
MediaTypeId = 1
};
var mediaType2 = new MediaType
{
Name = "TestMediaTypeName",
MediaTypeId = 2
};
context.Add(mediaType);
context.Add(mediaType2);
context.SaveChanges();
var mediaTypes = new Business(cRUDTestDBContextProvider).GetMediaTypeBEs();
Assert.IsTrue(mediaTypes.First().GetType() == typeof(MediaTypeBE));
Assert.IsTrue(mediaTypes.First().Name == "TestMediaTypeName");
Assert.IsTrue(mediaTypes.Count() == 2);
}
public void LoadValidIdTest()
{
ICRUDTestDBContextProvider cRUDTestDBContextProvider = new CRUDTestDBContextProvider(Guid.NewGuid().ToString());
var context = cRUDTestDBContextProvider.GetContext();
var customer = new Customer
{
CustomerId = 2,
FirstName = "TestFirstName",
LastName = "TestLastName",
Email = "*****@*****.**"
};
var invoiceLoadValidIdTest = new Invoice {
CustomerId = 2, InvoiceId = 2, BillingAddress = "123 Test Street"
};
context.Add(customer);
context.Add(invoiceLoadValidIdTest);
context.SaveChanges();
InvoiceBE invoiceBE = new InvoiceBE(cRUDTestDBContextProvider);
invoiceBE.Load(2);
Assert.IsTrue(invoiceBE.Id == 2);
Assert.IsTrue(invoiceBE.BillingAddress == "123 Test Street");
Assert.IsTrue(invoiceBE.CustomerFirstName == "TestFirstName");
Assert.IsTrue(invoiceBE.CustomerLastName == "TestLastName");
}
public void GetArtistBEsFullTest()
{
ICRUDTestDBContextProvider cRUDTestDBContextProvider = new CRUDTestDBContextProvider(Guid.NewGuid().ToString());
var context = cRUDTestDBContextProvider.GetContext();
var artist = new Artist
{
Name = "TestArtistName",
ArtistId = 1
};
var artist2 = new Artist
{
Name = "TestArtistName",
ArtistId = 2
};
context.Add(artist);
context.Add(artist2);
context.SaveChanges();
var artists = new Business(cRUDTestDBContextProvider).GetArtistBEs();
Assert.IsTrue(artists.First().GetType() == typeof(ArtistBE));
Assert.IsTrue(artists.First().Name == "TestArtistName");
Assert.IsTrue(artists.Count() == 2);
}
public void SaveValidIdTest()
{
ICRUDTestDBContextProvider cRUDTestDBContextProvider = new CRUDTestDBContextProvider(Guid.NewGuid().ToString());
var context = cRUDTestDBContextProvider.GetContext();
var invoiceSaveValidIdTest = new Invoice {
InvoiceId = 3
};
context.Add(invoiceSaveValidIdTest);
context.SaveChanges();
InvoiceBE invoiceBE = new InvoiceBE(cRUDTestDBContextProvider);
invoiceBE.Load(3);
invoiceBE.BillingAddress = "234 Test Street";
invoiceBE.BillingCity = "TestCity 232";
invoiceBE.BillingCountry = "TestCountry 43534";
invoiceBE.BillingPostalCode = "TestPC23";
invoiceBE.BillingState = "TestState 2324";
invoiceBE.InvoiceDate = new DateTime(2020, 1, 1);
invoiceBE.Total = 10;
invoiceBE.Save();
InvoiceBE invoiceBE2 = new InvoiceBE(cRUDTestDBContextProvider);
invoiceBE2.Load(3);
Assert.IsTrue(invoiceBE2.BillingAddress == "234 Test Street");
Assert.IsTrue(invoiceBE2.BillingCity == "TestCity 232");
Assert.IsTrue(invoiceBE2.BillingCountry == "TestCountry 43534");
Assert.IsTrue(invoiceBE2.BillingPostalCode == "TestPC23");
Assert.IsTrue(invoiceBE2.BillingState == "TestState 2324");
Assert.IsTrue(DateTime.Compare(invoiceBE2.InvoiceDate, new DateTime(2020, 1, 1)) == 0);
Assert.IsTrue(invoiceBE2.Total == 10);
}
public void SaveValidIdTest()
{
ICRUDTestDBContextProvider cRUDTestDBContextProvider = new CRUDTestDBContextProvider(Guid.NewGuid().ToString());
var context = cRUDTestDBContextProvider.GetContext();
var invoiceLineLoadValidIdTest = new InvoiceLine {
InvoiceLineId = 1
};
context.Add(invoiceLineLoadValidIdTest);
context.SaveChanges();
InvoiceLineBE invoiceLineBE = new InvoiceLineBE(cRUDTestDBContextProvider);
invoiceLineBE.Load(1);
invoiceLineBE.Quantity = 15;
invoiceLineBE.UnitPrice = 10;
invoiceLineBE.Save();
InvoiceLineBE invoiceLineBE2 = new InvoiceLineBE(cRUDTestDBContextProvider);
invoiceLineBE2.Load(1);
Assert.IsTrue(invoiceLineBE2.Id == 1);
Assert.IsTrue(invoiceLineBE2.Quantity == 15);
Assert.IsTrue(invoiceLineBE2.UnitPrice == 10);
}
public void ValidationExceptionOnNotValidTest()
{
ICRUDTestDBContextProvider cRUDTestDBContextProvider = new CRUDTestDBContextProvider(Guid.NewGuid().ToString());
var businessEntityStub = new BusinessEntityStub <TEntityStub, int>(cRUDTestDBContextProvider);
businessEntityStub.Save();
}
public void TrackCountTest()
{
ICRUDTestDBContextProvider cRUDTestDBContextProvider = new CRUDTestDBContextProvider(Guid.NewGuid().ToString());
var context = cRUDTestDBContextProvider.GetContext();
var album = new Album
{
Title = "TestAlbumTitle",
AlbumId = 1
};
var track = new Track {
TrackId = 1, AlbumId = 1, Name = "TestTrackName"
};
context.Add(album);
context.Add(track);
context.SaveChanges();
AlbumBE albumBE = new AlbumBE(cRUDTestDBContextProvider);
albumBE.Load(1);
Assert.IsTrue(albumBE.TrackCount == 1);
TrackBE trackBE = new TrackBE(cRUDTestDBContextProvider);
trackBE.New();
trackBE.Name = "TestName";
albumBE.AddToTrack(trackBE);
trackBE.Save();
AlbumBE albumBE2 = new AlbumBE(cRUDTestDBContextProvider);
albumBE2.Load(1);
Assert.IsTrue(albumBE2.TrackCount == 2);
}
public void GetEmployeeBEsFullTest()
{
ICRUDTestDBContextProvider cRUDTestDBContextProvider = new CRUDTestDBContextProvider(Guid.NewGuid().ToString());
var context = cRUDTestDBContextProvider.GetContext();
var employee = new Employee
{
FirstName = "TestFirstName",
EmployeeId = 1
};
var employee2 = new Employee
{
FirstName = "TestFirstName",
EmployeeId = 2
};
context.Add(employee);
context.Add(employee2);
context.SaveChanges();
var employees = new Business(cRUDTestDBContextProvider).GetEmployeeBEs();
Assert.IsTrue(employees.First().GetType() == typeof(EmployeeBE));
Assert.IsTrue(employees.First().FirstName == "TestFirstName");
Assert.IsTrue(employees.Count() == 2);
}
public void LoadValidIdTest()
{
ICRUDTestDBContextProvider cRUDTestDBContextProvider = new CRUDTestDBContextProvider(Guid.NewGuid().ToString());
var context = cRUDTestDBContextProvider.GetContext();
var playlist = new Playlist
{
Name = "TestPlaylistName",
PlaylistId = 1
};
var playlist2 = new Playlist
{
PlaylistId = 2
};
context.Add(playlist);
context.Add(playlist2);
context.SaveChanges();
PlaylistBE playlistBE = new PlaylistBE(cRUDTestDBContextProvider);
playlistBE.Load(1);
Assert.IsTrue(playlistBE.Id == 1);
Assert.IsTrue(playlistBE.Name == "TestPlaylistName");
PlaylistBE playlistBE2 = new PlaylistBE(cRUDTestDBContextProvider);
playlistBE2.Load(2);
Assert.IsTrue(playlistBE2.Id == 2);
}
public void GetAlbumBEsFullTest()
{
ICRUDTestDBContextProvider cRUDTestDBContextProvider = new CRUDTestDBContextProvider(Guid.NewGuid().ToString());
var context = cRUDTestDBContextProvider.GetContext();
var album = new Album
{
Title = "TestAlbumTitle",
AlbumId = 1
};
var album2 = new Album
{
Title = "TestAlbumTitle",
AlbumId = 2
};
context.Add(album);
context.Add(album2);
context.SaveChanges();
var albums = new Business(cRUDTestDBContextProvider).GetAlbumBEs();
Assert.IsTrue(albums.First().GetType() == typeof(AlbumBE));
Assert.IsTrue(albums.First().Title == "TestAlbumTitle");
Assert.IsTrue(albums.Count() == 2);
}
public void TrackCountTest()
{
ICRUDTestDBContextProvider cRUDTestDBContextProvider = new CRUDTestDBContextProvider(Guid.NewGuid().ToString());
var context = cRUDTestDBContextProvider.GetContext();
var mediaType = new MediaType
{
MediaTypeId = 1
};
var track = new Track {
TrackId = 1, MediaTypeId = 1, Name = "TestTrackName"
};
context.Add(mediaType);
context.Add(track);
context.SaveChanges();
MediaTypeBE mediaTypeBE = new MediaTypeBE(cRUDTestDBContextProvider);
mediaTypeBE.Load(1);
Assert.IsTrue(mediaTypeBE.TrackCount == 1);
TrackBE trackBE = new TrackBE(cRUDTestDBContextProvider);
trackBE.New();
trackBE.Name = "TestName";
mediaTypeBE.AddToTrack(trackBE);
trackBE.Save();
MediaTypeBE mediaTypeBE2 = new MediaTypeBE(cRUDTestDBContextProvider);
mediaTypeBE2.Load(1);
Assert.IsTrue(mediaTypeBE2.TrackCount == 2);
}
public void GetInvoiceBEsFullTest()
{
ICRUDTestDBContextProvider cRUDTestDBContextProvider = new CRUDTestDBContextProvider(Guid.NewGuid().ToString());
var context = cRUDTestDBContextProvider.GetContext();
var invoice = new Invoice
{
BillingAddress = "TestAddress",
InvoiceId = 1
};
var invoice2 = new Invoice
{
BillingAddress = "TestAddress",
InvoiceId = 2
};
context.Add(invoice);
context.Add(invoice2);
context.SaveChanges();
var invoices = new Business(cRUDTestDBContextProvider).GetInvoiceBEs();
Assert.IsTrue(invoices.First().GetType() == typeof(InvoiceBE));
Assert.IsTrue(invoices.First().BillingAddress == "TestAddress");
Assert.IsTrue(invoices.Count() == 2);
}
public void GetTracksTest()
{
ICRUDTestDBContextProvider cRUDTestDBContextProvider = new CRUDTestDBContextProvider(Guid.NewGuid().ToString());
var context = cRUDTestDBContextProvider.GetContext();
var mediaType = new MediaType
{
MediaTypeId = 1
};
var mediaType2 = new MediaType
{
MediaTypeId = 2
};
var track = new Track {
TrackId = 1, MediaTypeId = 1, Name = "TestTrackName"
};
context.Add(mediaType);
context.Add(mediaType2);
context.Add(track);
context.SaveChanges();
MediaTypeBE mediaTypeBE = new MediaTypeBE(cRUDTestDBContextProvider);
mediaTypeBE.Load(1);
MediaTypeBE mediaTypeBE2 = new MediaTypeBE(cRUDTestDBContextProvider);
mediaTypeBE2.Load(2);
var TrackBECollection = mediaTypeBE.GetTracks();
Assert.IsTrue(TrackBECollection.First().GetType() == typeof(TrackBE));
Assert.IsTrue(TrackBECollection.First().Name == "TestTrackName");
Assert.IsTrue(TrackBECollection.First().Id == 1);
Assert.IsTrue(mediaTypeBE2.GetTracks().IsNullOrEmpty());
}
public void GetInvoicesTest()
{
ICRUDTestDBContextProvider cRUDTestDBContextProvider = new CRUDTestDBContextProvider(Guid.NewGuid().ToString());
var context = cRUDTestDBContextProvider.GetContext();
var invoiceGetInvoicesTest = new Invoice {
InvoiceId = 1, CustomerId = 1, Total = 10
};
var customerGetInvoicesTest = new Customer {
CustomerId = 1
};
var customer2GetInvoicesTest = new Customer {
CustomerId = 2
};
context.Add(invoiceGetInvoicesTest);
context.Add(customerGetInvoicesTest);
context.Add(customer2GetInvoicesTest);
context.SaveChanges();
CustomerBE customerBE = new CustomerBE(cRUDTestDBContextProvider);
CustomerBE customerBE2 = new CustomerBE(cRUDTestDBContextProvider);
customerBE.Load(1);
customerBE2.Load(2);
var invoiceBECollection = customerBE.GetInvoices();
Assert.IsTrue(invoiceBECollection.First().GetType() == typeof(InvoiceBE));
Assert.IsTrue(invoiceBECollection.First().Total == 10);
Assert.IsTrue(invoiceBECollection.First().Id == 1);
Assert.IsTrue(customerBE2.GetInvoices().IsNullOrEmpty());
}
