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())
{
}
}
