private void btnBewaar_Click(object sender, EventArgs e) { using (MuziekContext ctx = new MuziekContext()) { var result = ctx.Albums.FirstOrDefault(c => c.Name == txtAlbum.Text); if (txtAlbum.Text == " ") { MessageBox.Show("Geef het album in "); } else if (result != null) { MessageBox.Show("Album bestaat reeds "); txtAlbum.Text = " "; } else { // cbArtiest //int sel = cbArtiest.Get(cbArtiest.SelectedValue); ctx.Albums.Add(new Album() { A_ArtistId = Convert.ToInt32(cbArtiest.SelectedValue), Name = txtAlbum.Text, }); ctx.SaveChanges(); LoadList(); } } }
private void cbArtiest_SelectedIndexChanged(object sender, EventArgs e) { using (MuziekContext ctx = new MuziekContext()) { //var test = ctx.Albums.Where(a => a.A_ArtistId == cbArtiest.SelectedIndex); //foreach (var item in test) //{ // cbAlbum.DisplayMember = item.Name; // cbAlbum.SelectedValue = item.AlbumId; //} //var art = Convert.ToInt32(cbArtiest.SelectedValue); //var collect = ctx.Albums.Where(s => s.A_ArtistId = cbArtiest.SelectedIndex) //.Select(c => new { Id = c.AlbumId, IdA = c.A_ArtistId, Name = c.Name }).ToList(); var collect = ctx.Albums.Select(c => new { Id = c.AlbumId, IdA = c.A_ArtistId, Name = c.Name }).ToList(); cbAlbum.DataSource = collect; cbAlbum.DisplayMember = "Name"; cbAlbum.ValueMember = "Id"; cbAlbum.ValueMember = "IdA"; } }
private void btnBewaar_Click(object sender, EventArgs e) { using (MuziekContext ctx = new MuziekContext()) { var result = ctx.Songs.FirstOrDefault(c => c.Title == txtTitle.Text); if (txtTitle.Text == " ") { MessageBox.Show("Geef een song in "); } else if (result != null) { MessageBox.Show("Song bestaat reeds "); txtTitle.Text = " "; } else { // cbArtiest //int sel = cbArtiest.Get(cbArtiest.SelectedValue); ctx.Songs.Add(new Song() { S_ArtistId = Convert.ToInt32(cbArtiest.SelectedValue), S_AlbumId = Convert.ToInt32(cbAlbum.SelectedValue), Title = txtTitle.Text, Length = Convert.ToDouble(txtLengte.Text) }); ctx.SaveChanges(); // LoadList(); } } }
private void btnBewaar_Click(object sender, EventArgs e) { using (MuziekContext ctx = new MuziekContext()) { LoadList(); var result = ctx.Artists.FirstOrDefault(c => c.Name == txtArtiest.Text); if (result != null) { MessageBox.Show("artiest bestaat reeds"); txtArtiest.Text = " "; } else { //var date1; // DateTime dateOnly = DateTime.Now; //var currentDateTime = DateTime.Now; // var date = dateOnly.ToString("dd/MM/yyyy"); var date = DateTime.Now; ctx.Artists.Add(new Artist() { Name = txtArtiest.Text, CreatedAt = date.Date }); ctx.SaveChanges(); txtArtiest.Text = " "; } LoadList(); } }
private void cbArtiest_SelectedIndexChanged(object sender, EventArgs e) { using (MuziekContext ctx = new MuziekContext()) { //int index = Convert.ToInt32(cbArtiest.SelectedValue.ToString()); // int ind = Convert.ToInt32(index); // var col = ctx.Albums.Select(c => new { Id = c.AlbumId, Name = c.Name, Aid = c.A_ArtistId }).Where(c => c.Aid == index).ToList(); var col = ctx.Albums.Select(c => new { Id = c.AlbumId, Name = c.Name }).ToList(); // var col = ctx.Albums.Select(c => c.A_ArtistId == (Convert.ToInt32(cbArtiest.SelectedItem)) // .Where(c => new { Id = c.AlbumId, Name = c.Name, Aid = c.A_ArtistId }).ToList(); // var col = ctx.Albums.Select(c => c.A_ArtistId == index); cbAlbum.DataSource = col; cbAlbum.DisplayMember = "Name"; cbAlbum.ValueMember = "Id"; //foreach (var item in col) //{ // cbAlbum.Items.Add(new Album() // { // Name = item.Name, // AlbumId = item.Id // }); //} } }
private void btnVerwijder_Click(object sender, EventArgs e) { using (MuziekContext ctx = new MuziekContext()) { ctx.Artists.Remove(ctx.Artists.FirstOrDefault(c => c.Name == txtArtiest.Text)); LoadList(); } }
private void Form2_Load(object sender, EventArgs e) { // setTextboxText(); using (MuziekContext ctx = new MuziekContext()) { //var dag = ctx.Users.Select(c => c.Email == Form1.txtUserNaam.Text); // txtWelkom.Text = ctx.Users.FirstOrDefault(c => c.FirstName); } }
private void Form4_Load(object sender, EventArgs e) { using (MuziekContext ctx = new MuziekContext()) { var collection = ctx.Artists.Select(c => new { Id = c.ArtistId, Name = c.Name }).ToList(); cbArtiest.DataSource = collection; cbArtiest.DisplayMember = "Name"; cbArtiest.ValueMember = "Id"; } }
private void LoadList() { using (MuziekContext ctx = new MuziekContext()) { var collection = ctx.Artists.Select(c => new { Id = c.ArtistId, Name = c.Name }).ToList(); lstArtiest.DataSource = collection; lstArtiest.DisplayMember = "Name"; lstArtiest.ValueMember = "Id"; } }
private void btnSave_Click(object sender, EventArgs e) { using (MuziekContext ctx = new MuziekContext()) { ctx.PlaylistSongs.Add(new PlaylistSong() { Pl_SongId = Convert.ToInt32(cbSong.SelectedValue), Pl_PlaylistId = Convert.ToInt32(txtId.Text) }); ctx.SaveChanges(); } }
private void btn1Nieuw_Click(object sender, EventArgs e) { using (MuziekContext ctx = new MuziekContext()) { var kltId = Convert.ToInt32(txtKlantId.Text); var result = ctx.Playlists.Select(c => c.P_UserId == kltId); ctx.Playlists.Add(new Playlist() { P_UserId = kltId, Name = txtPlaylist.Text }); ctx.SaveChanges(); } }
private void Form6_Load(object sender, EventArgs e) { using (MuziekContext ctx = new MuziekContext()) { var kltId = Convert.ToInt32(txtKlantId.Text); var userPlaylists = ctx.Playlists.Where(p => p.P_UserId == kltId); foreach (Playlist playlist in userPlaylists) { ComboboxItem newItem = new ComboboxItem(playlist.PlaylistId, playlist.Name); cbPlaylist.Items.Add(newItem); } var collection = ctx.Playlists.Select(c => new { Id = c.PlaylistId, Name = c.Name }).ToList(); lstPlaylist.DataSource = collection; lstPlaylist.DisplayMember = "Name"; lstPlaylist.ValueMember = "Id"; } }
public void CreateUser() { using (MuziekContext ctx = new MuziekContext()) { txtNaam.Enabled = true; txtVoornaam.Enabled = true; ctx.Users.Add(new User() { Email = txtUserNaam.Text, Password = txtPass.Text, FirstName = txtVoornaam.Text, LastName = txtNaam.Text }); ctx.SaveChanges(); txtNaam.Text = " "; txtPass.Text = " "; txtUserNaam.Text = " "; txtVoornaam.Text = " "; } }
private void button1_Click(object sender, EventArgs e) { int listId = Convert.ToInt32(cbPlaylist.SelectedIndex); var list = cbPlaylist.SelectedItem.ToString(); if (list == null) { MessageBox.Show("Kies een playlist of maak een nieuwe aan"); } else { using (MuziekContext ctx = new MuziekContext()) { var coll = ctx.PlaylistSongs.Select(c => c.Pl_PlaylistId == listId); foreach (var item in coll) { lvwSongs.Items.Add(Name); } } } }
private void btnLogin_Click(object sender, EventArgs e) { using (MuziekContext ctx = new MuziekContext()) { var result = ctx.Users.FirstOrDefault(c => c.Email == txtUserNaam.Text && c.Password == txtPass.Text); if (result != null) { // var klant = ctx.Users. var klant = result.FirstName + " " + result.LastName; var klantID = result.UserId; Form2 form2 = new Form2(klant, klantID); // Form2.SetTextboxText(klant); form2.Show(); } else { CreateUser(); } } }
private void cbPlaylist_SelectedIndexChanged(object sender, EventArgs e) { using (MuziekContext ctx = new MuziekContext()) { } }
private void lstSongs_SelectedIndexChanged(object sender, EventArgs e) { using (MuziekContext ctx = new MuziekContext()) { } }