/// <summary> /// Adds a new race using query. Will close the original Edit Races window. /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnAccept_Click_1(object sender, EventArgs e) { //For more information: https://docs.microsoft.com/en-us/dotnet/framework/data/adonet/sql/linq/how-to-connect-to-a-database DnDataSetDataContext db = new DnDataSetDataContext(); //Table<Race> Races = db.GetTable<Race>(); if (txtName.Text == "") { MessageBox.Show("Invalid name"); } else { EditRaces n = new EditRaces(fontSize); if (beingEdited == false) { Race race = new Race { Name = txtName.Text, Strength = Convert.ToInt32(txtStr.Text), Dexterity = Convert.ToInt32(txtDex.Text), Constitution = Convert.ToInt32(txtCon.Text), Intelligence = Convert.ToInt32(txtInt.Text), Wisdom = Convert.ToInt32(txtWis.Text), Charisma = Convert.ToInt32(txtCha.Text) }; db.Races.InsertOnSubmit(race); db.SubmitChanges(); n.Show(); this.Close(); } else { var query = from race in db.Races where race.Id == raceID select race; foreach (Race races in query) { races.Name = txtName.Text; races.Strength = Convert.ToInt32(txtStr.Text); races.Dexterity = Convert.ToInt32(txtDex.Text); races.Constitution = Convert.ToInt32(txtCon.Text); races.Intelligence = Convert.ToInt32(txtInt.Text); races.Wisdom = Convert.ToInt32(txtWis.Text); races.Charisma = Convert.ToInt32(txtCha.Text); } try { db.SubmitChanges(); this.Close(); } catch (Exception exc) { MessageBox.Show($"Error: {exc}"); } } DialogResult = DialogResult.OK; } }