private void buttonSave_Click(object sender, EventArgs e) { if (this.WindowPanelEditor.Controls.Count != 0) { if (authorTextfield.Text.Trim() != "" && titelSongTextField.Text.Trim() != "") { int counterForAbsX = 0; List <SongComponent> compiledList = new List <SongComponent>(); foreach (var list in this.WindowPanelEditor.Controls.OfType <Row>()) { for (int i = 0; i < list.ListWithSongComponents.Count; i++) { SongComponent tempComponent = list.ListWithSongComponents[i]; tempComponent.AbsoluteX = counterForAbsX; compiledList.Add(tempComponent); counterForAbsX += 2; } } using (DatabaseContext db = new DatabaseContext()) { db.Songs.Add(new Song() { Author = authorTextfield.Text, Level = Int32.Parse(levelSelectBox.SelectedValue.ToString()), Name = titelSongTextField.Text }); db.SaveChanges(); Song song = db.Songs.Select(x => x) .Where(x => x.Name == titelSongTextField.Text && x.Author == authorTextfield.Text) .FirstOrDefault(); int songId = song.SongID; foreach (SongComponent sc in compiledList) { sc.songID = songId; sc.X = (sc.X % 8); db.SongComponents.Add(sc); } db.SaveChanges(); MessageBox.Show("Het lied is toegevoegd"); wsvc.Show(); this.Close(); } } } else { MessageBox.Show("U heeft geen rijen aangemaakt"); } }
private void buttonSave_Click(object sender, EventArgs e) { if (authorTextfield.Text.Trim() != "" && titelSongTextField.Text.Trim() != "") { int counterForAbsX = 0; List <SongComponent> compiledList = new List <SongComponent>(); foreach (var list in this.WindowPanelEditor.Controls.OfType <Row>()) { for (int i = 0; i < list.ListWithSongComponents.Count; i++) { SongComponent tempComponent = list.ListWithSongComponents[i]; tempComponent.AbsoluteX = counterForAbsX; compiledList.Add(tempComponent); counterForAbsX += 2; } } if (compiledList.Count == 0) { MessageBox.Show("Lied bevat geen componenten"); return; } using (DatabaseContext db = new DatabaseContext()) { var result = db.Songs.Where(x => x.Name == titelSongTextField.Text && x.Author == authorTextfield.Text); if (result.Count() >= 1) { MessageBox.Show("Lied met dezelfde titel en auteur bestaat al! Kies a.u.b. een andere titel of auteur."); return; } Song song = new Song() { Author = authorTextfield.Text, Level = Int32.Parse(numericUpDown1.Value.ToString()), Name = titelSongTextField.Text }; db.Songs.Add(song); db.SaveChanges(); int songId = song.SongID; foreach (SongComponent sc in compiledList) { sc.songID = songId; sc.X = (sc.X % 8); db.SongComponents.Add(sc); } db.SaveChanges(); this.Hide(); wsvc.Show(); MessageBox.Show("Het lied is toegevoegd"); } } }