private void UpdateInfo()
{
using (MusicAppContext data = new MusicAppContext())
{
listBox1.Items.Clear();
listBox1.Items.AddRange(data.Artist.Select(c => c.Name).ToArray());
listBox2.Items.Clear();
listBox2.Items.AddRange(data.Song.Select(c => new { Info = c.Title + " " + c.Album.Artist.Name }).ToArray());
listBox3.Items.Clear();
listBox3.Items.AddRange(data.Interactions.Where(c => c.UserId == LoggedIn.UserId).Select(c => new { Info = c.Song.Title + " Liked: " + c.Liked + " PlayCount: " + c.PlayCount }).ToArray());
cbArtisten.DataSource = data.Artist.Select(c => new { Id = c.ArtistId, NaamArtist = c.Name }).ToArray();;
cbArtisten.DisplayMember = "NaamArtist";
cbArtisten.ValueMember = "Id";
cbPlaylistPlaylist.DataSource = data.Playlists.Where(c => c.UserId == LoggedIn.UserId).Select(c => new { Id = c.PlaylistId, NamePlaylist = c.Name }).ToArray();
cbPlaylistPlaylist.DisplayMember = "NamePlaylist";
cbPlaylistPlaylist.ValueMember = "Id";
cbSongsPlaylist.DataSource = data.Song.Select(c => new { Id = c.SongId, NameSong = c.Title }).ToArray();
cbSongsPlaylist.DisplayMember = "NameSong";
cbSongsPlaylist.ValueMember = "Id";
cbAlbums.DataSource = data.Album.Select(c => new { Id = c.AlbumId, NameAlbum = c.Title }).ToArray();
cbAlbums.DisplayMember = "NameAlbum";
cbAlbums.ValueMember = "Id";
}
}
public ArtistTest()
{
var fixture = new TestFixture();
_context = fixture.Context;
_mapper = fixture.Mapper;
}
private void btnDelete_Click(object sender, EventArgs e)
{
using (MusicAppContext data = new MusicAppContext())
{
int songIdSelected = Convert.ToInt32(cbSongInPlaylistSelect.SelectedValue);
TestClass a = cbPlaylistSelect.SelectedItem as TestClass;
int vari = a.Id;
data.PlaylistSongs.Remove(data.PlaylistSongs.Where(c => c.PlaylistId == vari && c.SongId == songIdSelected).FirstOrDefault());
data.SaveChanges();
}
UpdateForm();
}
private void btnAddSong_Click(object sender, EventArgs e)
{
using (MusicAppContext data = new MusicAppContext())
{
data.Song.Add(new Song()
{
Title = tbSongName.Text, AlbumId = Convert.ToInt32(cbAlbums.SelectedValue), Lenght = Convert.ToInt32(nupdLengte.Value), CreatedAt = new DateTime().ToString("dd/MM/yyyy"), UpdatedAt = new DateTime().ToString("dd/MM/yyyy")
});
data.SaveChanges();
UpdateInfo();
}
}
private void btnAddAlbum_Click(object sender, EventArgs e)
{
using (MusicAppContext data = new MusicAppContext())
{
data.Album.Add(new Album()
{
ArtistId = Convert.ToInt32(cbArtisten.SelectedValue), Title = tbAlbumName.Text, Lenght = 0, CreatedAt = new DateTime().ToString("dd/MM/yyyy"), UpdatedAt = new DateTime().ToString("dd/MM/yyyy")
});
data.SaveChanges();
UpdateInfo();
}
}
private void btnAddArtist_Click(object sender, EventArgs e)
{
using (MusicAppContext data = new MusicAppContext())
{
data.Artist.Add(new Artist()
{
Name = tbArtistName.Text, CreatedAt = new DateTime().ToString("dd/MM/yyyy"), UpdatedAt = new DateTime().ToString("dd/MM/yyyy")
});
data.SaveChanges();
UpdateInfo();
}
}
private void btnAddPlaylist_Click(object sender, EventArgs e)
{
using (MusicAppContext data = new MusicAppContext())
{
data.Playlists.Add(new Playlist()
{
Name = tbPlaylist.Text, UserId = LoggedIn.UserId, CreatedAt = new DateTime().ToString("dd/MM/yyyy"), UpdatedAt = new DateTime().ToString("dd/MM/yyyy")
});
data.SaveChanges();
UpdateInfo();
}
}
private void btnSongToPlaylist_Click(object sender, EventArgs e)
{
using (MusicAppContext data = new MusicAppContext())
{
int Playlistid = Convert.ToInt32(cbPlaylistPlaylist.SelectedValue);
data.PlaylistSongs.Add(new PlaylistSongs()
{
PlaylistId = Playlistid, SongId = Convert.ToInt32(cbSongsPlaylist.SelectedValue)
});
data.Playlists.Where(c => c.PlaylistId == Playlistid).FirstOrDefault().UpdatedAt = new DateTime().ToString("dd/MM/yyyy");
data.SaveChanges();
UpdateInfo();
}
}
public Form4(User user)
{
LoggedIn = user;
InitializeComponent();
using (MusicAppContext data = new MusicAppContext())
{
cbPlaylistSelect.DataSource = data.Playlists.Where(c => c.UserId == LoggedIn.UserId).Select(c => new TestClass {
Id = c.PlaylistId, Name = c.Name
}).ToArray();
cbPlaylistSelect.DisplayMember = "PlaylistNaam";
cbPlaylistSelect.ValueMember = "Id";
}
UpdateForm();
}
private void btnLogIn_Click(object sender, EventArgs e)
{
Email = tbEmail.Text;
Password = tbPassword.Text;
using (MusicAppContext data = new MusicAppContext())
{
loginAtempt = data.User.Where(u => u.Email == Email && u.Password == Password).FirstOrDefault();
}
if (loginAtempt != null)
{
Program.OpenDetailFormOnClose = true;
using (Form3 form3 = new Form3(loginAtempt))
{
form3.ShowDialog();
}
}
}
public MusicAppContext CreateContext()
{
var options = new DbContextOptionsBuilder <MusicAppContext>()
.UseInMemoryDatabase(Guid.NewGuid().ToString())
.Options;
Context = new MusicAppContext(options);
Context.Database.EnsureCreated();
Context.Set <Artist>().AddRange(new[] {
new Artist("Michael Jackson", "The greates pop singer"),
new Artist("Queen", "Rock music"),
});
Context.SaveChanges();
return(Context);
}
private void btnSignUp_Click(object sender, EventArgs e)
{
using (Form2 form2 = new Form2())
{
switch (form2.ShowDialog())
{
case DialogResult.OK:
using (MusicAppContext data = new MusicAppContext())
{
data.User.Add(new User()
{
FirstName = form2.FirstName, LastName = form2.LastName, Email = form2.Email, Password = form2.Password
});
data.SaveChanges();
}
break;
}
}
}
private void btnPlay_Click(object sender, EventArgs e)
{
using (MusicAppContext data = new MusicAppContext())
{
int songIdSelected = Convert.ToInt32(cbSongInPlaylistSelect.SelectedValue);
var interaction = data.Interactions.Where(c => c.UserId == LoggedIn.UserId && c.SongId == songIdSelected).FirstOrDefault();
if (interaction == null)
{
data.Interactions.Add(new Interactions()
{
SongId = songIdSelected, PlayCount = 1, UserId = LoggedIn.UserId, CreatedAt = new DateTime().ToString("dd/MM/yyyy"), UpdatedAt = new DateTime().ToString("dd/MM/yyyy")
});
}
else
{
data.Interactions.Where(c => c.UserId == LoggedIn.UserId && c.SongId == songIdSelected).FirstOrDefault().PlayCount += 1;
}
data.SaveChanges();
}
}
private void UpdateForm()
{
using (MusicAppContext data = new MusicAppContext())
{
cbSongInPlaylistSelect.DataSource = null;
listBox1.DataSource = null;
TestClass a = cbPlaylistSelect.SelectedItem as TestClass;
int vari = a.Id;
var collection = data.PlaylistSongs.Where(p => p.PlaylistId == vari).Join(data.Song, p => p.SongId, s => s.SongId, (p, s) => new { SongId = s.SongId, SongName = s.Title }).ToArray();
cbSongInPlaylistSelect.DataSource = collection;
cbSongInPlaylistSelect.DisplayMember = "SongName";
cbSongInPlaylistSelect.ValueMember = "SongId";
cbSongs.DataSource = collection;
cbSongs.DisplayMember = "SongName";
cbSongs.ValueMember = "SongId";
listBox1.DataSource = collection;
listBox1.DisplayMember = "SongName";
listBox1.ValueMember = "SongId";
}
}
public UnitOfWork()
{
context = new MusicAppContext();
MusicRepository = new MusicRepositoryEFMemory(context);
OrderRepository = new OrderRipository(context);
}
public MusicLibraryService(MusicAppContext musicAppContext)
{
_musicAppContext = musicAppContext;
}
public MusicRepositoryEFMemory(MusicAppContext context)
{
this.context = context;
}
public ArtistRepository(MusicAppContext context) : base(context)
{
}
public UserRepository(MusicAppContext context) : base(context)
{
}
public AlbomRepository(MusicAppContext context) : base(context)
{
}
public static void Destroy(MusicAppContext context)
{
context.Database.EnsureDeleted();
context.Dispose();
}
public MusicController(MusicAppContext context)
{
_context = context;
}
public OrderRipository(MusicAppContext context)
{
_context = context;
}
