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 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 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 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(); } }
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 = " "; } }