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