public UnitofWork(MusicDBContext musicDBContext)
{
_musicDBContext = musicDBContext;
OutletRepository = new OutletRepository(_musicDBContext);
DeviceRepository = new DevicesRepository(_musicDBContext);
PlaylistRepository = new PlaylistRepository(_musicDBContext);
TrackRepository = new GenericRepository <Track>(_musicDBContext);
}
public UserAuthController(IUserRepository userRepository,
IPKIEncordeService pkiEncordeService,
MusicDBContext dbContext)
{
this.userRepository = userRepository;
this.pkiEncordeService = pkiEncordeService;
this.dbContext = dbContext;
}
public async Task GetCommentsAsyncShouldReturnAllComments()
{
using (var context = new MusicDBContext(options))
{
IMusicRepoDB _repo = new MusicRepoDB(context);
var comments = await _repo.GetCommentsAsync();
Assert.Equal(2, comments.Count);
}
}
public async Task GetUploadedMusicAsyncShouldReturnAllUploadedMusic()
{
using (var context = new MusicDBContext(options))
{
IMusicRepoDB _repo = new MusicRepoDB(context);
var uploadedMusic = await _repo.GetUploadedMusicAsync();
Assert.Equal(2, uploadedMusic.Count);
}
}
public async Task GetMusicPlaylistsAsyncShouldReturnAllMusicPlaylists()
{
using (var context = new MusicDBContext(options))
{
IMusicRepoDB _repo = new MusicRepoDB(context);
var musicPlaylists = await _repo.GetMusicPlaylistsAsync();
Assert.Equal(3, musicPlaylists.Count);
}
}
public async Task AddMusicPlaylistAsyncShouldAddMusicPlaylist()
{
using (var context = new MusicDBContext(options))
{
IMusicRepoDB _repo = new MusicRepoDB(context);
MusicPlaylist testMusicPlaylist = new MusicPlaylist();
testMusicPlaylist.PlayListId = 2;
testMusicPlaylist.MusicId = 1;
var newMusicPlaylist = await _repo.AddMusicPlaylistAsync(testMusicPlaylist);
Assert.NotNull(newMusicPlaylist);
Assert.Equal(2, newMusicPlaylist.PlayListId);
}
}
public async Task AddPlayListAsyncShouldAddPlayList()
{
using (var context = new MusicDBContext(options))
{
IMusicRepoDB _repo = new MusicRepoDB(context);
PlayList testPlayList = new PlayList();
testPlayList.UserId = 1;
testPlayList.Name = "Songs to git gud too";
var newPlayList = await _repo.AddPlayListAsync(testPlayList);
Assert.NotNull(newPlayList);
Assert.Equal("Songs to git gud too", newPlayList.Name);
}
}
public async Task AddCommentAsyncShouldAddComment()
{
using (var context = new MusicDBContext(options))
{
IMusicRepoDB _repo = new MusicRepoDB(context);
Comments testComment = new Comments();
testComment.Comment = "First Comment";
testComment.CommentData = DateTime.Parse("2021-03-15 18:17:00");
testComment.UserId = 2;
testComment.UploadMusicId = 1;
var newComment = await _repo.AddCommentAsync(testComment);
Assert.Equal("First Comment", newComment.Comment);
}
}
public async Task GetPlayListByIDAsyncShouldReturnPlayList()
{
using (var context = new MusicDBContext(options))
{
IMusicRepoDB _repo = new MusicRepoDB(context);
PlayList testPlayList = new PlayList();
testPlayList.Id = 4;
testPlayList.UserId = 1;
testPlayList.Name = "Songs to git gud too";
var newPlayList = await _repo.AddPlayListAsync(testPlayList);
var foundPlayList = await _repo.GetPlayListByIDAsync(4);
Assert.NotNull(foundPlayList);
Assert.Equal(4, foundPlayList.Id);
}
}
public async Task GetCommentByMusicIDAsyncShouldReturnComment()
{
using (var context = new MusicDBContext(options))
{
IMusicRepoDB _repo = new MusicRepoDB(context);
Comments testComment = new Comments();
testComment.Id = 1;
testComment.Comment = "First Comment";
testComment.CommentData = DateTime.Parse("2021-03-15 18:17:00");
testComment.UserId = 2;
testComment.UploadMusicId = 1;
var foundComment = await _repo.GetCommentsByMusicIDAsync(1);
Assert.Equal(1, testComment.Id);
}
}
public async Task AddUploadedMusicAsyncShouldAddUploadedMusic()
{
using (var context = new MusicDBContext(options))
{
IMusicRepoDB _repo = new MusicRepoDB(context);
UploadMusic testUploadMusic = new UploadMusic();
testUploadMusic.UserId = 1;
testUploadMusic.MusicFilePath = "cool_song";
testUploadMusic.Name = "Jumping Jacks";
testUploadMusic.UploadDate = DateTime.Parse("2021-03-15 18:17:00");
testUploadMusic.Likes = 3409;
testUploadMusic.Plays = 9084;
var newUploadMusic = await _repo.AddUploadedMusicAsync(testUploadMusic);
Assert.Equal("Jumping Jacks", newUploadMusic.Name);
}
}
public async Task UpdateMusicPlaylistAsyncShouldUpdateMusicPlaylist()
{
using (var context = new MusicDBContext(options))
{
IMusicRepoDB _repo = new MusicRepoDB(context);
MusicPlaylist testMusicPlaylist = new MusicPlaylist();
testMusicPlaylist.Id = 4;
testMusicPlaylist.PlayListId = 2;
testMusicPlaylist.MusicId = 1;
var newMusicPlaylist = await _repo.AddMusicPlaylistAsync(testMusicPlaylist);
testMusicPlaylist.PlayListId = 1;
var updateMusicPlaylist = await _repo.UpdateMusicPlaylistAsync(testMusicPlaylist);
Assert.Equal(1, updateMusicPlaylist.PlayListId);
}
}
public async Task GetMusicPlaylistByIDAsyncShouldReturnMusicPlaylist()
{
using (var context = new MusicDBContext(options))
{
IMusicRepoDB _repo = new MusicRepoDB(context);
MusicPlaylist testMusicPlaylist = new MusicPlaylist();
testMusicPlaylist.Id = 4;
testMusicPlaylist.PlayListId = 2;
testMusicPlaylist.MusicId = 1;
var newMusicPlaylist = await _repo.AddMusicPlaylistAsync(testMusicPlaylist);
var foundMusicPlaylist = await _repo.GetMusicPlaylistByIDAsync(4);
Assert.NotNull(foundMusicPlaylist);
Assert.Equal(4, foundMusicPlaylist.Id);
}
}
public async Task DeleteMusicPlaylistAsyncShouldDeleteMusicPlaylist()
{
using (var context = new MusicDBContext(options))
{
IMusicRepoDB _repo = new MusicRepoDB(context);
MusicPlaylist testMusicPlaylist = new MusicPlaylist();
testMusicPlaylist.Id = 4;
testMusicPlaylist.PlayListId = 2;
testMusicPlaylist.MusicId = 1;
var newMusicPlaylist = await _repo.AddMusicPlaylistAsync(testMusicPlaylist);
var deleteMusicPlaylist = await _repo.DeleteMusicPlaylistAsync(testMusicPlaylist);
using (var assertContext = new MusicDBContext(options))
{
var result = assertContext.MusicPlaylist.Find(4);
Assert.Null(result);
}
}
}
public async Task DeletePlayListAsyncShouldDeletePlayList()
{
using (var context = new MusicDBContext(options))
{
IMusicRepoDB _repo = new MusicRepoDB(context);
PlayList testPlayList = new PlayList();
testPlayList.Id = 4;
testPlayList.UserId = 1;
testPlayList.Name = "Songs to git gud too";
var newPlayList = await _repo.AddPlayListAsync(testPlayList);
var deletePlayList = await _repo.DeletePlayListAsync(testPlayList);
using (var assertContext = new MusicDBContext(options))
{
var result = assertContext.PlayList.Find(4);
Assert.Null(result);
}
}
}
// This method gets called by the runtime. Use this method to configure the HTTP request pipeline.
public void Configure(IApplicationBuilder app, IWebHostEnvironment env, MusicDBContext db)
{
//db.Database.EnsureDeleted();
db.Database.EnsureCreated();
if (env.IsDevelopment())
{
app.UseDeveloperExceptionPage();
}
app.UseHttpsRedirection();
app.UseRouting();
app.UseAuthorization();
app.UseEndpoints(endpoints =>
{
endpoints.MapControllers();
});
}
public async Task DeleteCommentAsyncShouldDeleteComment()
{
using (var context = new MusicDBContext(options))
{
IMusicRepoDB _repo = new MusicRepoDB(context);
Comments testComment = new Comments();
testComment.Id = 4;
testComment.Comment = "First Comment";
testComment.CommentData = DateTime.Parse("2021-03-15 18:17:00");
testComment.UserId = 2;
testComment.UploadMusicId = 1;
var newComment = await _repo.AddCommentAsync(testComment);
var deletedComment = await _repo.DeleteCommentAsync(testComment);
using (var assertContext = new MusicDBContext(options))
{
var result = await _repo.GetCommentByIDAsync(4);
Assert.Null(result);
}
}
}
public async Task UpdatePlayListAsyncShouldUpdatePlayList()
{
using (var context = new MusicDBContext(options))
{
IMusicRepoDB _repo = new MusicRepoDB(context);
PlayList testPlayList = new PlayList();
testPlayList.Id = 4;
testPlayList.UserId = 1;
testPlayList.Name = "Songs to git gud too";
ICollection <MusicPlaylist> playListMusicPlaylist = new List <MusicPlaylist>();
MusicPlaylist testMusicPlaylist = new MusicPlaylist();
testMusicPlaylist.Id = 4;
testMusicPlaylist.PlayListId = 2;
testMusicPlaylist.MusicId = 1;
playListMusicPlaylist.Add(testMusicPlaylist);
var newPlayList = await _repo.AddPlayListAsync(testPlayList);
var updatedPlayList = await _repo.UpdatePlayListAsync(testPlayList);
testPlayList.Name = "Git Gud";
Assert.Equal("Git Gud", updatedPlayList.Name);
}
}
public async Task DeleteUploadedMusicAsyncShouldDeleteUploadedMusic()
{
using (var context = new MusicDBContext(options))
{
IMusicRepoDB _repo = new MusicRepoDB(context);
UploadMusic testUploadMusic = new UploadMusic();
testUploadMusic.Id = 4;
testUploadMusic.UserId = 1;
testUploadMusic.MusicFilePath = "cool_song";
testUploadMusic.Name = "Jumping Jacks";
testUploadMusic.UploadDate = DateTime.Parse("2021-03-15 18:17:00");
testUploadMusic.Likes = 3409;
testUploadMusic.Plays = 9084;
var newUploadMusic = await _repo.AddUploadedMusicAsync(testUploadMusic);
var deletedUploadMusic = await _repo.DeleteUploadedMusicAsync(testUploadMusic);
using (var assertContext = new MusicDBContext(options))
{
var result = assertContext.UploadMusic.Find(4);
Assert.Null(result);
}
}
}
public NguoiDungDAO()
{
context = new MusicDBContext();
}
public MusicAssetRepository(MusicDBContext dbContext) : base(dbContext)
{
}
public TaiKhoanDAO()
{
context = new MusicDBContext();
}
public UserRepository(MusicDBContext dbContext) : base(dbContext)
{
}
public NgheSiDAO()
{
context = new MusicDBContext();
}
public VideoDAO()
{
context = new MusicDBContext();
}
public DevicesRepository(MusicDBContext musicDbContext) : base(musicDbContext)
{
_musicDbContext = musicDbContext;
}
public NgheSiYeuThichDAO()
{
context = new MusicDBContext();
}
public PlaylistRepository(MusicDBContext musicDbContext) : base(musicDbContext)
{
_musicDbContext = musicDbContext;
}
public MusicRepository()
{
dbContext = new MusicDBContext();
db = dbContext.Set <T>();
}
public SqlPlaylistsData(MusicDBContext context)
{
_context = context;
}
