Пример #1
0
        private void btnCreate_Click(object sender, EventArgs e)
        {
            using (var ctx = new AccountContext())
            {
                var exists = ctx.Users.FirstOrDefault(u => u.Email == txtEmail.Text);
                if (exists == null)
                {
                    ctx.Users.Add(new User
                    {
                        FirstName = txtFirstName.Text,
                        LastName  = txtLastName.Text,
                        Email     = txtEmail.Text,
                        Password  = txtPassword.Text
                    });
                    MessageBox.Show("Your account has been created! Redirecting...");
                    ctx.SaveChanges();
                }
                else
                {
                    MessageBox.Show("This e-mail is already registered. Please log in or use a different e-mail");
                }
            }

            Close();
        }
Пример #2
0
 private void btnLogIn_Click(object sender, EventArgs e)
 {
     using (var ctx = new AccountContext())
     {
         var user = ctx.Users.FirstOrDefault(u => u.Email == txtEmail.Text);
         if (user == null)
         {
             MessageBox.Show("This e-mail is not registered.");
         }
         else
         {
             if (user.Password == txtPassword.Text)
             {
                 Global.UserId = user.Id;
                 MessageBox.Show("Successfully logged in. Redirecting...");
                 MainMenu main = new MainMenu();
                 Hide();
                 main.Show();
             }
             else
             {
                 MessageBox.Show("Incorrect password.");
             }
         }
     }
 }
Пример #3
0
 public AddAlbum()
 {
     InitializeComponent();
     using (var ctx = new AccountContext())
     {
         lstArtists.DataSource    = ctx.Artists.ToArray();
         lstArtists.DisplayMember = "Name";
         lstArtists.ValueMember   = "Id";
     }
 }
Пример #4
0
 public AddPlaylist()
 {
     InitializeComponent();
     using (var ctx = new AccountContext())
     {
         lstSongs.DataSource    = ctx.Songs.ToArray();
         lstSongs.DisplayMember = "Title";
         lstSongs.ValueMember   = "Id";
     }
     lstPlaylistSongs.DisplayMember = "Title";
     lstPlaylistSongs.ValueMember   = "Id";
 }
Пример #5
0
        private void btnAddArtist_Click(object sender, EventArgs e)
        {
            using (var ctx = new AccountContext())
            {
                ctx.Artists.Add(new Artist
                {
                    Name      = txtArtistName.Text,
                    CreatedAt = DateTime.Now,
                    UpdatedAt = DateTime.Now
                });
                ctx.SaveChanges();
            }
            MessageBox.Show($"{txtArtistName.Text} has been added.");
            Close();
            MainMenu main = new MainMenu();

            main.Show();
        }
Пример #6
0
        public MainMenu()
        {
            InitializeComponent();
            lvwSongs.View          = View.Details;
            lvwSongs.CheckBoxes    = true;
            lvwSongs.FullRowSelect = true;
            lvwSongs.HeaderStyle   = ColumnHeaderStyle.Nonclickable;

            ColumnHeader title = new ColumnHeader();

            title.Text      = "Title";
            title.TextAlign = HorizontalAlignment.Left;
            title.Width     = 100;
            lvwSongs.Columns.Add(title);

            ColumnHeader artist = new ColumnHeader();

            artist.Text      = "Artist";
            artist.TextAlign = HorizontalAlignment.Left;
            artist.Width     = 100;
            lvwSongs.Columns.Add(artist);

            ColumnHeader album = new ColumnHeader();

            album.Text      = "Album";
            album.TextAlign = HorizontalAlignment.Left;
            album.Width     = 100;
            lvwSongs.Columns.Add(album);

            ColumnHeader length = new ColumnHeader();

            length.Text      = "Length";
            length.TextAlign = HorizontalAlignment.Left;
            length.Width     = 100;
            lvwSongs.Columns.Add(length);

            using (var ctx = new AccountContext())
            {
                var playlists = ctx.Playlists.Where(x => x.User.Id == Global.UserId).ToArray();
                lstPlaylists.DataSource    = playlists;
                lstPlaylists.DisplayMember = "Name";
                lstPlaylists.ValueMember   = "Id";
            }
        }
Пример #7
0
        private void lvwSongs_ItemChecked(object sender, ItemCheckedEventArgs e)
        {
            ListViewItem item = e.Item;
            Song         song = item.Tag as Song;

            if (song != null)
            {
                using (var ctx = new AccountContext())
                {
                    var interaction = ctx.Interactions
                                      .Join(ctx.Users,
                                            i => i.User.Id,
                                            user => user.Id,
                                            (i, user) => new { i, user })
                                      .Join(ctx.Songs,
                                            si => si.i.Song.Id,
                                            s => s.Id,
                                            (si, s) => new { si, s })
                                      .FirstOrDefault(x => x.si.user.Id == Global.UserId && x.s.Id == song.Id);

                    if (interaction == null)
                    {
                        ctx.Interactions.Add(new Interaction()
                        {
                            User      = ctx.Users.FirstOrDefault(u => u.Id == Global.UserId),
                            Song      = ctx.Songs.FirstOrDefault(s => s.Id == song.Id),
                            Liked     = item.Checked ? true : false,
                            PlayCount = 0,
                            CreatedAt = DateTime.Now,
                            UpdatedAt = DateTime.Now
                        });
                    }
                    else
                    {
                        interaction.si.i.Liked     = item.Checked ? true : false;
                        interaction.si.i.UpdatedAt = DateTime.Now;
                    }
                    ctx.SaveChanges();
                }
            }
        }
