public void TestCreateTrackCount()
{
var options = new DbContextOptionsBuilder <MusicSpotDbContext>().UseInMemoryDatabase("createTracksReturnCount").Options;
var dbContext = new MusicSpotDbContext(options);
var service = new TrackService(dbContext);
var track = new Track
{
Name = "Joni",
Duration = "4:44",
AlbumId = 4
};
for (int i = 1; i < 5; i++)
{
service.Create(track.Name, track.Duration, track.AlbumId);
dbContext.SaveChanges();
}
dbContext.SaveChanges();
int result = dbContext.Tracks.CountAsync().Result;
Assert.AreEqual(4, result);
Assert.AreNotEqual(16, result);
Assert.AreNotEqual("int", result);
Assert.That(result, Is.Not.Null);
Assert.That(track.Id, Is.Not.Null);
dbContext.Remove(track);
}
public void TestCreateMovieCount()
{
var options = new DbContextOptionsBuilder <MusicSpotDbContext>().UseInMemoryDatabase("createMovieReturnCount").Options;
var dbContext = new MusicSpotDbContext(options);
var service = new MovieService(dbContext);
var movie = new Movie
{
Title = "Speed",
Genre = "Action",
ImageUrl = "aaa",
Year = 1998,
Description = "some description",
UserId = "aaa"
};
for (int i = 1; i < 5; i++)
{
service.Create(movie.Title, movie.Genre, movie.ImageUrl, movie.Year, movie.Description, movie.UserId);
dbContext.SaveChanges();
}
dbContext.SaveChanges();
int result = dbContext.Movies.CountAsync().Result;
Assert.AreEqual(4, result);
Assert.AreNotEqual(14, result);
Assert.AreNotEqual("aa", result);
Assert.That(result, Is.Not.Null);
Assert.That(movie.Id, Is.Not.Null);
dbContext.Remove(movie);
}
public void TestCreateAlbumsCount()
{
var options = new DbContextOptionsBuilder <MusicSpotDbContext>().UseInMemoryDatabase("createAlbumsReturnCount").Options;
var dbContext = new MusicSpotDbContext(options);
var service = new AlbumService(dbContext);
var album = new Album
{
Name = "Joni",
ImageUrl = "aaaa",
Year = 2000,
Format = "LP",
MediaCondition = "G+",
SleeveCondition = "NM",
Notes = "some notes",
ArtistId = 7
};
for (int i = 1; i < 5; i++)
{
service.Create(album.Name, album.ImageUrl, album.Year, album.Format, album.MediaCondition, album.SleeveCondition, album.Notes, album.ArtistId);
dbContext.SaveChanges();
}
dbContext.SaveChanges();
int result = dbContext.Albums.CountAsync().Result;
Assert.AreEqual(4, result);
Assert.That(result, Is.Not.Null);
Assert.That(album.Id, Is.Not.Null);
dbContext.Remove(album);
}
public void TestCreateGamesCount()
{
var options = new DbContextOptionsBuilder <MusicSpotDbContext>().UseInMemoryDatabase("createGamesReturnCount").Options;
var dbContext = new MusicSpotDbContext(options);
var service = new GameService(dbContext);
var game = new Game
{
Title = "FIFA",
Genre = "Sport",
ImageUrl = "aaa",
Description = "some description",
UserId = "aaa"
};
for (int i = 1; i < 5; i++)
{
service.Create(game.Title, game.Genre, game.ImageUrl, game.Description, game.UserId);
dbContext.SaveChanges();
}
dbContext.SaveChanges();
int result = dbContext.Games.CountAsync().Result;
Assert.AreEqual(4, result);
Assert.That(result, Is.Not.Null);
Assert.That(game.Id, Is.Not.Null);
dbContext.Remove(game);
}
public void TestCreateBooksCount()
{
var options = new DbContextOptionsBuilder <MusicSpotDbContext>().UseInMemoryDatabase("createBooksReturnCount").Options;
var dbContext = new MusicSpotDbContext(options);
var service = new BookService(dbContext);
var book = new Book
{
Title = "It",
Genre = "Horror",
ImageUrl = "aaa",
Description = "some description",
UserId = "aaa"
};
for (int i = 1; i < 5; i++)
{
service.Create(book.Title, book.Genre, book.ImageUrl, book.Description, book.UserId);
dbContext.SaveChanges();
}
dbContext.SaveChanges();
int result = dbContext.Books.CountAsync().Result;
Assert.AreEqual(4, result);
Assert.That(result, Is.Not.Null);
Assert.That(book.Id, Is.Not.Null);
dbContext.Remove(book);
}
public bool Delete(int gameId)
{
var game = _context.Games.Find(gameId);
if (game == null)
{
return(false);
}
_context.Remove(game);
_context.SaveChangesAsync();
return(true);
}
public bool Delete(int albumId)
{
var album = _context.Albums.Find(albumId);
if (album == null)
{
return(false);
}
_context.Remove(album);
_context.SaveChangesAsync();
return(true);
}
public bool Delete(int artistId)
{
var artist = _context.Artists.Find(artistId);
if (artist == null)
{
return(false);
}
_context.Remove(artist);
_context.SaveChangesAsync();
return(true);
}
public bool Delete(int bookId)
{
var book = _context.Books.Find(bookId);
if (book == null)
{
return(false);
}
_context.Remove(book);
_context.SaveChangesAsync();
return(true);
}
public bool Delete(int movieId)
{
var movie = _context.Movies.Find(movieId);
if (movie == null)
{
return(false);
}
_context.Remove(movie);
_context.SaveChangesAsync();
return(true);
}
public bool Delete(int id)
{
var track = _context.Albums.Find(id);
if (track == null)
{
return(false);
}
_context.Remove(track);
_context.SaveChangesAsync();
return(true);
}