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()); }
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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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); }