Пример #8
0
        private void btnAddAlbum_Click(object sender, EventArgs e)
        {
            using (var ctx = new AccountContext())
            {
                var newAlbum = new Album
                {
                    Name      = txtName.Text,
                    Artist    = ctx.Artists.FirstOrDefault(x => x.Id == ((Artist)lstArtists.SelectedItem).Id),
                    CreatedAt = DateTime.Now,
                    UpdatedAt = DateTime.Now
                };

                ctx.Albums.Add(newAlbum);
                ctx.SaveChanges();
            }
            MessageBox.Show($"Album \"{txtName.Text}\" created!");
            Close();
            MainMenu main = new MainMenu();

            main.Show();
        }
Пример #9
0
        private void btnAddSong_Click(object sender, EventArgs e)
        {
            using (var ctx = new AccountContext())
            {
                ctx.Songs.Add(new Song
                {
                    Title     = txtTitle.Text,
                    Album     = ctx.Albums.FirstOrDefault(x => x.Id == ((Album)lstAlbums.SelectedItem).Id),
                    Artist    = ctx.Artists.FirstOrDefault(x => x.Id == ((Artist)lstArtists.SelectedItem).Id),
                    Length    = 380,
                    CreatedAt = DateTime.Now,
                    UpdatedAt = DateTime.Now
                });
                ctx.SaveChanges();
            }
            MessageBox.Show($"{txtTitle.Text} has been added to the album.");
            Close();
            MainMenu main = new MainMenu();

            main.Show();
        }
Пример #10
0
        private void btnPlay_Click(object sender, EventArgs e)
        {
            using (var ctx = new AccountContext())
            {
                Song song = lvwSongs.SelectedItems[0].Tag as Song;
                if (song != null)
                {
                    var interaction = ctx.Interactions
                                      .Join(ctx.Users,
                                            i => i.User.Id,
                                            user => user.Id,
                                            (i, user) => new { i, user })
                                      .Join(ctx.Songs,
                                            si => si.i.Song.Id,
                                            s => s.Id,
                                            (si, s) => new { si, s })
                                      .FirstOrDefault(x => x.si.user.Id == Global.UserId && x.s.Id == song.Id);

                    if (interaction == null)
                    {
                        ctx.Interactions.Add(new Interaction()
                        {
                            User      = ctx.Users.FirstOrDefault(u => u.Id == Global.UserId),
                            Song      = ctx.Songs.FirstOrDefault(s => s.Id == song.Id),
                            Liked     = false,
                            PlayCount = 1,
                            CreatedAt = DateTime.Now,
                            UpdatedAt = DateTime.Now
                        });
                    }
                    else
                    {
                        interaction.si.i.PlayCount++;
                        interaction.si.i.UpdatedAt = DateTime.Now;
                    }
                    ctx.SaveChanges();
                    MessageBox.Show("click");
                }
            }
        }
Пример #11
0
        private void lstPlaylists_SelectedIndexChanged(object sender, EventArgs e)
        {
            lvwSongs.SelectedItems.Clear();
            lvwSongs.Items.Clear();
            Playlist selectedPlaylist = lstPlaylists.SelectedItem as Playlist;

            using (var ctx = new AccountContext())
            {
                //HIER VERDER
                var playlists = ctx.Playlists.Include(nameof(Playlist.Songs)).Where(p => p.Id == selectedPlaylist.Id).ToList();


                foreach (var item in playlists)
                {
                    var songs = item.Songs.Join(ctx.Artists,
                                                s => s.Artist.Id,
                                                a => a.Id,
                                                (s, a) => new { s, a })
                                .Join(ctx.Albums,
                                      sa => sa.a.Id,
                                      alb => alb.Id,
                                      (sa, alb) => new { sa, alb });

                    foreach (var song in songs)
                    {
                        var liked   = ctx.Interactions.FirstOrDefault(l => l.User.Id == Global.UserId && l.Song.Id == song.sa.s.Id);
                        var addSong = lvwSongs.Items.Add(new ListViewItem(new string[]
                        {
                            song.sa.s.Title,
                            song.sa.a.Name,
                            song.alb.Name,
                            (TimeSpan.FromSeconds(song.sa.s.Length).ToString(@"mm\:ss"))
                        }));
                        addSong.Tag     = song.sa.s;
                        addSong.Checked = (liked != null && liked.Liked) ? true : false;
                    }
                }
            }
        }
Пример #12
0
 private void btnAddPlaylist_Click(object sender, EventArgs e)
 {
     using (var ctx = new AccountContext())
     {
         Playlist newPlaylist = new Playlist()
         {
             User      = ctx.Users.FirstOrDefault(u => u.Id == Global.UserId),
             Name      = txtPlaylistName.Text,
             CreatedAt = DateTime.Now,
             UpdatedAt = DateTime.Now
         };
         foreach (var item in lstPlaylistSongs.Items)
         {
             ctx.Songs.Attach(item as Song);
             newPlaylist.Songs.Add(item as Song);
         }
         ctx.Playlists.Add(newPlaylist);
         ctx.SaveChanges();
         MessageBox.Show($"Playlist {txtPlaylistName.Text} has been added.");
         MainMenu main = new MainMenu();
         main.Show();
         Close();
     }
 }